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.
| This course consists of 8 modules |
| Module One |
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 Two |
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 Three |
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 Four |
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 Five |
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 Six |
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 Seven |
Data Relations
Primary & Foreign Keys
Use Analyzing Tools
Establish Simple Relationships
Establish Complex Relationships
Referential Integrity
Subdatasheets |
| Module Eight |
Creating Reports — AutoReport
Creating Reports — Report Wizard
Layout a Report
Modify Display Attributes
Use Calculated Fields & Printing |
