Access 2007 Querying
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Access 2007 Querying 

Course Contents
The contents of our Access 2007 Querying course are as follows (any items marked with a * will be covered if time allows):

Designing a database
- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields

Creating tables
- Defining fields
- The types of field
- Entering data

Drawing relationships (*)
- Creating relationships
- Referential integrity

Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria

Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries

Joins (*)
- Creating ad hoc joins
- Types of join

Creating forms
- Layout and design view
- Using the form wizard
- Split forms
- Creating controls

Creating reports
- Using the report wizard
- The group, sort and total pane
- Report design

 
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
Duration1 day
 
£225
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).