Training Home Page > Computer Training Courses > Microsoft Access 2007 Training Courses (Intermediate)

Part of our range of Microsoft Access 2007 Training Courses in Manchester.


Course Title:	Microsoft Access 2007 Training Courses (Intermediate)

Related Courses:	Microsoft Access 2007 Training Courses (Introduction)

	Course Overview For Microsoft Access 2007 Training Courses (Intermediate) Delegates attending this course are already proficient enough to use the basic elements of Access, but are looking to improve their levels of productivity and to design and create new databases which will enable them to use a range of data validation techniques and set table relationships. The delegate will gain the ability to import data into Access from a variety of sources, enhance the operations on a form and to create queries that will capture data appropriate to the task in hand. This will enable the delegate to produce professional looking reports in a variety of formats.

Course Content Of Microsoft Access 2007 Training Courses (Intermediate)

A typical course will cover the following:-

Designing A New Access 2007 Database

Design Database Tables
Access Data Types
Change Field Properties

MS Access 2007 Data Validation

Assign Default Values
Mark A Field As Required
Validation Rules And Text
Working With Validations
Creating A Lookup Field

Setting Access 2007 Table Relationships

Set Table Relationships
Editing An Existing Relationship
Print Table Relationships

Importing Records into Access 2007

Import Data From Excel
Import From s CSV File

Modifying Forms in MS Access

Select Objects on a Form
Modify Controls
Change the Tab Order on a Form

Calculated Fields In A MS Access Query

Create a Calculated Field
Format Calculated Fields
Calculating Across Tables
Calculating Dates
Using Criteria In Calculations
Concatenate Fields

Microsoft Access 2007 Action Queries

Make Table Query
Update Query
Delete Query
Append Query

MS Access 2007 Parameter Queries

Create A Parameter Query

Formatting Access 2007 Reports

Change the Layout of a Report
Creating Groups In A Report
Create a Statistical Report

Download As A PDF

To find out more about how Copernicus Training can help your business, please call us on 0870 - 879 - 5327
or e-mail us at info@copernicus-training.com