Access 2007 Level 3
| Date |
Location |
Duration |
Cost |
09 Sep 2010 (Thu)
10 Sep 2010 (Fri) | Newcastle | 2 | £ 395 |
25 Nov 2010 (Thu)
26 Nov 2010 (Fri) | Washington | 2 | £ 395 |
07 Feb 2011 (Mon)
08 Feb 2011 (Tue) | Washington | 2 | £ 395 |
20 Apr 2011 (Wed)
21 Apr 2011 (Thu) | Washington | 2 | £ 395 |
| 25 Jul 2011 (Mon) | Washington | 2 | £ 395 |
Please contact us to discuss private course dates and locations |
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
Related Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke 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
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
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
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
Email Us 
Print