|
Why use a database?
What does a database consist of?
Starting Access
Understanding content security
Setting Access Options
Using the Quick Access Toolbar
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
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 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
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
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/un-hiding a field
|