Access 2007

Practical Training for Professionals
Bristol, Birmingham, Coventry, Edinburgh, Glasgow, Leeds, Leicester, London, Manchester, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 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.

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

Training Benefits
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
...''

Elements of this syllabus are subject to change.

Phone:01509 889632

School Address/Venue(s):

PTP House
102 Brook Street
Wymeswold
Leicestershire
LE12 6TU
United Kingdom

Jobs & Resumes: Bristol, Birmingham, Coventry, Edinburgh, Glasgow, Leeds, Leicester, London, Manchester
Houses & Roommates: Bristol, Birmingham, Coventry, Edinburgh, Glasgow, Leeds, Leicester, London, Manchester
Travel Agencies: Bristol, Birmingham, Edinburgh, Leeds, London, Manchester

Search other schools for Access 2007 training resources.

Investor and Entrepreneur Skills
Managing Budgets
Successfully Setting and Achieving Business Objectives
Sustaining Effective Financial Control
Buying
Maximising Cashflow, Sales & Profitability
Business Skills for Administrators
Interpreting Financial Statements
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Visio 2007
Project 2007
Green Office Management
Managing Your Green Policy Effectively

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.