COURSE SEARCH
 
   HOME > COURSE > MICROSOFT ACCESS 2000 PROFESSIONAL MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Access 2000 Professional



Course Aims
This intensive course is designed to give advanced users further tips about how to get the most out of Access. This entirely 'hands on' course will give readers a further understanding of customising databases through command buttons, macros and menus and using the database management tools.
Assumed Knowledge
A thorough knowledge of Microsoft Access gained through use of the product or by studying "MS Access 2000 Advanced" training course.
Course Audience
Existing users of Microsoft Access for windows who want to customise databases using macros and gain knowledge of the more advanced tools.

This course can be found in the following categories:
Course Library > Databases > Access 2000
Course Library > Microsoft > Office 2000
Course Library > Microsoft > Access
Course Library > MOS

Table of Contents
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
    Access Macros
  • What is a Macro?
  • Creating a Macro
  • Running a Macro
  • Using Macros with events
  • Macro examples
     
    Analyzing Access data in Excel
  • Embedding Pivot tables and charts in Access
     
    Designing an Access application
  • Designing Menus and Toolbars
  • Customising Menus and Toolbars
  • Customising Startup
  • Adding help screens to an application
    TRY BEFORE YOU BUY BECOME A RESELLER
    Sunday 5th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft