Microsoft Access 2003: Specialist & Expert

by Rutkosky, Nita Hewitt; Flynn, Meredith

• ISBN13: 9780763820459
• ISBN10: 0763820458
• Format: Paperback
• Copyright: 2003-12-01
• Publisher: Paradigm Education

Table of Contents

Microsoft Office Specialist Certification	viii
Getting Started	1	(1)
Using Windows XP	1	(1)
Browsing the Internet Using Internet Explorer	1	(1)
Microsoft Access 2003 Specialist	1	(4)
Specialist Unit 1: Creating Database Tables, Queries, and Filters	5	(134)
Unit 1 Microsoft Office Specialist Skills Table	6	(1)
Creating a Database Table	7	(34)
Organizing Data in a Database Table	8	(9)
Determining Fields	8	(1)
Assigning a Data Type to Fields	9	(2)
Creating a Database Table	11	(6)
Entering Data in a Table	17	(3)
Opening a Database File	17	(1)
Entering Data in a Database Table	18	(2)
Printing a Database Table	20	(4)
Changing Page Setup	21	(1)
Changing Field Width	22	(2)
Maintaining a Database Table	24	(1)
Adding a Record to a Table	24	(1)
Deleting a Record to a Table	24	(1)
Modifying a Table	25	(16)
Adding a Field	25	(1)
Deleting a Field	26	(1)
Using the Input Mask Wizard	26	(1)
Using the Lookup Wizard	27	(5)
Moving a Field	32	(1)
Sorting Records	33	(1)
Chapter Summary	34	(1)
Features Summary	35	(1)
Concepts Check	36	(1)
Skills Check	36	(4)
Chapter Challenge	40	(1)
Creating Relationships between Database Tables	41	(26)
Creating Related Tables	41	(17)
Determining Relationships	42	(1)
Creating a Primary Field	43	(1)
Creating a Foreign Key	43	(3)
Establishing a Relationship between Tables	46	(1)
Creating a One-to-Many Relationship	47	(3)
Printing Database Relationships	50	(1)
Relating Tables in the Southwest Insurance Database File	50	(7)
Editing and Deleting a Relationship	57	(1)
Displaying Related Records in a Subdatasheet	58	(9)
Chapter Summary	60	(1)
Features Summary	61	(1)
Concepts Check	62	(1)
Skills Check	62	(3)
Chapter Challenge	65	(2)
Using Wizards and Help	67	(26)
Creating a Database Table Using the Table Wizard	67	(9)
Completing a Spelling Check	76	(1)
Finding and Replacing Data	77	(6)
Backing Up a Database File	81	(1)
Compacting and Repairing a Database File	81	(2)
Using Help	83	(10)
Getting Help Using the Ask a Question Text Box	83	(1)
Getting Help from the Microsoft Access Help Task Pane	84	(1)
Chapter Summary	85	(1)
Features Summary	86	(1)
Concepts Check	87	(1)
Skills Check	87	(4)
Chapter Challenge	91	(2)
Performing Queries and Filtering Records	93	(46)
Performing Queries	93	(15)
Designing a Query	94	(1)
Establishing Query Criteria	95	(5)
Sorting Fields in a Query	100	(1)
Performing a Query with the Simple Query Wizard	101	(4)
Creating a Calculated Field	105	(3)
Designing Queries with Aggregate Functions	108	(5)
Changing Query Column Headings	111	(2)
Creating a Crosstab Query	113	(2)
Creating a Find Duplicates Query	115	(4)
Creating an Unmatched Query	119	(1)
Filtering Data	120	(11)
Using Filter By Selection	120	(2)
Using Filter By Form	122	(2)
Chapter Summary	124	(1)
Features Summary	125	(1)
Concepts Check	126	(1)
Skills Check	126	(4)
Chapter Challenge	130	(1)
Specialist Unit 1 Performance Assessment	131	(1)
Assessing Proficiencies	131	(6)
Writing Activities	137	(1)
Internet Project	138	(1)
Job Study	138	(1)
Specialist Unit 2: Creating Forms and Reports	139	(128)
Unit 2 Microsoft Office Specialist Skills Table	140	(1)
Creating Forms	141	(30)
Creating a Form	141	(10)
Creating a Form Using AutoForm	142	(3)
Creating a Form Using the Form Wizard	145	(5)
Creating a Form with Related Database Tables	150	(1)
Creating a Form in Design View	151	(20)
Using Fields to Add Controls	152	(1)
Moving Control Objects	152	(1)
Resizing Control Objects	153	(1)
Formatting Control Objects	153	(1)
Aligning Control Objects	154	(4)
Adding Controls Using the Toolbox	158	(1)
Adding a Form Header and Form Footer	159	(2)
Adding a Calculated Control	161	(3)
Chapter Summary	164	(1)
Features Summary	165	(1)
Concepts Check	166	(1)
Skills Check	166	(3)
Chapter Challenge	169	(2)
Creating Reports, Mailing Labels, and Charts	171	(38)
Creating Reports	171	(8)
Creating a Report Using Auto Report	172	(1)
Creating a Report Using the Report Wizard	172	(6)
Preparing a Report Based on Two Database Tables	178	(1)
Creating a Report in Design View	179	(7)
Using Fields to Add Controls	181	(1)
Moving, Resizing, and Customizing Control Objects	181	(1)
Adding Controls Using the Toolbox	181	(1)
Adding a Report Header and Report Footer	181	(5)
Preparing Mailing Labels	186	(4)
Creating a Chart	190	(4)
Summarizing Data by Changing Views	194	(1)
Summarizing Data using PivotTable View	194	(5)
Summarizing Data Using PivotChart View	199	(10)
Chapter Summary	202	(1)
Features Summary	203	(1)
Concepts Check	203	(1)
Skills Check	204	(3)
Chapter Challenge	207	(2)
Importing and Exporting Data	209	(28)
Using OfficeLinks	209	(12)
Exporting Data to Excel	209	(3)
Exporting Data to Word	212	(3)
Merging Access Data with a Word Document	215	(4)
Merging Query Data with a Word Document	219	(2)
Importing and Linking Data to a New Table	221	(3)
Importing Data to a New Table	221	(2)
Linking Data to a New Table	223	(1)
Using the Office Clipboard	224	(2)
Viewing Objects and Object Dependencies	226	(1)
Displaying Database Contents	227	(1)
Viewing Object Dependencies	227	(10)
Chapter Summary	230	(1)
Features Summary	231	(1)
Concepts Check	231	(1)
Skills Check	232	(3)
Chapter Challenge	235	(2)
Creating Web Pages and Using Database Wizards	237	(30)
Creating a Data Access Page	237	(2)
Saving a Table as a Web Page	237	(1)
Applying a Theme to a Web Page	238	(1)
Previewing a Web Page in Web Page Preview	239	(4)
Creating Hyperlinks	240	(3)
Creating a Database with a Wizard	243	(14)
Chapter Summary	251	(1)
Features Summary	252	(1)
Concepts Check	252	(1)
Skills Check	253	(2)
Chapter Challenge	255	(2)
Specialist Unit 2 Performance Assessment	257	(1)
Assessing Proficiencies	257	(7)
Writing Activities	264	(1)
Internet Project	265	(1)
Job Study	265	(2)
Index	267	(51)
Microsoft Access 2003 Expert	1	(4)
Expert Unit 1: Advanced Tables, Forms, Queries, and Reports	5	(164)
Unit 1 Learning Objectives Table	6	(1)
Creating and Modifying Advanced Tables	7	(34)
Data Types	8	(1)
Creating a Table Using the Table Wizard	9	(5)
Creating a Table Using Design View	14	(2)
Modifying a Table's Design	16	(2)
Controlling Data Entry in Tables	18	(2)
Field Size	18	(1)
Validation Rules and Text	19	(1)
Creating and Modifying an Input Mask	20	(7)
Creating and Modifying Lookup Fields	24	(3)
Formatting Field Values	27	(1)
Propagating Field Properties	28	(3)
Backing Up A Database File	31	(1)
Compacting and Repairing a Database	31	(10)
Chapter Summary	33	(1)
Features Summary	34	(1)
Concepts Check	34	(1)
Skills Check	35	(3)
Chapter Challenge	38	(3)
Creating and Modifying Forms	41	(42)
Creating Controls	42	(1)
Creating a Form Using the Form Wizard	42	(3)
Building a Form Using Design View	45	(5)
Adding Titles and Graphics to a Form	50	(7)
Adding Titles Inside Label Boxes	51	(2)
Adding a Picture to a Form	53	(1)
Customizing the Form Header, Detail, and Form Footer Sections	54	(3)
Moving and Resizing Control Objects and Displaying the Grid	57	(2)
Moving Control Objects	57	(2)
Resizing Control Objects	59	(1)
Displaying the Grid	59	(1)
Modifying Control Properties	60	(2)
Creating a Calculated Control	62	(2)
Form Properties	64	(2)
Creating a Form with Two Tables	66	(2)
Modifying the Subform	68	(3)
Creating a Switchboard	71	(2)
Using Error Checking in Forms	73	(1)
Applying Themes to Views, Dialog Boxes, and Controls	74	(9)
Chapter Summary	75	(2)
Features Summary	77	(1)
Concepts Check	77	(1)
Skills Check	78	(3)
Chapter Challenge	81	(2)
Refining Queries	83	(40)
Applying Filters to a Query	84	(6)
Refining a Query Using the Filter By Selection Button	84	(1)
Refining a Query Using the Filter By Form Button	84	(6)
Creating and Applying Advanced Filters	90	(2)
Joining Two Tables in a Query	92	(1)
Performing Calculations in a Query	92	(9)
Creating a Totals Query	92	(4)
Creating a Custom Calculation	96	(2)
Creating A Crosstab Query	98	(3)
Creating a Parameter Query	101	(4)
Creating an Action Query	105	(5)
Creating a Delete Query	106	(1)
Creating an Append Query	107	(1)
Creating a Make-Table Query	107	(1)
Creating an Update Query	108	(2)
Specifying Multiple Criteria for a Query in Design View	110	(1)
Modifying Field Properties	111	(12)
Chapter Summary	115	(1)
Features Summary	116	(1)
Concepts Check	117	(1)
Skills Check	117	(4)
Chapter Challenge	121	(2)
Using Advanced Report Features	123	(46)
Understanding the Parts of a Report	123	(3)
Creating a Report in Design View	126	(4)
Modifying a Report in Design View	130	(3)
Formatting Text in a Control	131	(1)
Adding Page Numbers to a Report	131	(1)
Adding the Current Date and Time to a Report	132	(1)
Printing a Report	133	(2)
Sorting Records in a Report	135	(1)
Grouping Records in a Report	136	(3)
Adding Graphics to a Report	139	(2)
Modifying Properties for a Report, Section, or Control	141	(1)
Calculating a Total or an Average	142	(6)
Embedding a Subreport	148	(3)
Using Error Checking in Reports	151	(8)
Chapter Summary	153	(1)
Features Summary	154	(1)
Concepts Check	154	(1)
Skills Check	155	(3)
Chapter Challenge	158	(1)
Expert Unit 1 Performance Assessment	159	(1)
Assessing Proficiencies	159	(8)
Writing Activities	167	(1)
Internet Project	167	(1)
Job Study	168	(1)
Expert Level Unit 2: Automating, Securing, and Integrating Databases	169	(149)
Unit 2 Learning Objectives Table	170	(1)
Defining Relationships	171	(60)
Understanding Relationships in an Access Database	172	(4)
Defining Relationships between Tables	176	(1)
Viewing Existing Relationships between Tables	177	(1)
Printing the Relationships Window	178	(5)
Understanding Referential Integrity	183	(1)
Editing an Existing Relationship	184	(1)
Using Cascade Update and Cascade Delete Options	185	(2)
Understanding Join Types	187	(2)
Using Indexes	189	(8)
Chapter Summary	192	(1)
Features Summary	193	(1)
Concepts Check	194	(1)
Skills Check	194	(2)
Chapter Challenge	196	(1)
Using Access Tools
Assigning User-Level Security	197	(9)
Setting a Database Password	198	(1)
Removing a Database Password	198	(3)
Adding Permissions to a Database	201	(5)
Encoding and Decoding a Database	206	(2)
Setting Startup Options	208	(2)
Using the Table Analyzer Wizard	210	(3)
Converting an Access 2002-2003 Database to Access 97 or Access 2000	213	(1)
Creating Macros	214	(4)
Creating a Command Button That Runs a Macro	218	(2)
Understanding Macro Security Levels	220	(1)
Using AutoCorrect	221	(10)
Chapter Summary	223	(1)
Features Summary	224	(1)
Concepts Check	224	(1)
Skills Check	225	(5)
Chapter Challenge	230	(1)
Creating Database Applications	231	(20)
Using the Database Splitter Wizard	231	(2)
Linking an External Table	233	(4)
Making a Local Table from a Linked Table	237	(1)
Create Access Modules Using Visual Basic Routines	238	(6)
Creating an MDE File	244	(7)
Chapter Summary	246	(1)
Features Summary	246	(1)
Concepts Check	247	(1)
Skills Check	247	(2)
Chapter Challenge	249	(2)
Using Data from the Internet and Other Sources	251	(67)
Exporting Records to Excel	252	(5)
Exporting Records Using OfficeLinks	252	(3)
Exporting Records Using Drag and Drop	255	(2)
Presenting Data in a Chart	257	(5)
Linking an Excel Workbook to an Access Database	262	(3)
Creating a Data Access Page	265	(10)
Using the Group and Sort Features of Data Access Pages	269	(4)
Creating a Hyperlink Field	273	(2)
Creating a Lookup Field to Use Sorted Data in Another Table	275	(3)
Creating PivotTables and PivotCharts in Data Access Pages	278	(8)
Creating a PivotTable in a Data Access Page	278	(6)
Saving a PivotChart as a Data Access Page	284	(2)
Using XML to Share Data	286	(20)
XML Design	286	(1)
Rules Governing the Design of XML Documents	287	(1)
Advantages of Self-Documenting XML Files	288	(1)
XML Schemas Provide Structure	289	(1)
XML Style Sheet Transformations	289	(1)
Importing XML Data into Access 2003	290	(4)
Exporting XML Data	294	(1)
Exporting File Options	295	(6)
Exporting Multiple Tables	301	(5)
Chapter Summary	306	(7)
Features Summary	307	(1)
Concepts Check	307	(1)
Skills Check	308	(4)
Chapter Challenge	312	(1)
Unit 2 Performance Assessment	313	(1)
Assessing Proficiencies	313	(3)
Writing Activities	316	(1)
Internet Project	316	(1)
Job Study	317	(1)
Index	318