Access 2007 Specialised
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
This course is usually held in London as a public course but can also be offered on an In-company basis. The Training Provider's course description is included below. Please click the Course Dates tab above to see current course dates. Microsoft Access 2007 Specialised

Overview
The skills and knowledge acquired in Microsoft Access 2007 Specialised are sufficient to be able to use and operate the software at an efficient level.

Target Audience
Microsoft Access 2007 Specialised is designed for users who are keen to extend their understanding and knowledge of the software.

Pre-requisites
Microsoft Access 2007 Specialised assumes the delegate has completed the Access 2007 Fundamentals course or has equivalent knowledge.

Objectives
At the completion of Microsoft Access 2007 Specialised you should be able to: 
- create select queries for a relational database 
- add calculated fields to queries 
- add parameters to queries to capture criteria data 
- create aggregated queries 
- create a form for data entry or data viewing in Access 
- produce reports with calculations 
- import data into an Access table from a variety of sources 
- export records from Access 
- export records to HTML for use on the Web 
- understand table and query relationships and how they affect the integrity of your data 
- create a chart on a form 
- create a data access page 
- create data access pages using the Design View 
- create simple macros 
- use conditions in macros 
- create macros that used with forms 
- create a Crosstab query to analyse data in a table or query 
- create action queries to make tables, and update, append, and delete records 
- protect your database files against unauthorised access 
- completely secure a database file and its objects so that unauthorised access is prevented 
- write a simple procedure in VBA 
- create sophisticated forms with tab controls and sub-forms 
- create a macro for an option group to provide instant filtering 
- use the Switchboard Manager to create a menu system 
- split the tables from a database file 
- create and maintain multiple copies of a database file

Course Duration 
2 Days
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration2 days
 
£450
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).