AudienceThis course is designed for individuals interested in learning the skills necessary to design and create new databases, tables, and relationships, locate records using queries, create forms and produce reports.

DescriptionUpon completion of this course, individuals will be able to:
  • Identify the basic components of a Microsoft Office Access 2010 database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports

PrerequisitesMicrosoft Office Windows experience

Suggested Class SizeMinimum 3
Maximum 12

Course LengthFull day

ContentLesson 1: Getting Started with Access Databases
  • Topic 1A: Identify the Elements of the Access 2010 Interface
    Topic 1B:
    Identify the Components of a Database
    Topic 1C: Examine the Relational Database Design Process
Lesson 2: Building the Structure of a Database
  • Topic 2A: Create a New Database
    Topic 2B: Create a Table Using the Design View
    Topic 2C: Manage Tables
    Topic 2D: Establish Table Relationships
Lesson 3: Managing Data in a Table
  • Topic 3A: Modify Table Data
  • Topic 3B: Sort and Filter Records
  • Topic 3C: Work with Subdatasheets
Lesson 4: Querying a Database
  • Topic 4A: Create a Query
  • Topic 4B: Add Criteria to a Query
  • Topic 4C: Add a Calculated Field to a Query
  • Topic 4D: Perform Calculations on a Record Grouping
Lesson 5: Designing Forms
  • Topic 5A: Create a Form
    Topic 5B: Modify the Design of a Form
    Topic 5C: View and Edit Data Using an Access Form
Lesson 6: Generating Reports
  • Topic 6A: Create a Report
    Topic 6B: Add a Control to a Report
    Topic 6C: Format the Controls in a Report
    Topic 6D: Enhance the Appearance of a Report
    Topic 6E: Prepare a Report for Print