Microsoft Access 2000 Professional

Course Aims
This intensive training course is designed to give advanced users of Microsoft Access 2000 further tips on how to get the most from the software. This entirely 'hands on' course will give a further understanding of customising databases through command buttons, macros and menus and using the database management tools within Microsoft Access 2000.
Who Should Attend?
Existing users of Microsoft Access 2000 who want to customise databases using macros and gain knowledge of the more advanced tools. Note : A thorough working knowledge of Microsoft Access 2000 is required.
Course Outline: Microsoft Access 2000 Professional
Database Management Tools
· Database Administration · Documenting the Database Structure · Backing Up and Restoring a Database · Compacting and Repairing a Database · Setting a Database Password · Encrypting and Decrypting a Database
Multi-User Databases
· Shared Databases · Setting Default Locking Properties · Creating Groups and Users · Setting User Permissions · Assigning Ownership · Splitting an Access Database · Changing the Location of the Back-end Database
Creating Macros
· What is a Macro? · Creating a Macro · Running a Macro · Using Macros with Events · Macro Examples
Importing, Exporting, and Linking Data
· Importing from Other Data Sources · Linking Data · Exporting Data
Analysing Access Data in Excel
· PivotTables and Charts in Access · Creating an Embedded PivotTable · Editing a PivotTable · Creating a Chart · Editing a Chart · The Graph Toolbar · Choosing a Chart Type · Adding Chart Elements
Designing an Access Application
· Designing Menus Bars and Toolbars · Customising Menus and Toolbars · Customising Startup · Adding Help Screens to an Application · Using Help Topics for an Access Application