 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2007 Intermediate
Course Aims
his course is designed to help you to obtain the skills required to create a relational database. You will learn relational database concepts and practice and understand the importance of documenting and maintaining database files. You will learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting. |
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Access 2003 Introduction". You should be able to use Microsoft Access to create a database, tables, queries, forms, and reports. |
Course Audience
Those wanting to design relational database structures using Access and master the design and customisation tools available for queries, forms, and reports. |
|
Table of Contents
|
Advanced File Tasks
|
Using My Computer With Access
|
|
|
|
Working With Tables
|
Controlling Table Data Entry
|
|
Managing Table Data Entry
|
|
|
|
|
Working With Forms
|
|
|
Working With Reports
|
|
|
Working With Queries
|
Management (Action) Queries
|
|
|
|
|
|