Microsoft Access 2000

by Martin, Edward G.; Parker, Charles S.; Kee, Charles E.

• ISBN13: 9780030259920
• ISBN10: 0030259924
• Edition: 2nd
• Format: Paperback
• Copyright: 1999-09-01
• Publisher: Course Technology Ptr

Summary

Ed Martin and Charles Parker developed the Mastering Today's Software (MTS) series to introduce today's students to the basics of software applications as well as to show how they can successfully be applied at home, school or in the business world.

Table of Contents

UNIT 1 DATABASE MANAGEMENT	1	(58)
Getting Started	2	(7)
Starting Windows	3	(2)
Mouse and Keyboard Operations	5	(1)
Launching and Exiting Access	6	(3)
Understanding The Access Window	9	(7)
The Access Window	9	(1)
Menus and Toolbars	9	(3)
Creating a Database File	12	(2)
The Database Window	14	(2)
Getting Help	16	(5)
Using Access's Office Assistant	16	(2)
Using the Contents and Index Lists	18	(1)
Using the ``What's This?'' Feature	19	(2)
Creating A Table	21	(11)
Defining Fields	22	(5)
Default Values and Validation Options	27	(1)
Saving, Closing, and Opening a Table	28	(2)
Opening and Closing an Access Database File	30	(2)
Entering Records	32	(7)
Entering Data into a Table	33	(3)
Entering Data into a Form	36	(3)
Examining Field Values	39	(20)
Scrolling through Fields and Records	39	(4)
Locating Specific Field Data	43	(2)
Changing the Size and Order of Field Columns	45	(2)
Printing	47	(4)
Unit Review	51	(8)
UNIT 2 ENHANCING THE DATABASE: MODIFYING STRUCTURE, EDITING DATA, QUERYING, AND REPORTING	59	(68)
Modifying A Table's Structure	60	(5)
Adding Fields	60	(3)
Modifying a Field's Properties	63	(1)
Deleting a Field	64	(1)
Locating and Editing Data	65	(10)
Editing Data	66	(6)
Sorting Records	72	(1)
Filtering Records	73	(2)
Creating Queries	75	(14)
Displaying Selected Fields	76	(1)
Selecting Records	77	(7)
Combining Search Criteria	84	(3)
Creating Summary Statistics	87	(2)
Altering Data with Queries	89	(5)
Modifying Data in All Records	90	(1)
Replacing Data in Selected Records	91	(3)
Creating Reports	94	(9)
Creating AutoReports	94	(3)
Duplicating, Renaming, and Deleting Reports	97	(1)
Creating a Custom Report	98	(5)
Modifying A Report	103	(24)
Understanding Report Design View	103	(1)
Working with Objects	104	(6)
Adding Calculated Fields and Summary Objects	110	(8)
Unit Review	118	(9)
UNIT 3 DATABASE MANAGEMENT, LABELS, RELATIONAL DATABASES, CHARTS, AND SHARING DATA	127	(75)
Database Management	128	(12)
Managing Files	128	(4)
Managing Objects	132	(5)
Copying and Appending Records	137	(3)
Creating Labels	140	(4)
Using the Label Wizard	141	(2)
Modifying Labels	143	(1)
Creating Customized Forms	144	(14)
Using the Form Wizard	144	(2)
Understanding From Design View	146	(2)
Modifying a Form	148	(1)
Using a Custom From	148	(10)
Relational Databases---Using Multiple Tables	158	(12)
Creating a One-to-Many Link	162	(2)
Creating a Many-to-One Link	164	(6)
Creating Basic Charts	170	(9)
Creating a Chart	173	(2)
Editing a Chart	175	(4)
Sharing Files	179	(23)
Linking Data from Other Applications	179	(3)
Preparing Access Objects for the World Wide Web	182	(5)
Downloading from the World Wide Web	187	(1)
Exporting and Importing	188	(5)
Unit Review	193	(9)
Appendix	202	(11)
Glossary	213	(4)
Index	217