Ebook: Access 2010. Part II. Tables and Queries

The Mouse Training Company & Ventus Publishing ApS, 2011. – 201 p.Contents:
Tables.
Creating Tables.
Primary Key.
Format Data and appearance (Design View).
Relationships.
Controlling Data Entry In a Table.
Creating A Lookup Field.
Enter Data In a Table.
Formatting A Table in Datasheet view.
Working with records.
Sorting and Finding Data In a table.
Filtering data in a table.
Using Advanced Filter Options.
Changing Field Data Types.
Queries.
Creating Queries.
Basic Query use.
Filtering a Query.
Select Queries and criteria.
Using Multiple Tables In Queries.
Building queries on queries.
Parameter Queries.
Crosstab Query.
Action Queries.