Access, Level 2
Table of Contents
Sidebar image map Contents

Database Structure
Introduction, 1
Field Structure, 1
Record Structure,, 2
Field Data Types,, 2
Relational Database Management Systems,, 3
Field Structures And Relations,, 4

Relational Database Management
Introduction, 5
Customers Table Structure, 5
Input Mask, 6
Orders Table Structure, 7
Products Table Structure, 7
All Orders Query Structure, 8
All Orders Query Result, 8
All Orders Report Structure, 9
All Orders Report Result, 9

Creating Relational Databases
Introduction, 11
Creating The Customers Table, 11
Modifying The Table Structure, 12
Input Mask Properties, 13
Creating The Prducts Table, 15
Modifying The Table Structure, 16
Creating The Orders Table, 17
Modifying The Table Structure, 19
Saving The Table Structure, 19
Viewing Relationships, 20
Editing Relationships, 20
One-To-Many Relationship, 22
Customers Data Entry, 22
Products Data Entry, 23
Orders Data Entry, 24

Relational Queries
Introduction, 25
Creating A Relational Query, 25
Adding Fields To The Query View, 26
Adding A Mathematical Expression Field, 26
Saving The Query, 27
Running The Query, 27
Adding A Query Field Caption, 28
Relational Reports, 29
Introduction, 29
Creating A Relational Report, 29
View The Finished Report, 31
Saving The Report, 32

Exercises
Exercise One, 33

Glossary

Index

DGL publishes Training Expresstm brand computer learning guides in both electronic and print formats; details are posted at http://dgl.com/te/. Training Express guides are designed for the way we learn.

Subscribe to ITINFO.
Receive computing and Internet news & tips
by subscribing to the ITINFO information service.
Type your Internet email address in the form, and click "Subscribe."
Email Address:

updated March 20, 1997
http://dgl.com/te/aw2.html

Damar GroupReturn to DGL homepage
Copyright © 1997, Damar Group, Ltd., All Rights Reserved