 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access XP 2002 Level 3; Advanced
Course Aims
To build on a reasonable level of database design experience that may have been gained from our "Microsoft Access XP 2002 Level 1; Introduction" course and/or "Microsoft Access XP 2002 Level 2; Intermediate" course. Readers will learn about managing relational databases, customising forms, optimising Access, administering Access and database security. |
Assumed Knowledge
This course assumes a reasonable level of database design principles that may have been gained from our our "Microsoft Access XP 2002 Level 1; Introduction" and/or our "Microsoft Access XP 2002 Level 2; Intermediate" courses. |
Course Audience
People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases. Sharing and security is also covered. |
|
Table of Contents
|
Managing Relational Databases
|
Normalisation With the Table Analyzer Wizard
|
|
|
|
Customising Forms
|
Altering the Control Properties
|
|
Check Boxes, Option & Toggle Buttons
|
|
Entering A Page Number Control
|
|
To Enter A Date And Time Control
|
|
Using Form’s Input Values
|
|
Create A Form With Multiple Pages Or Tabs
|
|
Creating A Form With More Than One Page (Screen)
|
|
Inserting Graphics in Forms or Reports
|
|
To Create A Bound Object Frame Control
|
|
|
|
Optimising and Administering Access
|
Optimising General Table Performance
|
|
Achieving Optimal Performance with Linked Tables
|
|
Optimising Multi-user Performance
|
|
Recovering Damaged Databases
|
|
Importing and Linking Tables
|
|
To Import A Table From Another Access Database
|
|
To Link A Table From Another Access Database
|
|
|
Database Security
|
Adding A Database Password
|
|
Setting User Level Security
|
|
Joining An Access XP Workgroup
|
|
Activating the Logon Procedure
|
|
Creating and managing security accounts
|
|
Creating New User Accounts
|
|
Creating A Security Group Account
|
|
Adding New Accounts To A Group
|
|
Removing Accounts From Security Groups
|
|
To View or Transfer Ownership Of An Individual Object Within A Database
|
|
Assigning and Removing Permissions
|
|
To Assign Default Permissions For New Objects
|
|
Encrypting and Decrypting a Database
|
|
|
|
Appendix A: New Features in Access XP - Overview
|
Outputting a Report to Snapshot File Format
|
|
E-mailing Database Information
|
|
Improved Proofing Tools in XP
|
|
Conditional Formatting in Forms
|
|
Grouping Text Boxes and other Controls
|
|
Working with Data Access Pages
|
|
Miscellaneous New Features in Access 2002
|
|
|
|
Appendix B: New Features in Office XP - Overview
|
View Office XP Features Common across Applications
|
|
Office Email Introduction
|
|
Other New Features in Office XP
|
|
Document recovery and safer shutdown
|
|
|
|
Appendix C: Introduction to SQL (fundamentals)
|
Data Manipulation Language
|
|
|
|
|
|
