|
Introduction to Microsoft Access
- What is a relational Database
- What are Access Objects
- Database design concepts
- Relationships between tables
Working with an Access Table
- What are fields and records
- How to navigate through records
- How to enter, edit and delete records
- How to format tables
- Filtering data in tables
Designing Access Tables
- Using design view
- Adding and naming fields
- Assigning Field types
- Assigning Field Properties
- Creating Key Fields
- Creating relationships
|
Designing Access Queries
- Using And and Or statements
- Parameter Queries
- Autolookup Queries
- Designing Forms
What are Access forms
- Designing a Form using the Wizard
- Formatting forms
- Adding controls
- Working with combo boxes
Access Report Design
- Creating a report using the Wizard
- Formatting Reports
|
