Microsoft Access 2000 Introductory Concepts and Techniques

by Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt

• ISBN13: 9780789546746
• ISBN10: 0789546744
• Format: Paperback
• Copyright: 1999-07-01
• Publisher: ITP (Manual)

Summary

Part of the highly successful Shelly Cashman Series, this text offers a clear step-by-step, screen-by-screen approach to learning Microsoft Access 2000. Includes three complete projects that introduce basic Microsoft Access 2000 skills

Table of Contents

Creating a Database Using Design and Datasheet Views
Objectives	1	(5)
What Is Microsoft Access 2000?	6	(1)
Project One--Bavant Marine Services Database	6	(6)
Starting Access and Creating a New Database	9	(3)
The Access Desktop and the Database Window	12	(1)
Creating a Table	13	(6)
Defining the Fields	15	(3)
Correcting Errors in the Structure	18	(1)
Saving a Table	19	(1)
Adding Records to a Table	20	(4)
Closing a Table and a Database and Quitting Access	24	(1)
Opening a Database	25	(2)
Adding Additional Records	27	(3)
Correcting Errors in the Data	29	(1)
Previewing and Printing the Contents of a Table	30	(4)
Creating Additional Tables	34	(2)
Adding Records to the Additional Table	35	(1)
Using a Form to View Data	36	(7)
Creating a Form	37	(1)
Closing and Saving the Form	38	(1)
Opening the Saved Form	39	(1)
Using the Form	40	(1)
Switching Between Form View and Datasheet View	41	(2)
Creating a Report	43	(6)
Selecting the Fields for the Report	44	(2)
Completing the Report	46	(2)
Printing the Report	48	(1)
Closing the Database	49	(1)
Access Help System	49	(2)
Using the Office Assistant	49	(2)
Designing a Database	51	(3)
Project Summary	54	(1)
What You Should Know	54	(1)
Apply Your Knowledge	55	(2)
In the Lab	57	(6)
Cases and Places	63
Querying a Database Using the Select Query Window
Objectives	1	(3)
Introduction	4	(1)
Project Two--Querying the Bavant Marine Services Database	4	(2)
Opening the Database	6	(1)
Creating a New Query	6	(8)
Using the Select Query Window	9	(1)
Displaying Selected Fields in a Query	9	(2)
Running a Query	11	(1)
Printing the Results of a Query	12	(1)
Returning to Design View	12	(2)
Closing a Query	14	(1)
Including All Fields in a Query	14	(2)
Clearing the Design Grid	16	(1)
Entering Criteria	17	(6)
Using Text Data in Criteria	17	(1)
Using Wildcards	18	(1)
Criteria for a Field Not in the Result	19	(2)
Using Numeric Data in Criteria	21	(1)
Using Comparison Operators	22	(1)
Using Compound Criteria	23	(3)
Using AND Criteria	23	(2)
Using OR Criteria	25	(1)
Sorting Data in a Query	26	(5)
Sorting on Multiple Keys	27	(2)
Omitting Duplicates	29	(2)
Joining Tables	31	(4)
Restricting Records in a Join	34	(1)
Using Calculated Fields in a Query	35	(3)
Calculating Statistics	38	(4)
Using Criteria in Calculating Statistics	40	(1)
Grouping	41	(1)
Saving a Query	42	(1)
Closing a Database	43	(1)
Project Summary	43	(1)
What You Should Know	43	(1)
Apply Your Knowledge	44	(1)
In the Lab	45	(3)
Cases and Places	48
Maintaining a Database Using the Design and Update Features of Access
Objectives	1	(3)
Introduction	4	(1)
Project Three--Maintaining the Bavant Marine Services Database	5	(1)
Opening the Database	6	(1)
Adding, Changing, and Deleting Records in a Table	6	(9)
Adding Records in a Table	6	(2)
Searching for a Record	8	(2)
Changing the Contents of a Record	10	(1)
Switching Between Views	11	(1)
Filtering Records	12	(2)
Deleting Records	14	(1)
Changing the Structure of a Database	15	(13)
Changing the Size of a Field	15	(2)
Adding a New Field	17	(2)
Deleting a Field from a Table	19	(1)
Updating the Restructured Database	19	(1)
Resizing Columns	20	(3)
Using an Update Query	23	(3)
Using a Delete Query to Delete a Group of Records	26	(2)
Creating Validation Rules	28	(10)
Specifying a Required Field	28	(1)
Specifying a Range	29	(1)
Specifying a Default Value	30	(1)
Specifying a Collection of Legal Values	31	(1)
Using a Format	32	(1)
Saving Rules, Values, and Formats	33	(1)
Updating a Table that Contains Validation Rules	34	(2)
Making Individual Changes to a Field	36	(2)
Specifying Referential Integrity	38	(3)
Using Subdatasheets	41	(1)
Ordering Records	42	(2)
Ordering Records on Multiple Fields	43	(1)
Creating and Using Indexes	44	(6)
How Does Access Use an Index?	46	(1)
When Should You Create an Index?	47	(1)
Creating Single-Field Indexes	47	(1)
Creating Multiple-Field Indexes	48	(2)
Closing the Database	50	(1)
Project Summary	51	(1)
What You Should Know	51	(1)
Apply Your Knowledge	52	(1)
In the Lab	53	(6)
Cases and Places	59
WEB FEATURE Publishing to the Internet Using Data Access Pages	AW 1.1
Introduction	AW 1.1
Opening the Database	AW 1.3
Creating a Data Access Page	AW 1.3
Previewing the Data Access Page	AW 1.8
Using the Data Access Page	AW 1.9
Web Feature Summary	AW 1.10
What You Should Know	AW 1.10
In the Lab	AW 1.11
APPENDIX A Microsoft Access 2000 Help System	A A.1
Using the Access Help System	A A.1
The Office Assistant	A A.2
Showing and Hiding the Office Assistant	A A.3
Turning the Office Assistant On and Off	A A.3
Using the Office Assistant	A A.4
The Microsoft Access Help Window	A A.5
Using the Contents Sheet	A A.6
Using the Answer Wizard Sheet	A A.7
Using the Index Sheet	A A.7
What's This? Command and Question Mark Button	A A.9
What's This? Command	A A.9
Question Mark Button	A A.9
Office on the Web Command	A A.10
Other Help Commands	A A.10
Detect and Repair Command	A A.10
About Microsoft Access Command	A A.10
Use Help	A A.11
APPENDIX B Publishing Office Web Pages to a Web Server	A B.1
APPENDIX C Resetting the Access Menus and Toolbars	A C.1
APPENDIX D Microsoft Office User Specialist Certification Program	A D.1
Why Should You Get Certified?	A D.1
The MOUS Exams	A D.1
How Can You Prepare for the MOUS Exams?	A D.2
How to Find an Authorized Testing Center	A D.2
Shelly Cashman Series MOUS Web Page	A D.2