Access 2002 An Advanced Course for Students
Sue Coles and Jenny Rowley

This course book for students, teaches the skills required to make full and effective use of Microsoft Access 2002. It can be used as a course text for group learning, or individually for independent learning. This advanced book does not assume any previous knowledge of Access 2002, but it introduces concepts and functions at a rapid pace, and deals with advanced features of the software. The authors take the approach that users will learn best by doing. Each topic includes exercises to complete which illustrate the theory and help to reinforce the learning.

Key Features:

• Progress through the course topic by topic
• Clear learning objectives
• Tasks help to embed learning
• Theory illustrated with practical examples

Contents:

• Getting acquainted with Access
• Tables, records and fields
• Creating a new database
• Field properties
• Data entry and editing
• Working with data
• Using filters to select records
• Selecting data - queries
• Data selection - query criteria
• Calculations in queries
• Screen forms
• Customising forms
• Designing your own forms
• Creating and using reports
• Creating and using grouped reports
• Mailing label reports and mail merge
• Customising reports
• Adding controls to forms
• Adding controls to reports
• Forms and reports: graphical design
• Forms and reports: control properties and templates
• Relationships between tables
• Queries using several tables
• Subforms and subreports
• Action and crosstab queries
• Exporting, importing and creating web pages
• Introducing macros
• Buttons and macros
• Database application - switchboard forms

Authors: