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

This is one of a series of course books for students, teaching the skills required to make full and effective use of modern software. It can be used as a course text for group learning, or individually for independent learning. The series covers the key Microsoft Office 2000 components of Access, Excel and Word, and for each of these applications there is an introductory and an advanced book. This advanced book does not assume any previous knowledge of Access 2000, but it introduces concepts and functions at a rapid pace, and deals with advanced features of the software. The approach of the book is that the user will be able to learn by doing. Each topic includes exercises to complete which illustrate the theory and help to reinforce 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
• Exporting, importing and creating web pages
• Database application - switchboard forms

Authors:

Sue Coles, Manchester Metropolitan University
Jenny Rowley, Edge Hill College of Higher Education