 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2002 (XP) Professional
Course Aims
To introduce existing Microsoft Access 2002 users to administrative functions of the application, along with the techniques required to create a fully-functioning, automated RDBMS. By the end of the course you will have confidence in your ability to design and build robust databases that provide a consistent and clear interface to your users. |
Assumed Knowledge
Readers must be able to create tables, queries, forms and reports in design view, establish table relationships and create calculated fields using expressions. |
Course Audience
This course will benefit existing users of Microsoft Access for windows who want to customise databases using macros and gain knowledge of the more advanced tools. |
|
Table of Contents
|
Exporting and Analysing Access Data
|
Analyse Data Using MS Excel
|
|
PivotTables and Charts in Access
|
|
Creating an Embedded PivotTable or PivotChart
|
|
Use a PivotTable List on an Access Form
|
|
Use a PivotChart on an Access Form
|
|
|
|
Action Queries
|
Create a Make Table Query
|
|
|
|
Database Management Tools
|
Documenting the Database Structure
|
|
Backing Up and Restoring a Database
|
|
Compacting and Repairing a Database
|
|
Setting a Database Password
|
|
|
Multi-User Databases
|
Make Design Changes in a Shared Database
|
|
Secure an Access Database
|
|
Configure User and Group Accounts
|
|
Configure Account Permissions
|
|
Splitting an Access Database
|
|
Changing the Location of the Back-end Database
|
|
|
|
|
Using Macros in a Database Application
|
|
|
Designing an Access Application
|
Designing Menus Bars and Toolbars
|
|
Customising Menus and Toolbars
|
|
Create an Application Switchboard
|
|
Adding Help Screens to an Application
|
|
Using Help Topics for an Access Application
|
|
|
|
|
Glossary
|
|
|
|
|
