| | - Students will learn the basic skills necessary to begin using Access. They will design and create databases, tables, queries, forms, and reports. Specific Access knowledge requirements can be accommodated within the skill level of the student. Intermediate and advanced students learn more about database design and manipulation. Students expand their knowledge of how to extract information through Queries, Reports and Pivot table forms.
- Overview of Access
- Creating tables
- Working with tables
- Creating and Using Select Queries
- Creating and Using Forms
- Creating and Using Reports
- Principles of Table Design
- Principles of Table Relationships
- Table Design Techniques
- Designing Select Queries
- Customizing Form Designs
- Customizing Reports
- Parameter and Action Queries
- Query Joins and Crosstab Queries
- Using Advanced Form Techniques
- Creating a Switchboard Form
- Creating a Splash Screen Form
|
