Getting Started
- Why Use a Database?
- What Does a Database Consist of?
- Starting Access
- Opening a Database
- Understanding the Screen
- Using the Navigation Pane
- Giving Commands
- Closing a Database and the
Application
- Opening a Table
- Closing a Table
- Displaying Records with the
Mouse/Keyboard
- 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 a Field in a Query
- Deleting a Field in a Query
- Saving a Query
Sorting in a Query
- Sorting Data with Visible Columns
- 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 Criterion
- Selecting the Records in a Query
- What is a Value?
- Clearing a Single Criterion
- Using Logical Criteria
- Using Wildcards in Criteria
- Searching for No Value (Nulls)
- Using Criteria with Hidden Columns
|
Query with Multiple Criteria
- Searching for a Range of Values
- Searching for Multiple Values in a
Single Field
- Using "And" Criterion in Multiple Fields
- Using "Or" Criterion in Multiple Fields
- Deleting and Inserting Criteria Rows
Building the Database/Tables
- Creating a Database
- Creating a Table
- Naming a Field in a Table
- Selecting Field Data Types and
Properties
- Saving a Table
- The Primary Key Field
- Inserting a Field
- Moving a Field
- Deleting a Field
- Renaming a Field
Formatting and Printing a Datasheet
- Changing the Field Width
- Changing the 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 (Optional)
I. Moving a Field (Optional)
J. Hiding a Field (Optional)
K. Unhiding a Field (Optional)
|