Access 2007 Level 3

Course Overview

This course is for delegates who have sound skills in the use of Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use Access data in other Office applications. Access 2007 Level 3 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.

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 a database.
• Use a variety of techniques to summarise data.
• Create and revise basic Access macros.
• Create macros to automate tasks within a database.
• Use advanced features to enhance forms.
• Use advanced features to enhance reports and distribute a report to non-Access users.
• Lock away access features so that users can only do what is left on.

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
Creating multiple table queries

• Selecting tables
• 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

Action queries

• Make Table query: Making a table from the results of a query
• Update query: Updating values in a table using a query
• Append query: Adding the results of a query to a table
• Delete query: Deleting all the records in a table that are displayed by the query
• Find Duplicates/Unmatched query
• Adding a tab control

Customising reports

• Printing a report
• Adding an extra band to a report
• Creating a chart or labels report

Advanced form design

• Unbound forms
• Using command buttons
• Passing values to queries from a field on a form
• The Expression Builder
• Events on forms for triggering macros or Visual Basic code
• Different events on forms and form controls

Macros

• What is a macro?
• Creating a new macro
• The MsgBox macro
• Using macros in form events
• Passing values between forms to filter data
• Custom toolbars: customising toolbars
• Editing the button on the toolbar
• Removing an icon from the toolbar
• Custom menus: customising a menu
• Attaching toolbars and menu bars to objects
• The AutoExec macro and startup options - controlling what happens when your database starts
• Changing the splash screen for your application
• Keyboard shortcuts to run macros: Customising shortcuts

Database utilities

• Compacting and repairing a database
• Making ACCDE file
• Converting Access 2007 to previous versions

Security in Access

• Setting a password to open a database
• Splitting your database into a frontend and backend application