Access 2003 Level 3

Course Overview

This course is for delegates who already have sound skills in the use of Access and are now ready to expand their knowledge into some of the more specialised and advanced functions of the software. This course will provide delegates with skills to be able to create complex queries, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications. This course is ideal for those who are responsible for structuring data into properly designed tables, analysing data and automating tasks using Access, as well as producing advanced report outputs. This course will also look at using Data Access Pages as a means of accessing data on a corporate network.

Prerequisites

• Delegates should have a good working knowledge of Access and, ideally, will have attended Access Level 1 and Level 2 courses.
• This course assumes knowledge of how to create a database having many related tables, a form based on one or more tables, a query containing more than one table and a report without using the wizard.
  

Objectives

Delegates will be able to :

• Put existing data into correctly designed tables and compact your database.
• Use a variety of techniques to summarise data.
• Create and revise basic Access macros.
• Create macros that require data entry in certain fields and automatic data entry in others.
• Use advanced features to enhance forms.
• Use advanced features to enhance reports and distribute a report to non-Access users.

Training Options

• Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• 12 Months telephone and email support
• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• 1 delegate per computer
• Lunch (When at our training venue)
• Refreshments (When at our training venue)
• Relaxed refreshment area at our training room

Course Content
Importing Data
Designing Select Queries

• Queries with calculated fields
• How to format a field in a query

Creating Multiple Table Queries

• Selecting tables
• Description of the type of joins in a query
• Changing the properties of a join in a query
• Performing group and total calculations
• Entering a criteria with a group and totals query
• Querying for unique values
• Parameter queries
• Creating a parameter query

Action Queries

• Cross Tab query
• Make Table query
• Update query
• Append query
• Delete query
• Pass Through query
• Data Definition query
• Find Duplicates/Unmatched query

Enhanced Form Design

• Customising the form design
• The ToolBox
• Adding fields to a form
• Adding calculated controls
• Aligning objects on a form
• Moving a control
• Adding combo boxes and list boxes to a form
• Adding unbound controls
• Applying colour
• Changing the tab order
• Adding a tab control

Subform Design

• What are subforms?
• Creating a form that contains a subform
• Changing the links between a main form and a sub form
• Editing a subform
• Using the Form Wizard to create a form that contains a subform

Customising Reports

• Customising a report created by the Report Wizard
• Printing a report
• Adding an extra band to a report
• Adding a field to a report
• Customising a report
• Adding subreports to a report
• Creating a chart or labels report
• Using AutoReport with Report Wizard

Data Access Pages

• Creating a data access page
• Autopage: columnar
• The Page Wizard
• Viewing/using pages with grouping
• Using the Sort facility on a data access page
• Using a filter on a data access page
• Existing web page
• Design View
• Editing the design of your data access page
• Adding text or pictures to the page
• Adding, editing and aligning controls on a data access page
• Adding a pivot table
• Adding a spreadsheet
• Adding a chart
• Other data access page tools

Advanced Form Design

• Unbound forms
• Using command buttons
• Passing values to queries
• The expression builder
• Events on forms - macros
• Different events on forms

Macros

• What is a macro?
• Creating macros
• The MsgBox macro
• Using macros in forms
• Passing values between forms
• Custom toolbars
• Editing the button on the toolbar
• Removing an icon from the toolbar
• Custom menus
• Create a menu bar
• Attaching toolbars and menu bars to objects
• The AutoExec macro or startup options
• Changing the splash screen for your application
• Keyboard shortcuts to run macros

Database Utilities

• Compact and repair Database
• Make MDE file
• Converting Access to previous versions

Security In Access

• Setting a password to open a database
• Creating of a number of databases