New Perspectives on Microsoft Access 2002

by Adamski,Joseph J.

• ISBN13: 9780619020880
• ISBN10: 0619020881
• Format: Paperback
• Copyright: 2001-09-17
• Publisher: Cengage Learning

Table of Contents

Preface	v
Microsoft Office XP	1	(1)
Read This Before You Begin	2	(1)
Tutorial 1	3	(1)
Introducing Microsoft Office XP
Preparing Promotional Materials for Delmar Office Supplles
Exploring Microsoft Office XP	4	(3)
Integrating Programs	7	(2)
Starting Office Programs	9	(3)
Switching Between Open Programs and Files	12	(1)
Using Personalized Menus and Toolbars	13	(2)
Using Speech Recognition	15	(1)
Saving and Closing a File	16	(2)
Opening a File	18	(2)
Printing a File	20	(1)
Getting Help	21	(2)
Exiting Programs	23	(1)
Quick Check	23	(1)
Review Assignments	23	(1)
Quick Check Answers	24
Microsoft Access 2002
Level I Tutorials	1	(1)
Read This Before You Begin	2	(1)
Tutorial 1	3
Introduction to Microsoft Access 2002
Viewing and Working with a Table Containing Employer Data
Session 1.1	4	(9)
Introduction to Database Concepts	4	(1)
Organizing Data	4	(1)
Databases and Relationships	4	(2)
Relational Database Management Systems	6	(1)
Opening an Existing Database	7	(3)
The Access and Database Windows	10	(1)
Opening an Access Table	10	(1)
Navigating an Access Datasheet	11	(1)
Saving a Database	12	(1)
Session 1.1 Quick Check	13	(1)
Session 1.2	13
Working with Queries	13	(1)
Opening an Existing Query	13	(2)
Creating, Sorting, and Navigating a Query	15	(3)
Creating and Navigating a Form	18	(2)
Creating, Previewing, and Navigating a Report	20	(3)
Managing a Database	23	(1)
Backing Up and Restoring a Database	23	(1)
Compacting and Repairing a Database	24	(1)
Compacting a Database Automatically	24	(1)
Converting an Access 2000 Database	25	(1)
Session 1.2 Quick Check	26	(1)
Review Assignments	27	(1)
Case Problems	28	(3)
Lab Assignments	31	(1)
Internet Assignments	32	(1)
Quick Check Answers	32
Tutorial 2	1	(1)
Creating and Maintaining a Database
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table
Session 2.1	2	(17)
Guidelines for Designing Databases	2	(2)
Guidelines for Setting Field Properties	4	(1)
Naming Fields and Objects	4	(1)
Assigning Field Data Types	5	(1)
Setting Field Sizes	6	(1)
Creating a New Database	7	(1)
Creating a Table	8	(1)
Defining Fields	9	(7)
Specifying the Primary Key	16	(1)
Saving the Table Structure	17	(1)
Session 2.1 Quick Check	18	(1)
Session 2.2	19
Adding Records to a Table	19	(3)
Modifying the Structure of an Access Table	22	(1)
Deleting a Field	23	(1)
Moving a Field	24	(1)
Adding a Field	24	(2)
Changing Field Properties	26	(3)
Obtaining Data from Another Access Database	29	(1)
Copying Records from Another Access Database	29	(3)
Importing a Table from Another Access Database	32	(1)
Updating a Database	33	(1)
Deleting Records	33	(1)
Changing Records	34	(1)
Session 2.2 Quick Check	35	(1)
Review Assignments	36	(1)
Case Problems	37	(5)
Internet Assignments	42	(1)
Quick Check Answers	42
Tutorial 3	1	(1)
Querying a Database
Retrieving Information About Employers and Their Positions
Session 3.1	1	(21)
Introduction to Queries	2	(1)
Query Window	2	(3)
Creating and Running a Query	5	(2)
Updating Data Using a Query	7	(1)
Defining Table Relationships	8	(1)
One-to-Many Relationships	8	(1)
Referential Integrity	9	(1)
Defining a Relationship Between Two Tables	9	(4)
Creating a Multi-table Query	13	(1)
Sorting Data in a Query	14	(1)
Using a Toolbar Button to Sort Data	15	(1)
Sorting Multiple Fields in Design View	16	(3)
Filtering Data	19	(2)
Session 3.1 Quick Check	21	(1)
Session 3.2	22
Defining Record Selection Criteria for Queries	22	(1)
Specifying an Exact Match	22	(3)
Changing a Datasheet's Appearance	25	(1)
Using a Comparison Operator to Match a Range of Values	26	(2)
Defining Multiple Selection Criteria for Queries	28	(1)
The And Logical Operator	29	(1)
Using Multiple Undo and Redo	30	(1)
The Or Logical Operator	31	(2)
Performing Calculations	33	(1)
Creating a Calculated Field	34	(4)
Using Aggregate Functions	38	(2)
Using Record Group Calculations	40	(1)
Session 3.2 Quick Check	41	(1)
Review Assignments	42	(1)
Case Problems	43	(3)
Internet Assignments	46	(1)
Quick Check Answers	46
Tutorial 4	1	(2)
Creating Forms and Reports
Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report
Session 4.1	2	(14)
Creating a Form Using the Form Wizard	2	(3)
Changing a Form's AutoFormat	5	(3)
Finding Data Using a Form	8	(3)
Previewing and Printing Selected Form Records	11	(1)
Maintaining Table Data Using a Form	12	(2)
Checking the Spelling of Table Data Using a Form	14	(2)
Session 4.1 Quick Check	16	(1)
Session 4.2	16
Creating a Form with a Main Form and a Subform	16	(3)
Modifying a Form in Design View	19	(3)
Creating a Report Using the Report Wizard	22	(8)
Inserting a Picture in a Report	30	(4)
Session 4.2 Quick Check	34	(1)
Review Assignments	34	(2)
Case Problems	36	(4)
Internet Assignments	40	(1)
Quick Check Answers	40
Microsoft Access 2002
Level II Tutorials	1	(1)
Read This Before You Begin	2	(1)
Tutorial 5	3
Enhancing a Table's Design, and Creating Advanced Queries and Custom Forms
Making the Jobs Database Easier to Use
Session 5.1	4	(19)
Creating a Lookup Wizard Field	4	(5)
Displaying Related Records in a Subdatasheet	9	(1)
Using the Input Mask Wizard	10	(3)
Defining Data Validation Criteria	13	(2)
Using a Pattern Match in a Query	15	(2)
Using a List-of-Values Match in a Query	17	(1)
Using a Nonmatching Value in a Query	18	(1)
Using Both the And and Or Operators in the Same Query	19	(1)
Creating a Parameter Query	20	(2)
Session 5.1 Quick Check	22	(1)
Session 5.2	23	(19)
Creating a Custom Form	23	(1)
Designing a Custom Form	23	(2)
The Form Window in Design View	25	(3)
Adding Fields to a Form	28	(1)
Selecting and Moving Controls	29	(2)
Changing a Label's Caption	31	(2)
Resizing Controls	33	(2)
Using Form Headers and Form Footers	35	(2)
Adding a Label to a Form	37	(2)
Adding a Picture to a Form	39	(1)
Changing the Background Color of a Form Control	40	(2)
Session 5.2 Quick Check	42	(1)
Session 5.3	42
Creating a Multi-page Form Using Tab Controls	42	(6)
Adding a Subform Using Control Wizards	48	(5)
Using a Filter with a Form	53	(1)
Using Filter By Form	53	(3)
Saving a Filter as a Query	56	(1)
Applying a Filter Saved as a Query	57	(1)
Session 5.3 Quick Check	58	(1)
Review Assignments	58	(3)
Case Problems	61	(8)
Internet Assignments	69	(1)
Quick Check Answers	69
Tutorial 6	1	(1)
Creating Custom Reports
Creating a Potential Income Report
Session 6.1	2	(20)
Creating a Custom Report	2	(2)
Designing a Custom Report	4	(1)
Reviewing and Creating Queries for a Custom Report	5	(3)
Assigning a Conditional Value to a Calculated Field	8	(2)
Report Window in Design View	10	(2)
Sorting and Grouping Data in a Report	12	(2)
Adding Fields to a Report	14	(1)
Working with Controls	15	(1)
Changing the Caption Property	15	(2)
Moving and Resizing Controls	17	(2)
Aligning Controls	19	(2)
Session 6.1 Quick Check	21	(1)
Session 6.2	22	(19)
Adding a Subreport Using Control Wizards	22	(1)
Modifying a Subreport	23	(4)
Adding Lines to a Report	27	(1)
Hiding Duplicate Values in a Report	28	(1)
Calculating Group Totals	29	(3)
Defining Conditional Formatting Rules	32	(4)
Using Domain Aggregate Functions	36	(4)
Session 6.2 Quick Check	40	(1)
Session 6.3	41
Adding the Date to a Report	41	(2)
Adding Page Numbers to a Report	43	(2)
Adding a Title to a Report	45	(5)
Creating Mailing Labels	50	(7)
Session 6.3 Quick Check	57	(1)
Review Assignments	57	(1)
Case Problems	58	(9)
Internet Assignments	67	(1)
Quick Check Answers	68
Tutorial 7	1	(1)
Integrating Access with the Web and with Other Programs
Creating Web-Enabled and Integrated Information for the Jobs Database
Session 7.1	2	(23)
Using the Web	2	(1)
Exporting an Access Query to an HTML Document	2	(3)
Viewing an HTML Document Using Internet Explorer	5	(3)
Creating a Data Access Page for an Access Table	8	(3)
Updating Data on a Data Access Page Using Internet Explorer	11	(2)
Using a Data Access Page to Sort and Filter Records	13	(1)
Creating a Custom Data Access Page	14	(1)
Creating a Blank Data Access Page in Design View	14	(2)
Adding Fields to a Data Access Page	16	(3)
Deleting, Moving, and Resizing Controls on a Data Access Page	19	(1)
Resizing a Section and Applying a Special Effect	20	(1)
Selecting a Theme	21	(1)
Saving and Viewing a Data Access Page	22	(2)
Session 7.1 Quick Check	24	(1)
Session 7.2	25	(21)
Creating and Using a PivotTable on a Data Access Page	25	(1)
Adding a PivotTable to a Data Access Page	26	(2)
Adding Fields to a PivotTable	28	(2)
Using a PivotTable in Page View	30	(3)
Adding a Total Field to a PivotTable	33	(4)
Creating and Using a PivotChart on a Data Access Page	37	(9)
Session 7.2 Quick Check	46	(1)
Session 7.3	46
Using XML	46	(1)
Importing an XML File as an Access Table	46	(3)
Exporting an Access Table as an XML File	49	(2)
Exporting an Access Query as an Excel Worksheet	51	(3)
Saving the Worksheet and Exiting Excel	54	(1)
Creating Hyperlinks to Other Office XP Documents	54	(1)
Creating a Hyperlink Field in a Table	55	(1)
Entering Hyperlink Field Values	56	(2)
Using a Hyperlink	58	(1)
Session 7.3 Quick Check	59	(1)
Review Assignments	60	(1)
Case Problems	61	(8)
Internet Assignments	69	(1)
Quick Check Answers	70
Appendix	1	(1)
Relational Databases and Database Design
Relations	2	(1)
Keys	3	(2)
Relationships	5	(1)
One-to-One	6	(1)
One-to-Many	6	(1)
Many-to-Many	7	(1)
Entity Subtype	8	(1)
Entity-Relationship Diagrams	9	(2)
Integrity Constraints	11	(1)
Dependencies and Determinants	12	(2)
Anomalies	14	(1)
Normalization	15	(1)
First Normal Form	15	(2)
Second Normal Form	17	(2)
Third Normal Form	19	(2)
Review Questions	21
Index	1	(9)
Task Reference	10	(6)
Certification Grid	16	(5)
File Finder	21