Access 2010: Part II
Access 2010 is a powerful Database application that allows users to produce tables, forms, queries and reports within a database it can also contain calculations, graphs, pictures and files. This ebook is the second part of a series of four ebooks. In the first part Access 2010: Learn Access you found an introduction to Access 2010. In this part you will learn how to create tables and queries.
Tables are the main objects used in databases. (Without tables, and thus without data, you don’t have much of a database!) In Access 2010: Part I you learned that a table contains one or more records (or rows of data) and a record contains one or more fields. In this ebook you will go a step further and learn much more about the usage of tables, including how to build them from scratch. Further you will learn how to set field properties, create lookup fields and relate tables.
A query is a question that is asked of a database control program about the data it contains. We specify what particular fields we are interested in finding out, tell the database where to look for those fields, and specify any conditions under which to search. In this ebook you will learn to understand the use of queries, to use the query wizard and to build basic queries in Query design. Furthermore you will learn more about applying criteria and building calculations.
Access 2010 is a powerful Database application that allows users to produce tables, forms, queries and reports within a database it can also contain calculations, graphs, pictures and files. This ebook is the second part of a series of four ebooks. In the first part Access 2010: Learn Access you found an introduction to Access 2010. In this part you will learn how to create tables and queries.
Tables are the main objects used in databases. (Without tables, and thus without data, you don’t have much of a database!) In Access 2010: Part I you learned that a table contains one or more records (or rows of data) and a record contains one or more fields. In this ebook you will go a step further and learn much more about the usage of tables, including how to build them from scratch. Further you will learn how to set field properties, create lookup fields and relate tables.
A query is a question that is asked of a database control program about the data it contains. We specify what particular fields we are interested in finding out, tell the database where to look for those fields, and specify any conditions under which to search. In this ebook you will learn to understand the use of queries, to use the query wizard and to build basic queries in Query design. Furthermore you will learn more about applying criteria and building calculations.
PDFFile size: 4.7MB
Comments for "Access 2010: Part II"
How To Get Started Using Microsoft Access Even If You've Never Used It Before
By: Paul Barnett
This FREE eBook includes a useful guide that will get you up and running fast. Learn the basics of tables, forms, sub forms, and queries; whether you want to learn for business or personal use! Download it today!
iWork - Numbers
By: Mark Wood
We all need to use productivity software for word processing, to reconcile budgets, or to make presentations. Apple users have the option to use iWork software, from Apple, to perform these tasks. This is one of three guides that explore the essential features and functions of one of the three applications that make up the iWork Suite. This guide investigates Numbers for Apple’s OSX. Numbers ...