Showing experienced users how to develop their skills on our Level 2.

Overview

This is a practical hands-on course designed for database users who need to extend their Access skills. Practice tasks and case studies ensure that techniques can be applied quickly in a demanding financial and business environment.

Duration

1 Day

Requirements

The course assumes that you have a basic understanding of relational databases, and that you know how to create tables and select data with queries.

Objectives

• Import and link data and describe the difference between importing and linking
• Create and use action queries to delete, update and append data
• Export and use data in another application
• Create forms using wizards, and use basic design techniques to make them more user-friendly
• Create reports using wizards, and modify the layout using basic design techniques.

Content

Reviewing Access:
How Access objects work together; the importance of using appropriate relationships in a database; creating and running queries with various criteria.

Working with imported data:
Importing or linking data; importing data from other applications (such as Excel or text files); importing from other Access databases; defining an import specification.

Exporting data:
Exporting to a text file, worksheet or database files; merging Access data with a Word document.

More on queries:
Using the query wizards to find duplicates or unmatched records; using action queries to create tables, delete data, append or update records; summarising information with cross-tab queries and totals.

Creating forms and reports:
Using the form and report wizards to create a basic form and report.

Customising forms:
Using form design view; adding controls; setting properties of controls; setting form properties; changing the tab order.

Customising reports:
Working in design view; report sections and their properties; working with groups; adding subtotals and totals; controlling page breaks.

Allowing expert users to complete their knowledge on our Level 3.

Overview

This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.

Duration

1 Day

Requirements

This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.

Objectives

• Design and create complex forms and reports, including graphics, sub-forms and sub-reports
• Automate a database using macros and command buttons
  Add finishing touches to a database application including switchboard forms and start-up options
• Set security levels to control access to your database and objects
• Customise menus and toolbars.

Content

Designing forms:
Understanding the design window; form sections; adding controls; bound, unbound and calculated controls; adding tab controls; synchronising sub-forms; using list and combo boxes; using a combo box to set query parameters.

Designing reports:
Designing a report; grouping, sorting and summarising; report sections and properties; controlling layout, pagination and page setup; embedding a sub-report; creating a report snapshot; embedding pictures and graphics in forms and reports.

Understanding events:
Exploring Access events; default behaviours for events; how to customise and control event behaviours.

Automating your database:
Creating macros; adding actions arguments and comments; automating data entry with macros; using macros to print records; creating pop-up forms with macros.

Creating an application:
Toolbars and key assignments: creating custom menus; creating keyboard assignments; customising toolbars; attaching custom toolbars to forms.

Implementing security:
Splitting the database; setting passwords; setting a database password; protecting the front end database; testing security settings.