Cover image for Microsoft Access 2002 MOUS core level
Microsoft Access 2002 MOUS core level
Winters, Floyd Jay.
Personal Author:
Publication Information:
Upper Saddle River, N.J. : Prentice Hall, 2003.
Physical Description:
xvi, 301 pages color illustrations ; 28 cm.
Title Subject:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.3 .W58 2003 Adult Non-Fiction Non-Fiction Area-Oversize

On Order



Step-by-step tutorials, chapter exercises, screen shots, and notes on common problems help prepare students for the Core level of the Microsoft Office User Specialist (MOUS) certification exam. Other learning features include chapter summaries, key terms, challenge exercises, and notes on different

Author Notes

Floyd Jay Winters received a BA degree from Rutgers University and an MA and an Ed. S. from Nova Southeastern University. He spent a semester sabbatical at the Harvard Graduate School. He taught three graduate level courses for Kent State University and several more graduate level courses for Nova Southeastern University in the 1980s. Floyd has been a Computer Science professor at Manatee Community College since 1986.

Floyd also coauthored Web Collaboration Using Microsoft Office and NetMeeting. His first textbook was Microcomputer Troubleshooting and Maintenance. Floyd is MOUS certified, NET+ certified, A+ certified, and he is also Cisco CCNA and CCAI certified. Before accepting his position at MCC he was the lead service technician for a computer dealer with stores in three counties. In that capacity, he was authorized and certified as a computer repair specialist by IBM and Apple. Floyd has been an active computer consultant since 1982. During the past five years, most of his consulting work has been focused on writing Microsoft Access databases for local businesses and charitable organizations.

Floyd was a varsity wrestling coach for 10 years; his teams won several championships and posted an undefeated string of 3 I straight wins over a two-year period. He also was a championship youth soccer coach.

Julie T. Manchester got her start in the computer science field in 1976, in the days of punched cards and long strings of complex job control language. She graduated from the Computer Processing Institute in East Hartford, CT Julie has worked on IBM mainframes, programming in COBOL for such companies as Raytheon and Maryland Casualty. She worked as a project team member designing, writing, and implementing an online inventory system at Raytheon and wrote custom-tailored, data-entry and data-transmission programs for Maryland Casualty's regional offices. Julie has edited computer repair, networking, and Windows textbooks and manuals. She has designed, customized, and installed database projects for local businesses. Julie also coauthored Web Collaboration Using Microsoft Office and NetMeeting.

Julie earned an A.A. in Business Administration and an A.S. in Computer Science from Manatee Community College, and a B.S. in Management from University of South Florida. Julie is MOUS certified.

Table of Contents

About Access 2002p. 1
Open Access and Explore the Access Workspacep. 2
Use Access Helpp. 5
A Brief Overview of Database Designp. 12
Chapter 1 Core Skill Set 1 Creating and Using Databasesp. 15
Skill 1.1 Create Access Databasesp. 17
Create a Database with the Database Wizardp. 17
Create a Database in Design Viewp. 25
Skill 1.2 Open Database Objects in Multiple Viewsp. 32
Open a Table in Two Viewsp. 32
Open a Form in Two Viewsp. 37
Open a Query in Two Viewsp. 40
Open a Report in Two Viewsp. 42
Skill 1.3 Move Among Recordsp. 44
Skill 1.4 Format Datasheetsp. 48
Summaryp. 51
Skill Drillp. 51
Challengep. 54
Chapter 2 Core Skill Set 2 Creating and Modifying Tablesp. 57
Skill 2.1 Create and Modify Tablesp. 58
Create a Table Using the Table Design Wizardp. 58
Create a Table in Design Viewp. 65
Skill 2.2 Add a Predefined Input Mask to a Fieldp. 72
Use the Input Mask Wizardp. 72
Skill 2.3 Create Lookup Fieldsp. 77
Use the Lookup Wizardp. 77
Skill 2.4 Modify Field Propertiesp. 82
Add an Input Mask to a Field in a Tablep. 82
Modify Field Properties of a Table in Design Viewp. 85
Summaryp. 89
Skill Drillp. 89
Challengep. 91
Chapter 3 Core Skill Set 3 Creating and Modifying Queriesp. 95
Skill 3.1 Create and Modify Select Queriesp. 97
Create Select Queries Using the Simple Query Wizardp. 98
Create a Query in Design Viewp. 102
Skill 3.2 Add Calculated Fields to Select Queriesp. 108
Add a Calculated Field in Query Design Viewp. 108
Format a Calculated Fieldp. 110
Summaryp. 112
Skill Drillp. 112
Challengep. 113
Chapter 4 Core Skill Set 4 Creating and Modifying Formsp. 115
Skill 4.1 Create and Display Formsp. 117
Create an AutoFormp. 118
Create a Form Using the Form Wizardp. 122
Skill 4.2 Modify Form Propertiesp. 127
Modify Properties of a Formp. 128
Add and Format Controls on a Formp. 133
Modify Control Properties on a Formp. 142
Modify Left, Top, Width, and Height Propertiesp. 146
Summaryp. 152
Skill Drillp. 152
Challengep. 154
Chapter 5 Core Skill Set 5 Viewing and Organizing Informationp. 157
Skill 5.1 Enter, Edit, and Delete Recordsp. 158
Enter Records in a Datasheetp. 158
Enter Records Using a Formp. 162
Edit and Delete Records Using a Datasheetp. 165
Edit and Delete Records Using a Formp. 167
Skill 5.2 Create Queriesp. 170
Skill 5.3 Sort Recordsp. 177
Sort Records in a Datasheetp. 178
Sort Records in Query Design Viewp. 180
Sort Records in Report Design Viewp. 182
Skill 5.4 Filter Recordsp. 187
Use Filter by Formp. 188
Use Filter by Selectionp. 193
Summaryp. 196
Skill Drillp. 196
Challengep. 198
Chapter 6 Core Skill Set 6 Defining Relationshipsp. 201
Skill 6.1 Create One-to-Many Relationshipsp. 203
Create a One-to-Many Relationshipp. 204
Delete a Relationship Between Two Tablesp. 211
Skill 6.2 Enforce Referential Integrityp. 214
Enforce Referential Integrity Between Two Tablesp. 214
Print Relationshipsp. 217
Summaryp. 219
Skill Drillp. 219
Challengep. 220
Chapter 7 Core Skill Set 7 Producing Reportsp. 223
Skill 7.1 Create and Format Reportsp. 225
Create a Report Using the Report Wizardp. 225
Modify and Format a Report in Design Viewp. 233
Skill 7.2 Add Calculated Controls to Reportsp. 238
Skill 7.3 Preview and Print Reportsp. 248
Summaryp. 252
Skill Drillp. 252
Challengep. 254
Chapter 8 Core Skill Set 8 Integrating with Other Applicationsp. 257
Skill 8.1 Import Data to Accessp. 258
Import from Another Access Databasep. 258
Import from Excelp. 263
Skill 8.2 Export Data from Accessp. 268
Export to Another Access Databasep. 268
Export to Wordp. 271
Skill 8.3 Create a Simple Data Access Pagep. 273
Create a Data Access Page Using a Wizardp. 274
Open and Use a Data Access Pagep. 279
Summaryp. 284
Skill Drillp. 284
Challengep. 286
Glossaryp. 289
Indexp. 293