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

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

Action queries
- Making tables
- Updating records
- Appending records
- Deleting records

Crosstab queries
- Columns, rows and values
- Overriding column headings

SQL Queries (*)
- Union queries
- Pass-through queries

Creating forms
- Using the form wizard
- Using forms to enter data
- Form design
- Creating controls

Creating subforms
- Creating tabular forms
- Merging forms and subforms
- Tidying up subforms

Creating reports
- Using the report wizard
- Using print preview
- Report design

Basic VBA macros
- Creating macros
- Using Project Explorer
- Writing comments
- Indenting code

Uses of macros
- Form validation
- Criteria forms
- A simple menu system

The VBA code editor
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments

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