MS Access Course Content

INTRODUCTION

• Database terminology
• Creating a new database
• The Database window
• Creating tables
• Working with data in tables
• Manipulating data in tables
• Table Relationships
• Using data in related tables
• Creating Forms
• Working with data in forms
• Creating Queries
• Creating Reports
• Printing options

INTERMEDIATE

• Planning and design
• Creating tables – formatting options
• Tables in data view
• Table relationships
• Using queries to find data
• Using calculations in queries
• Forms in Design view
• Forms – using the Toolbox
• Forms based on queries
• Reports in Design view
• Using calculations on reports

ADVANCED

• Principles of database design
• Importing data into Access
• Exporting data from Access
• Mail Merge
• Advanced Table features
• Advanced Queries
• Advanced form design
• Forms – creating Action buttons
• Forms – auto formats
• Reports and creating buttons
• Macros