Microsoft Access: Introduction to Intermediate

Course details

This two-day course is designed to help a delegate to obtain the skills required to update records in a database and to use Microsoft Access to create a basic database. A delegate will learn to design tables and queries to to create forms using built-in tools. A delegate will also learn to create relational databases and Import & Export data.

Course Outline

Module 1

• What is Microsoft Access?
• What is a Database?
• Database Terminology
• The Database Foundation
• Access Wizards
• Ground Rules for Database Design
• Starting Microsoft Access
• The Microsoft Access Work Screen
• Creating a Blank Database
• Database Window Toolbar
• Creating a Database — Database Wizard
• Saving/Closing/Opening a Database
• Working in a Database Window
• View Operating Modes
• Object Properties
• Backup a Database

Module 2

• Creating a Table with the Table Wizard
• Creating a Table from Scratch
• Understanding Data Types & Formats
• Primary Key
• Editing a Table
• Entering Data into a Table
• Editing Data in a Table
• Datasheet View
• Formatting a Table / Datasheet
• Finding Records
• AutoCorrect
• Spell Check
• Find & Replace
• Filter & Sort Tables
• Create Hyperlinks

Module 3

• Fields & Formats
• Edit Field Attributes
• Set Value Limits
• Validation Rule Expressions
• Use Default Values
• Create Required Fields
• Use Input Masks
• Defining Indexes
• Lookup Fields

Module 4

• What are Forms?
• Creating a Form — AutoForm
• Creating a Form — Form Wizard
• Creating a Form from Scratch
• Editing a Form
• Formatting a Form
• Changing the Tab Order
• Searching for Data in a Form
• Use Calculated Fields in a Form

Module 5

• Creating a Query — Wizard
• Query Basics
• Printing Query Results
• Modify a Query
• Create a Select Query
• Sorting Query Data
• Use Multiple Criteria (And/Or)
• Create a Calculation Query
• Use an Action Query
• Create a Parameter Query

Module 6

• Importing & Exporting Data
• Export to Excel
• Import from Excel
• Export to a Text File
• Import a Text File
• Import a dBASE File
• Import an Access Object

Module 7

• Data Relations
• Primary & Foreign Keys
• Use Analyzing Tools
• Establish Simple Relationships
• Establish Complex Relationships
• Referential Integrity
• Subdatasheets

Module 8

• Creating Reports — AutoReport
• Creating Reports — Report Wizard
• Layout a Report
• Modify Display Attributes
• Use Calculated Fields & Printing