Microsoft Access 97: Blue Ribbon Edition

by Duffy, Tim

• ISBN13: 9780201448511
• ISBN10: 0201448513
• Edition: 2nd
• Format: Paperback
• Copyright: 1999-02-01
• Publisher: Pearson College Div

Table of Contents

Preface
Introduction to Databases and Access 97	1	(30)
Introduction to Databases	2	(1)
Database Terminology	2	(1)
Designing Fields	3	(1)
Introduction to Access 97	3	(4)
Access 97 Modes	3	(1)
Starting Access 97	4	(1)
The Access Window	4	(3)
Opening a Database	7	(1)
Exiting Access	8	(1)
Creating a Database	8	(1)
Creating a Table Structure	9	(2)
Naming a Table	9	(1)
Defining Field Types	9	(1)
Setting Field Properties	10	(1)
Defining the Table Structure	11	(4)
Adding and Displaying Table Data	15	(1)
Entering Data in a Table	16	(2)
Opening a Table	18	(1)
Adding Records to a Table	19	(1)
Adding Records to a Table	20	(1)
Editing Records in a Table	21	(1)
Editing a Field	22	(1)
Entering Data in a Memo Field	23	(1)
Entering Data in a Memo Field	23	(1)
Printing a Report	24	(1)
Printing a Report of a Table	24	(1)
Session Review	25	(1)
Key Terms and Concepts	26	(1)
Session Quiz	26	(1)
Session Review Exercises	27	(1)
Computer Exercises	28	(1)
Internet Exercises	29	(2)
Manipulating and Sorting Tables	31	(32)
Working in the Datasheet Window	32	(3)
Deleting and Restoring Gridlines	32	(1)
Changing the Display Width of a Field	33	(2)
Resizing Fields	35	(3)
Moving a Field	37	(1)
Moving a Field	38	(1)
Hiding a Field	38	(1)
Hiding Fields	38	(2)
Locking a Field	40	(1)
Locking Fields	40	(3)
Navigating Through and Locating Records	43	(1)
Using the Record Painter	43	(1)
Record Painter Manipulation	44	(3)
Locating Records Using Find	45	(2)
Locating Records	47	(1)
Sorting Records	48	(1)
Sorting on One Field	48	(1)
Sorting by Last Name	49	(2)
Sorting by Multiple Fields	50	(1)
Sorting by Name Within City	51	(3)
Displaying Selected Records	54	(1)
Creating a Filter to Display Only Certain Records	55	(2)
Session Review	57	(1)
Key Terms and Concepts	57	(1)
Session Quiz	57	(1)
Session Review Exercises	58	(1)
Computer Exercises	59	(2)
Internet Exercises	61	(2)
Relating Tables, Modifying Table Structures, and Generating Reports	63	(38)
Relating Tables	64	(1)
Referential Integrity	65	(1)
Permanent and Transient Links	65	(1)
Linking Two Tables	65	(2)
Modifying a Table Structure	67	(1)
Adding a Field to a Table Structure	68	(1)
Adding a Field	68	(5)
Controlling Data Entry and Display	71	(2)
Controlling Data Entry in Selected Fields	73	(6)
Replacing Text in a Table	79	(1)
Deleting Records	79	(1)
Creating Reports	80	(1)
Building a Report by Using a Report Wizard	80	(1)
Using a Report Wizard to Create a Report	80	(3)
Working in the Report Design Windows	83	(3)
Redesigning a Report	86	(1)
Building a Report	86	(10)
Session Review	96	(1)
Key Terms and Concepts	96	(1)
Session Quiz	97	(1)
Session Review Exercises	98	(1)
Computer Exercises	99	(1)
Internet Exercises	100	(1)
Creating Queries and Forms	101	(56)
Queries	102	(1)
Dynasets	102	(1)
Creating a Query	102	(1)
Building a Query with a Query Wizard	103	(8)
The Query Design Window	108	(3)
Modifying QBE Entries	111	(4)
Query Calculations on Groups of Records	114	(1)
Generating Subtotals	115	(4)
Viewing Data by Joining Tables	119	(2)
Link the Three Tables	121	(3)
Crosstab Queries	124	(1)
Counting Expired Memberships by Region	124	(1)
Forms	125	(1)
Creating a Form Using a Form Wizard	126	(2)
Customizing a Form	128	(1)
Relating the Remaining Tables	128	(4)
Customizing a Wizard-Built Form	132	(6)
Adding Records to a Database Using a Form	138	(1)
Using a Form to Enter a New Record	138	(1)
Subforms	139	(1)
Adding a Subform	139	(6)
Adding Records	144	(1)
Generating a Chart	145	(1)
Building a Chart	145	(5)
Session Review	150	(1)
Key Terms and Concepts	150	(1)
Session Quiz	150	(1)
Session Review Exercises	151	(2)
Computer Exercises	153	(2)
Internet Exercises	155	(2)
Advanced Access 97 Features	157
Advanced Report Features	158
Creating Multiple-Line Reports	158
Building the New Report Definition	160
Embedding Calculations Within a Report Template	169
Creating the Inventory Valuation Report	170
Sending Data to Other Office Applications	177
Community with Word and Excel	177
Integrating Data From Other Applications	183
Embedding Objects (Pictures)	185
Generating an HTML Document	186
Creating Web Documents	187
Session Review	194
Key Terms and Concepts	195
Session Quiz	195
Session Review Exercises	196
Computer Exercises	197
Internet Exercises	198
Operations Reference	EM-1
Glossary	EM-3
Index	EM-7