Access 97 for Windows Made Simple (Made Simple Books)

✍ Scribed by MOIRA Stephen

• Publisher: Routledge
• Tongue: English
• Leaves: 160
• Category: Library

✦ Synopsis

If you:

* need to create and build databases; work with data; design forms and reports
* want to get the job done, quickly and efficiently
* need a self-teaching approach
* want results fast

then Access 97 for Windows Made Simple is for you!

By a combination of tutorial approach, with tasks to do and easy steps, the MADE SIMPLE series of Computer Books from British publisher Butterworth-Heinemann, using British authors and designed for a European audience, stands above all others.

✦ Table of Contents

Cover
Title
Copyright
Contents
Preface
1 Getting Started
What is a database?
Access objects
Preparing your data
Getting into Access
The Access screen
Summary
2 Help
Office Assistant
What's This?
Screen Tips
The Help menu
Summary
3 Building a database
Creating a new database
Creating a new table
Table Design window
Number data type
Text data type
Primary key
Saving the design
Closing a database
Summary
4 Data types
Opening a database
Adding a new table
AutoNumber
Date/Time
Input Mask
lookup
Yes/No
Memo and OLE Object
HyperLink
Currency
Summary
5 Relationships
Table Wizard
Checking relationships
Leaving Table Wizard
Relationships
Summary
6 Data entry and edit
Using Datasheet View
The lookup field
Pictures as OLE Objects
Hyperlinks to documents
Adding and deleting records
Using Form View
Summary
7 Redesigning a table
Adding a field
Deleting a field
Changing field properties
Primary key and indexes
Summary
8 Datasheet display
Gridlines
Hiding columns
Showing columns
Fonts
Widths and heights
Freezing columns
Print Preview
Page Setup
Printing your table
Summary
9 Sorting and searching
Find
Filter By Selection
Filter By Form
Sort
Multi-level sorts
Multi-table queries
Setting the query criteria
Reusing queries
Editing a query
Query Wizard
Summary
10 Forms
Designing a form
Headers and footers
Adding labels
Adding fields
Save your form
Form View
Summary
11 Reports
The Report Wizard
The design
Preview and print
Mailing labels
Summary
12 Database Wizard
Selecting a Wizard
Adding fields
Setting the style
The end product
Summary
Appendix
Type of Accommodation
Price
Accommodation
Contacts
Index