Course Overview
Microsoft Access is a popular database
application which allows you to store, analyse and sort information. This
introductory course covers how to use an existing database, confidently
search and find information and to use Access to prepare and format
reports, lists and labels.
The course will also introduce you to
relational database concepts. This outline is based on Microsoft Access
2007. If you are using a different version of Access, please give us a
call on 020 7359 9855.
Course content
Introduction
to databases
· Database concepts and principles
· What is a
relational database?
· Principles of normalisation
· Using the
help facility in Access
Essential features
· The new interface
·
The Office button
· Quick Access tool bar
· The Ribbon
·
Tabs and context tabs
· Page views
· Workspaces
·
Readability
Creating tables
· Defining fields
·
Formatting fields
· Changing field order
· Field properties
·
Adding and deleting data
Using queries
· What is a query?
·
Designing select queries
· Using calculations in queries
·
Using filters to find data
· Sorting data
· Finding data types
Creating
a report
· Using the Report Wizard
· Designing a report
·
Formatting a report
· Editing a report
Creating forms
·
Designing and understanding forms and subforms
· Customising forms
·
Using Form Wizards
· Editing forms
Printing
· Printing
individual records
· Printing a selection of records
· Creating
and printing labels
Questions and answers
