GO Series: Microsoft Access 2003 Brief

by Gaskin, Shelley; Foster-Turpen, Linda

• ISBN13: 9780131434288
• ISBN10: 0131434284
• Edition: 1st
• Format: Paperback
• Copyright: 2004-01-01
• Publisher: Prentice Hall

Summary

Written for a diverse audience (all ages, different educational backgrounds, varying educational goals), this book allows for self-paced or online learning. The primary goal of GO! Series: Microsoft Access 2003 Brief is to teach Microsoft Access 2003 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin with where the action is to take place, followed by the action itself. The instruction is error-free, clearly written, and logically arranged. This book provides users with the skills to solve business problems using the computer as a tool. The Brief edition covers the following topics: getting started with Access databases and tables; forms and reports; and queries. An efficient and handy guide for anyone interested in a comprehensive introduction to Microsoft Access 2003.

Table of Contents

Preface	xiii
Getting Started with Access Databases and Tables	1	(80)
Rename a Database	4	(2)
Renaming a Database	4	(2)
Start Access, Open an Existing Database, and View Database Objects	6	(22)
Starting Access and Opening on Existing Database	6	(6)
Viewing the Database Window	12	(2)
Opening a Table	14	(4)
Viewing a Table	18	(2)
Viewing a Query	20	(1)
Viewing a Form	21	(2)
Viewing and Printing a Report	23	(5)
Create a New Database	28	(1)
Creating a New Database	28	(1)
Create a New Table	29	(5)
Adding Fields to a Table	29	(4)
Switching Between Views	33	(1)
Create a Primary Key and Add Records to a Table	34	(3)
Creating a Primary Key in a Table	34	(2)
Adding Records to a Table	36	(1)
Close and Save a Table	37	(1)
Closing and Saving a Table	37	(1)
Open a Table	38	(1)
Opening a Table	38	(1)
Modify and Table Design	39	(3)
Deleting Fields	39	(2)
Adding Fields	41	(1)
Print a Table	42	(2)
Printing a Table	42	(2)
Edit Records in a Table	44	(7)
Editing a Record	44	(1)
Deleting a Record	45	(1)
Resizing Columns and Rows	46	(3)
Hiding Columns	49	(2)
Sort Records	51	(1)
Sorting Records in a Table	51	(1)
Navigate to Records in a Table	52	(2)
Navigating Among Records Using the Navigation Area	52	(1)
Navigating Among Records Using the Keyboard	53	(1)
Close and Save a Database	54	(1)
Closing and Saving a Database	54	(1)
Use the Access Help System	55	(26)
Using the Access Help System	55	(3)
Summary	58	(1)
In This Chapter You Practiced How To	58	(1)
Concepts Assessments	59	(2)
Skill Assessments	61	(8)
Performance Assessments	69	(6)
Mastery Assessments	75	(4)
Problem Solving	79	(1)
On the Internet	80	(1)
Go! with Help	80	(1)
Forms and Reports	81	(72)
View and Navigate to Records with a Form	84	(3)
Viewing and Navigating to Records Using a Form	84	(3)
Create an AutoForm	87	(2)
Creating an AutoForm	87	(2)
Save and Close an AutoForm	89	(1)
Saving and Closing an AutoForm	89	(1)
Use a Form to Add Records to and Delete Records from a Table	90	(5)
Adding Records to a Table Using a Form	90	(1)
Deleting Records from a Table Using a Form	91	(4)
Create a Form with the Form Wizard	95	(3)
Creating a Form Using the Form Wizard	95	(3)
Modify a Form	98	(14)
Switching Between Views in a Form and Adding a Form Header	98	(5)
Moving and Resizing Fields in a Form	103	(7)
Adding a Page Footer to a Form	110	(2)
Create a Report with the Report Wizard	112	(3)
Creating a Report Using the Report Wizard	112	(3)
Save a Report	115	(1)
Saving a Report	115	(1)
Modify the Design of a Report	115	(11)
Switching Between Report View and Design View	115	(2)
Moving and Resizing Fields in a Report	117	(7)
Adding a Page Footer and a Report Footer to a Report	124	(2)
Print a Report	126	(27)
Printing a Report	126	(1)
Summary	127	(1)
In This Chapter You Practiced How To	127	(1)
Concepts Assessments	128	(2)
Skill Assessments	130	(10)
Performance Assessments	140	(6)
Mastery Assessments	146	(4)
Problem Solving	150	(1)
On the Internet	151	(1)
Go! with Help	152	(1)
Queries	153	(72)
Create a New Select Query	156	(5)
Creating a New Query, Using the Select Query Window, and Adding Fields to the Design Grid	156	(5)
Run, Save, and Close a Query	161	(1)
Running, Saving, and Closing a Query	161	(1)
Open and Edit an Existing Query	162	(4)
Opening an Existing Query and Switching Between Views	162	(1)
Editing a Query	163	(3)
Specify Text Criteria in a Query	166	(8)
Specifying Text Criteria in a Query	166	(6)
Printing a Query	172	(2)
Use Wildcards in a Query	174	(9)
Using the * Wildcard in a Query	174	(4)
Using the ? Wildcard in a Query	178	(2)
Specifying Criteria Using a Field Not Displayed in the Query Result	180	(3)
Specify Numeric Criteria in a Query	183	(4)
Specifying Numeric Criteria in a Query	183	(1)
Using Comparison Operators	184	(3)
Use Compound Criteria	187	(2)
Using AND in a Query	187	(1)
Using OR in a Query	188	(1)
Sort Data in a Query	189	(7)
Sorting Data in a Query	189	(1)
Modifying the Query Design and Sorting Data Using Multiple Fields in a Query	190	(6)
Use Calculated Fields in a Query	196	(5)
Using Calculated Fields in a Query	196	(5)
Group Data and Calculate Statistics in a Query	201	(24)
Grouping Data in a Query	201	(2)
Using the AVG, SUM, MAX, and MIN Function in a Query	203	(3)
Summary	206	(1)
In This Chapter You Practiced How To	206	(1)
Concepts Assessments	207	(2)
Skill Assessments	209	(7)
Performance Assessments	216	(4)
Mastery Assessments	220	(3)
Problem Solving	223	(1)
On the Internet	224	(1)
Go! with Help	224	(1)
Task Guide	225	(14)
Glossary	239	(2)
Index	241