Click here if you
would like to
book a course
Save 5% by paying for the course by card at the time of booking!
If you have more
than 3 delegates
you may benefit
from a tailored course!
click here to find out more
Call 0845 485 1173
for full course
details TODAY!
Our training courses can be delivered to suit your requirements
Access 2003 - Intermediate level
View our full Access Course Schedule or call 0845 485 1173 today for more details
You can view this course outline as a PDF for printing
Objectives
After completing this course you will know how to:
- Understand relational databases
- Use related tables
- Create complex queries, using calculated fields and summarising data
- Modify forms to include calculated values and combo boxes
- Customise reports
- Create charts in forms and reports
- Create Pivot tables
- Work with hyperlinks and data access pages
Pre-requisites
- Experience of Windows 2000 or later
- Attendance on Access 2003 Introduction course or equivalent experience
Course Contents
Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Working with related tables
- Lookup fields
- Modifying Lookup fields
- Subdatasheets
Complex queries
- Joining tables in queries
- Creating calculated fields
- Summarizing and grouping values
Advanced form design
- Adding unbound controls
- Graphics
- Adding calculated values
- Adding combo boxes
Advanced reports
- Customized headers and footers
- Adding calculated values
- Subreport
Charts
- Charts in forms
- Charts in reports
PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
Internet integration
- Hyperlink fields
- Working with data access pages
If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk
Copyright © 2011 JB Consulting Ltd, trading as Computer Training Solutions. All rights reserved
