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

Course Contents
The contents of our Access 2003 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
- assasashgh

Creating tables
- Defining fields
- Types of field
- Entering data

Drawing relationships
- Creating relationships
- Referential integrity

Importing data
- Importing from Excel
- Linking to Excel spreadsheets
- Problems with importing

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
- Using the form wizard 
- Using forms to enter data
- Form design
- Creating controls

Creating reports
- Using the report wizard
- Using print preview

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