Access 2010 Introduction
Audience
This course is designed for individuals with a strong understanding of the Microsoft Office Suite and who want to use and create a relational database in Access.
Structure
This course is a combination of lecture and hands-on guided instruction. Course manual and quick reference guide provided.
Course Length
Two Days
Topics
Understand databases
- Work with database terms
- Understand the benefits of a relational database
Explore Access
- Database objects
- Navigation buttons
- Perform basic operations
Create a database
- Understand design requirements
- Define fields
- Purpose of primary and foreign keys
- Define field properties
- Use naming conventions
Define permanent relationships
- Primary key to foreign key
- Enforce referential integrity
- Print database relationships
Import data
- Excel data
- Access data
Query tables
- Define sorts
- Add criteria
- Create an and/or query
- Create calculated fields
- Parameter queries
- Summarize data
Create reports
- Wizard based reports
- Modify reports
- Create reports in layout view
- Create reports from scratch
- Special tools
- Add fields, text boxes, and labels
Create forms
- Wizard based forms
- Modify forms
- Create forms from scratch
- Special tools
- Add fields, text boxes, and labels
PDF