This module discusses the Access interface and explores various database components, including tables, forms, queries, and reports.

Lessons
•Working in Access 2010
•Understanding Database Concepts
•Exploring Tables
•Exploring Forms
•Exploring Queries
•Exploring Reports
•Previewing and Printing Access Objects

Lab : Working in Access 2010

Lab : Exploring Tables

Lab : Exploring Forms

Lab : Exploring Queries

Lab : Exploring Reports

Lab : Previewing and Printing Access Objects

After completing this module, students will be able to:
•Work in the Access environment.
•Describe how a database works.
•Open and move around in tables, forms, queries, reports, and other Access objects.
•Preview and print objects, such as tables and forms.

This module explains how to create databases and tables, either manually or from templates, and how to change table formatting and structure. It also explains how to create relationships between tables.

Lessons
•Creating Databases from Templates
•Creating Databases and Tables Manually
•Manipulating Table Columns and Rows
•Refining Table Structure
•Creating Relationships Between Tables

Lab : Creating Databases from Templates

Lab : Creating Databases and Tables Manually

Lab : Manipulating Table Columns and Rows

Lab : Refining Table Structure

Lab : Creating Relationships Between Tables

After completing this module, students will be able to:
•Create databases in various ways.
•Add tables to a database.
•Rearrange and size table columns and rows.
•Modify, add, and delete table fields.
•Define table relationships.

This module explains how to create forms to view and enter data, modify the appearance of a form, and customize the layout of a form.

Lessons
•Creating Forms by Using the Form Tool
•Changing the Look of Forms
•Changing the Arrangement of Forms

Lab : Creating Forms by Using the Form Tool

Lab : Changing the Look of Forms

Lab : Changing the Arrangement of Forms

After completing this module, students will be able to:
•Use the Form Tool to create a form based on a table.
•Change the form’s properties.
•Change the form’s layout.

This module explains how to display information in useful ways, by sorting and filtering tables, and by filtering information in forms.

Lessons
•Sorting Information in Tables
•Filtering Information in Tables
•Filtering Information by Using Forms
•Locating Information That Matches Multiple Criteria

Lab : Sorting Information in Tables

Lab : Filtering Information in Tables

Lab : Filtering Information by Using Forms

Lab : Locating Information That Matches Multiple Criteria

After completing this module, students will be able to:
•Find information by sorting and filtering in tables.
•Display information by filtering in forms.
•Use the Advanced Filter/Sort command to find records that meet multiple criteria.

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

Lessons
•Creating Reports by Using a Wizard
•Modifying Report Design
•Previewing and Printing Reports

Lab : Creating Reports by Using a Wizard

Lab : Modifying Report Design

Lab : Previewing and Printing Reports

After completing this module, students will be able to:
•Create reports to extract information from a database.
•Customize the design of reports.
•Provide neatly printed copies of reports.