Module 1: Data Integrity

This module discusses ways to help ensure the accuracy of data entered into a database.

Lessons

• Restricting the Type of Data in a Field
• Restricting the Amount of Data in a Field
• Specifying the Format of Data in a Field
• Restricting Data by Using Validation Rules
• Creating a Simple Lookup List
• Creating a Multi-Column Lookup List
• Key Points

Lab: Data Integrity

• Add fields and restrict data types.
• Change the Field Size property.
• Use input masks to format data.
• Create and test validation rules.
• Use the Lookup wizard to create a list.
• Use the Lookup wizard to create a two-column list.

After completing this module, students will be able to:

Module 2: Custom Forms

This module explains how to customize forms to facilitate data entry and display.

Lessons

• Adding Controls to a Form
• Entering Data in a Form by Using VBA
• Creating a Form by Using an AutoForm
• Adding a Subform to a Form
• Key Points

Lab: Custom Forms

• Add, replace, and delete controls.
• Enter data in a form by using VBA.
• Use the Form wizard to create a form.
• Displaying a subform within a main form.

After completing this module, students will be able to:

Module 3: Queries

This module explains how to search for records that match multiple-criteria by using advanced filtering and queries, as well as how to perform calculations and update and delete table information.

Lessons

• Locating Information That Matches Multiple Criteria
• Creating a Query by Using a Wizard
• Creating a Query Manually
• Performing Calculations by Using a Query
• Updating Information in a Table
• Deleting Information from a Table
• Key Points

Lab: Queries

• Find information that matches two criteria while exploring the design grid.
• Create a query based on two related tables.
• Create a query that calculates a new field.
• Summarize the values in records selected by a query.
• Create a query to update table data.
• Create a query to delete table data.

After completing this module, students will be able to:

Module 4: Reports

This module explains how to extract information from a database as a report. It also explains how to modify report design and content, add subreports to reports, and preview and print reports.

Lessons

• Creating a Report by Using a Wizard
• Modifying Report Design
• Creating a Report Manually
• Modifying Report Content
• Adding a Subreport to a Report
• Previewing and Printing a Report
• Key Points

Lab: Reports

• Use the Report wizard to create a report based on two tables.
• Change the layout and formatting of a report.
• Create a report from scratch.
• Modify the content of a report.
• Display calculations in a subreport of a main report.
• Preview a report and review printing options.

After completing this module, students will be able to:

Module 5: Database Management

This module explains how to make databases easier to use while protecting them from unauthorized users and carrying out preventive maintenance.

Lessons

• Making Favorite Access Commands Quickly Available
• Creating Custom Categories
• Assigning a Password to a Database
• Preventing Database Problems
• Key Points

Lab: Database Management

• Add a button to the Quick Access Toolbar.
• Create a custom category with groups and objects.
• Protect a database with a password.
• Back up a database, and run utilities to detect problems.

After completing this module, students will be able to:

Module 6: Database Distribution

This module explains more ways to protect databases that will be used by multiple people on multiple computers.

Lessons

• Creating a Switchboard
• Controlling the Features Available to Database Users
• Preventing Changes to Database Code
• Securing a Database for Distribution
• Key Points

Lab: Database Distribution

• Create a switchboard with one-click navigation to forms, reports, and two common actions.
• Set and bypass startup options.
• Assign a password to database code.
• Save a database as an ACCDE file.

After completing this module, students will be able to: