| INTRODUCTION
Overview of Relational Databases
What is a database?
What is a relational database?
ACCESS OBJECTS
Tables, Forms, Queries, Reports, Macros and Modules
TABLES
Creating a table in design view
Table structure: Field names and sizes
Data types
Field properties
Inserting fields
Look-up Lists
Indexes
Setting a Primary Key
EDITING DATA
Selecting fields and records
Adding and deleting records
Useful shortcut keys
Finding data
Find and replace
RELATING TABLES
Overview: Why relate tables?
Types or relationship
One-to-one
One-to-many
Linking fields
The relationship window
Referential Integrity
FILTERS
Filtering in tables, Filter by selection
Exporting filtered data |
QUERIES
Creating select queries
The query grid
Query criteria: Wild cards, comparison and logical operators
Summarising data in queries
Aggregate functions
Calculations in queries
Querying multiple tables
Join properties
FORMS
Using an existing form
The form screen
Record navigation
Adding records
Creating a form using AutoForm
The form wizard
Mainform and subform
Designing a form: labels and control sources
Selecting and moving
Resizing controls
Formatting controls
Using the toolbox
REPORTS
Creating a report using the report wizard
Report bands
Designing reports
Creating and formatting controls
Grouping in reports
Calculating totals
Viewing a report in print preview
Printing reports
|
4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk |
