Getting Started

• Why use a database? 
• What does a database consist of? 
• Starting Access 
• Opening and closing a database 
• Opening and closing a table 
• Viewing a table 
• Editing and deleting data in a record 
• Adding data in a table 
• Deleting a record from a table 
• Finding data 

Basic Query

• What is a query? 
• Opening and closing a query 
• Designing a query 
• Switching between design and datasheet 
• Creating a query 
• Adding and removing a table from a query 
• Adding or deleting a field in a query 
• Saving a query 

Sorting in a Query

• Sorting data with visible fields 
• Moving the fields in a query 
• Adding all fields in a query 
• Deleting all fields in a query 
• Sorting data with hidden columns 
• Quick sort 

Query with Single Criteria

• Selecting the records in a query 
• What is a value? 
• Clearing a single criteria 
• Using logical criteria 
• Using wildcards in criteria 
• Searching for no value 
• Using criteria with hidden columns 
• Quick filter 

Query with Multiple Criteria

• Searching for a range of values 
• Searching for multiple values in a single field 
• Using "And" and "Or" criteria in multiple fields 
• Deleting and inserting criteria 

Building the Database/Table

• Creating a database 
• Creating a table 
• Naming a field in a table 
• Selecting field data types and arguments
• Saving a table 
• Switching between design and datasheet 
• Primary key field 
• Renaming a field 
• Deleting a field 
• Moving a field 
• Inserting a field 

Formatting and Printing a Datasheet

• Changing the field width/record height 
• Freezing fields on the screen and printout 
• Formatting cells 
• Printing a table or query 
• Changing the page setup 
• Exporting a table or query 
• Changing the font 
• Moving/hiding/unhiding a field