The latest learning Solutions and Training  
 - At Affordable Prices!

Microsoft Access 2000
Advanced Training  

Our course is loaded with general information on each of these topics, covering the basics and providing more advanced information for individuals already familiar with this subject. The course is supported with numerous tips, examples, and interactive questions to help you understand this subject and includes a special "Bookmark" feature so you can learn at your own pace.

TOPICS COVERED

Unit 1: Creating Advanced Queries

Querying for Top Values
Creating an Advanced Parameter Query
Modifying Query Properties 
Creating an Update Query
Creating a Make-Table Query
Creating an Append Query
Creating a Delete Query
Specifying Join Properties
Practice

Unit 2: Creating Advanced Forms and Reports

Adding Check Boxes and Toggle Buttons
Using Conditional Formatting 
Creating Custom Help
Adding Tab Controls
Adding Charts
Modifying Charts
Adding Subreport Controls
Modifying Section Properties
Practice

Unit 3: Managing Database Objects

Working with Objects
Using the Documenter
Grouping Objects
Modifying Groups
Creating a Dialog Box
Creating a Pop-up Form
Creating a Switchboard
Modifying a Switchboard
Practice

Unit 4: Creating Macros

Understanding Macros
Creating a Macro
Modifying Actions and Arguments
Creating a Macro Group
Setting Conditional Expressions
Assigning a Macro to an Event
Customizing Toolbars with Macros
Troubleshooting Macros
Practice

Unit 5: Managing the Database

Converting Databases
Setting Passwords
Changing Startup Options
Encrypting and Decrypting a Database
Analyzing Performance
Splitting a Database
Replicating Using the Briefcase
Synchronizing Using the Briefcase
Practice


This self-paced Program is available from any browser, and is accessible for one full year from date of purchase.

Item

Course
Individual Course Cost $30.00
 

Credencia e-Learning courses are designed to function under the following minimum computer standards. Please be sure that your computer meets these minimum standards:

  • Internet Explorer version 5.5 or higher
  • Windows Media Player version 6.4 or higher
  • A minimum connection speed of a 56K modem is required, but higher speed connections are better for viewing.
  • Your computer must have the ability to play audio, with speakers or headset attached
Depending on the speed of your modem connection, the download time may take a few minutes to view the presentation.