Module 1: Modifying Table Structure - Using the Object Inspector
- Designing a Table
- Creating and Formatting Fields
- Setting the Primary Key
- Defining Data Entry Criteria
- Keeping Data Within a Range
- Specifying Data Entry Formats
- Using Required Fields
- Using Lookup Tables
- Borrowing an Existing Table Format
- Creating Secondary Indexes
Module 2: Designing Forms - Designing a Form
- Modifying a Form
- Displaying Multiple Records
- Adding and Deleting Fields
- Creating Graphic Objects
| Module 3: Designing and Producing Reports - Creating a New Report
- Using a Report with a Different Table
- Customizing the Report Design
- Using Report Bands
- Customizing Bands
- Creating Crosstabs and Graphs
- Creating a Crosstab
- Creating a Graph
- Producing Mailing Labels
Module 4: Creating and Using Queries - Creating a New Query
- Using Search Criteria and Keywords
- Specifying Multiple Selection Criteria
- Saving the Answer Table
- Using Summary Operators
- Using Calculated Fields and Reserved Words
- Using Complex Queries
- Changing Table Values with Queries
|