Access 2003 Level 3
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
13 Jun 2012 (Wed)
14 Jun 2012 (Thu) | Washington | 2 | £ 395 |
06 Sep 2012 (Thu)
07 Sep 2012 (Fri) | Washington | 2 | £ 395 |
| 03 Dec 2012 (Mon) | Newcastle | 2 | £ 395 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
This course is for delegates who already have sound skills in the use of Microsoft 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 Microsoft Access data in other Microsoft Office applications. This course is ideal for those who are responsible for structuring data into properly designed tables, analysing data and automating tasks using Microsoft 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 Microsoft Access and, ideally, will have attended Microsoft Access Level 1 and Level 2 courses or have equivalent knowledge.
- 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
Other courses in this series Course Content
Importing Data
Designing Select Queries
Queries with calculated fields
How to format a field in a query
Creating Multiple Table Queries
Selecting your 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
How to create 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
How a report is printed
How to add an extra band to a report
How to add 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
How to create 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
How to edit the design of your Data Access Page
Adding text or pictures to the page
Adding, editing and aligning Controls on your Data Access Page
How to add a pivot table
How to add a Spreadsheet
How to add 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?
How to create a new macro.
The MsgBox Macro
Using Macros in Forms
Passing values between Forms
Custom Toolbars
Editing the button on the toolbar
To remove an icon from the toolbar
Custom Menus
To 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 Microsoft Access
Setting a password to open a database
Creating of a number of databases
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
Microsoft and Microsoft Access are Registered Trademarks
Microsoft Access advanced training courses in North East England, Durham, Washington, Newcastle. Create Macros, complex queries, specialised functions, complex databases. Microsoft access training Gateshead, Microsoft courses Sunderland, Access training Durham, Courses for Microsoft Access Washington. Microsoft Access training courses Middlesbrough.
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
