Access 2000 Power User

Target Audience

Experienced users of Access or those upgrading from a previous version.

Pre-requisites

To fully benefit from this course, attendees are expected to be confident users of Access and have attended the Access Creating Databases course or be familiar with these topics.

On completion of the course, delegates will be able to:

• Create Aggregated queries
• Create a Crosstab query to analyse data in a table or query
• Create sophisticated forms with tab controls and sub-forms
• Create a chart on a form
• Split the tables from a database file
• Create and maintain multiple copies of a database file
• Secure a database file and its objects to prevent unauthorised access
• Create simple macros
• Use conditions in macros
• Create macros that are used with forms

Relational Design

Primary/Foreign Keys • Referential Integrity • Entity Relationship Modelling • Normalisation

Analyzing Tables

Using Relationships in Splits • The Table Analyzer Wizard

Working with Indexes

Creating a Single/Multiple Field Index • Creating a Multiple Field Primary Key • Viewing/Deleting Indexes

Using Advanced Query Wizards

Using the Crosstab Query Wizard • Using the Find Duplicates/Unmatched Query Wizard

Manipulating Controls

Selecting Non-adjacent Controls • Sizing a Control by Dragging/Automatically • Selecting/Movin Controls

Using Subforms/Subreports

Creating a Subform/Subreport • Editing the Layout • Displaying a Subform in Datasheet View • Subform Header/Footers • Subform Totals

Using Switchboards

Creating a Switchboard Form • Adding Command Buttons to a Switchboard • Setting Startup Options

ActiveX Controls

Working with/Registering an ActiveX Control • Adding/Attaching an ActiveX Control

Advanced Form Design

Creating a Combo/List Box/Option Boxes • Setting the Tab Order Automatically/Manually • Adding a Form Header and Footer

Using Advanced Report Design

Using Reports in Design View • Creating a Calculated Control • Grouping Data in a Report • Creating a Header for Each Group • Creating a Running Summary • Inserting a Date/Time Control  • Inserting a Page Break • The Label Wizard

Creating & Using Macros

Creating/Running/Saving Macros • Assigning an Argument to an Action • Testing & Editing Macros • Using the Macro Builder  • Assigning a Macro to a Control • Creating a Command Button • Adding a Condition to a Macro  • Creating a Group/AutoExec Macros

Advanced Database Features

Printing a Relationship Document • Linking Data to an Access Table • Importing Data • Setting a Database Password • Compacting/Backing Up a Database • Replicating a Database • Synchronizing Database Replicas

You may also be interested in some of the following related courses below:

Microsoft - Access 2000 - Queries & Reports
Microsoft - Access 2000 - Creating Databases
Microsoft - Access 2000 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.