Microsoft access 2002 : comprehensive concepts and techniques / Gary B. Shelly . . . [et al].

CONTENTS

1. Project one: Creating a database using design and datasheet views
Objectives
What is Microsoft access ?
Project one - Alisa vending services
Starting access
Speech recognition
Creating a new database
The access desktop and the database window
Creating a table
etc.


2. Project two: Querying a database using the select query window
Objectives
Introduction
Project two - Querying the Alisa vending services database
Creating a new query
Including all fields in a query
etc.


3. Project three: Maintaining a database using the design and update features of access
Objectives
Introduction
Project three - Maintaining the Alisa vending services database
Opening the database
Adding, changing and deleting
Changing the structure
Using an update query
etc.


4. Project four: Reports, forms and combo boxes
Objectives
Introduction
Project four - Creating reports and forms for Alisa vending services
Report creation
Grouping in a report
Reviewing the report design
Report design considerations
etc.


5. Project five: Enhancing forms with OLE Fields, hyperlinks and sub forms
Objectives
Introduction
Project five - Enhancing the Alisa vending services form
Opening the database
Date, Memo OLE and Hyperlink fields
Adding fields to a table
Updating the new fields
etc.


Project six: Creating an application system using macros, wizards, and the switchboard manager
Objectives
Introduction
Project six- creating an application system for Alisa vending services
Lookup and input mask wizards
Modifying a report
etc.


Project seven: Creating a report using design view
Objectives
Introduction
Opening the database
Creating the additional tables
Relating several tables
etc.


Project eight: Using visual basic for applications and advanced form techniques
Objectives
Introduction
Project eight- using advanced from techniques and visual basic applications
Opening the database
Enhancing the form
Visual basic for applications
etc.


Project nine: Administering a database system
Objectives
Introduction
Project nine- administering the Alisa vending services database system
Using microsoft access tools
Using the analyse tool
Integrity features
etc.

Index : p. I.01-I.13