CHAPTER 1: WORKING WITH ACCESS 1.1 Getting Started with Access 1.1.1 Loading and Exiting Access 1.1.2 Opening a Database File at Startup 1.1.3 Touring Access 1.1.4 Working in the Database Window 1.2 Viewing and Printing Your Data 1.2.1 Moving Around a Datasheet 1.2.2 Adjusting Column Widths and Row Heights 1.2.3 Previewing and Printing 1.3 Manipulating Table Data 1.3.1 Selecting and Editing Data 1.3.2 Using the Undo Command 1.3.3 Adding Records 1.3.4 Deleting Records Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Sales Representatives 2. Iway Internet Group: Internet Accounts 3. Western Lumber Sales: Forest Products 4. Spring County Carnival: Contact List 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: LifeLong Learning Academy
CHAPTER 2: CREATING A DATABASE 2.1 Designing Your First Database 2.1.1 Planning a Database 2.1.2 Starting a New Database 2.1.3 Employing the Database Wizard 2.2 Creating a Simple Table 2.2.1 Creating a Table Using the Table Wizard 2.2.2 Creating a Table in Datasheet View 2.3 Using the Table Design View 2.3.1 Creating a Table in Design View 2.3.2 Assigning a Primary Key 2.3.3 Defining and Removing Indexes 2.4 Modifying a Table 2.4.1 Inserting and Deleting Fields 2.4.2 Renaming and Moving Fields 2.4.3 Printing a Table's Design Structure Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: New Employee Database 2. Iway Internet Group: Internet Accounts 3. Western Lumber Sales: Forest Products 4. Spring County Carnival: Contact List 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: North Star Freight
CHAPTER 3: ORGANIZING AND RETRIEVING DATA 3.1 Customizing Datasheet View 3.1.1 Formatting a Datasheet 3.1.2 Changing the Field Column Order 3.1.3 Hiding and Unhiding Columns 3.1.4 Freezing and Unfreezing Columns 3.2 Sorting, Finding, and Maintaining Data 3.2.1 Sorting Records In a Datasheet 3.2.2 Performing a Simple Search 3.2.3 Specifying Search Patterns 3.2.4 Performing a Find and Replace 3.3 Using Filters 3.3.1 Filtering For Input 3.3.2 Filtering By Selection 3.3.3 Filtering By Form 3.4 Creating a Simple Query 3.4.1 Creating a Query Using the Query Wizard Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Customer Table 2. Iway Internet Group: Internet Accounts 3. Western Lumber Sales: Forest Products 4. Spring County Carnival: Contact List 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Roundhouse Rentals
CHAPTER 4: PRESENTING AND MANAGING DATA 4.1 Creating a Simple Form 4.1.1 Creating a Form Using the AutoForm Wizards 4.1.2 Creating a Form Using the Form Wizard 4.1.3 Navigating Data Using a Form 4.1.4 Working With a Form 4.2 Creating a Simple Report 4.2.1 Creating a Report Using the AutoReport Wizards 4.2.2 Creating a Report Using the Report Wizard 4.2.3 Previewing and Printing a Report 4.2.4 Publishing a Report to the Web 4.3 Generating a Mailing Labels Report 4.3.1 Creating a Report Using the Label Wizard 4.4 Managing Database Objects 4.4.1 Renaming, Copying, and Deleting Objects 4.4.2 Compacting, Repairing, and Converting a Database Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Customer Table 2. Iway Internet Group: Internet Accounts 3. Western Lumber Sales: Forest Products 4. Spring County Carnival: Contact List 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Porterai, Inc.
CHAPTER 5: WORKING WITH TABLES 5.1 Building a Relational Database 5.1.1 Defining Table Relationships 5.1.2 Working with Related Tables 5.1.3 Printing the Relationships Window 5.1.4 Setting Object and Database Properties 5.2 Customizing Fields 5.2.1 Modifying Field Properties 5.2.2 Specifying a Field's Display Format 5.2.3 Defining a Hyperlink Field 5.2.4 Changing a Field's Data Type 5.3 Maintaining Your Data's Integrity 5.3.1 Enforcing Required Fields 5.3.2 Specifying Default Values 5.3.3 Validating Fields and Records 5.3.4 Using an Input Mask 5.3.5 Defining a Lookup Field 5.3.6 Inserting a Lookup Column 5.4 Importing, Exporting, and Copying Data 5.4.1 Importing Access Data into a New Table 5.4.2 Importing Structured Data 5.4.3 Exporting Structured Data Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Assigning Sales Reps to Customers 2. Iway Internet Group: Helping to Enter Data 3. Western Lumber Sales: Using Lookup Fields 4. Spring County Carnival: Exporting Data 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Meister Brewing
CHAPTER 6: CREATING SELECT QUERIES 6.1 Using the Query Design View 6.1.1 Creating a Query in Design View 6.1.2 Modifying a Query Object 6.1.3 Specifying Search Criteria 6.2 Creating Multi-Table Queries 6.2.1 Adding and Removing Tables 6.2.2 Adding and Removing Fields 6.2.3 Specifying Multi-Table Criteria 6.2.4 Previewing and Printing the Dynaset 6.3 Enhancing a Select Query 6.3.1 Sorting Query Results 6.3.2 Applying Filters to the Dynaset 6.3.3 Specifying Multiple Criteria in Different Fields 6.3.4 Specifying Multiple Criteria in a Single Field 6.4 Performing Calculations 6.4.1 Creating a Calculated Field 6.4.2 Setting Field Properties 6.4.3 Using the Expression Builder 6.4.4 Creating Summary Queries Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Creating a Multi-Table Query 2. Iway Internet Group: Analyzing Account Information 3. Western Lumber Sales: Querying Products 4. Spring County Carnival: Presenting Table Data in a Dynaset 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Yaletown Veterinary Clinic
CHAPTER 7: CREATING ADVANCED QUERIES 7.1 Relating Tables and Setting Joins 7.1.1 Creating Table Relationships 7.1.2 Understanding and Setting Join Properties 7.1.3 Displaying a Query in SQL View Mode 7.2 Working with Select Queries 7.2.1 Displaying the Highest or Lowest Values 7.2.2 Testing for Null Values and Zero-Length Strings 7.2.3 Entering Complex Expressions 7.2.4 Presenting Data Using a Custom Sort Order 7.2.5 Setting Query Properties 7.3 Creating Special-Purpose Queries 7.3.1 Finding Duplicate Records and Values 7.3.2 Finding Unmatched Records 7.3.3 Creating a Crosstab Query 7.3.4 Creating a Parameter Query 7.4 Creating Action Queries 7.4.1 Creating an Update Query 7.4.2 Creating a Delete Query 7.4.3 Creating a Make-Table Query 7.4.4 Creating an Append Query Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Relating Tables and Setting Joins 2. Iway Internet Group: Writing a SQL Account Query 3. Western Lumber Sales: Finding Freight Rates 4. Spring County Carnival: Creating a Crosstab Query 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Gizmo Extravaganza, Inc.
CHAPTER 8: CREATING FORMS, REPORTS, AND PAGES 8.1 Using the Form Design View 8.1.1 Viewing and Modifying a Form 8.1.2 Understanding Bound and Unbound Controls 8.1.3 Inserting, Deleting, Sizing, and Moving Controls 8.1.4 Creating a Calculated Control 8.1.5 Creating a Main Form and Subform 8.2 Customizing a Form 8.2.1 Aligning, Spacing, and Sizing Controls 8.2.2 Changing the Tab Order 8.2.3 Formatting Controls on a Form 8.2.4 Using the AutoFormat Command 8.3 Using the Report Design View 8.3.1 Viewing and Modifying a Report 8.3.2 Manipulating Controls in a Report 8.3.3 Creating a Calculated Control 8.4 Customizing a Report
8.4.1 Formatting Controls in a Report
8.4.2 Applying Conditional Formatting
8.4.3 Sorting and Grouping Data
8.4.4 Adjusting Page and Margin Settings 8.5 Creating Data Access Pages
8.5.1 Creating a Data Access Page Using a Wizard 8.5.2 Creating a Grouped Data Access Page Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises
1. AmeriSales International: Listing Customers in a Subform 2. Iway Internet Group: Listing Accounts By Billing Type 3. Western Lumber Sales: Customizing a Product Input Form 4. Spring County Carnival: Using a Report to Calculate Subtotals 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: AutoSell Traders CHAPTER 9: DESIGNING COMPLEX FORMS, REPORTS, AND PAGES
9.1 Creating Custom Forms 9.1.1 Creating a Form with a Background Picture 9.1.2 Enhancing a Form Using Graphics 9.1.3 Creating Hyperlinks in a Form 9.1.4 Setting Control Properties in a Form 9.1.5 Setting Form and Section Properties 9.2 Building Complex Forms 9.2.1 Filling In a Form Automatically 9.2.2 Enhancing a Form Using Combo Boxes 9.2.3 Using the Tab and Subform Controls 9.2.4 Displaying PivotTables and PivotCharts 9.3 Creating Custom Reports 9.3.1 Grouping Data in Report Design View 9.3.2 Using a Calculated Control to Add Line Numbers 9.3.3 Adding a Background Picture to a Report 9.3.4 Enhancing a Report Using Graphics 9.3.5 Setting Control Properties in a Report 9.3.6 Setting Report and Section Properties 9.4 Building Complex Reports 9.4.1 Creating a Multi-Column Parameter Report 9.4.2 Creating and Displaying a Chart 9.4.3 Using the Subreport Control 9.4.4 Using the Access Snapshot Viewer 9.5 Creating Custom Data Access Pages 9.5.1 Modifying a Data Access Page in Design View 9.5.2 Creating a Custom Data Access Page 9.5.3 Using Office Web Components in Data Access Pages Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Creating a Customer Form 2. Iway Internet Group: Defining Bound and Unbound Hyperlinks 3. Western Lumber Sales: Converting Text Boxes to Combo Boxes 4. Spring County Carnival: Inserting a Subreport 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Moonstruck Coffees, Inc. CHAPTER 10: AUTOMATING AND EXTENDING ACCESS
10.1 Integrating Access with Word and Excel 10.1.1 Publishing Data to Word 10.1.2 Merging Data with Word 10.1.3 Analyzing Data in Excel 10.1.4 Exporting Data to Excel 10.2 Using Access with Other Databases 10.2.1 Linking to Data in Access Databases 10.2.2 Linking to Data in Non-Access Databases 10.2.3 Using the Linked Table Manager 10.2.4 Importing and Exporting XML 10.3 Automating Your Database 10.3.1 Creating and Playing Back a Macro 10.3.2 Automating Objects in a Form or Report 10.3.3 Using Conditional Expressions in Macros 10.3.4 Creating a Switchboard Form 10.3.5 Customizing the Menu and Toolbars 10.3.6 Setting Workplace and Startup Options 10.4 Developing Database Applications 10.4.1 Using the Table Analyzer 10.4.2 Using the Performance Analyzer 10.4.3 Understanding Replication 10.4.4 Creating and Synchronizing Replicas 10.4.5 Using the Database Splitter 10.5 Implementing Database Security 10.5.1 Setting a Database Password 10.5.2 Encrypting and Decrypting a Database 10.5.3 Assigning Permissions to a Database Chapter Summary Command Summary Key Terms Chapter Quiz Short Answer True/False Multiple Choice Hands-On Exercises 1. AmeriSales International: Exchanging Data with Word and Excel 2. Iway Internet Group: Creating and Executing a Macro From a Form 3. Western Lumber Sales: Creating a Switchboard Menu 4. Spring County Carnival: Analyzing a Table 5. On Your Own: Benson's Office Supplies 6. On Your Own: Coldstream Valley Resorts Case Problems: Brownstone Consulting, Inc. APPENDIX: INTRODUCING VISUAL BASIC FOR APPLICATIONS
A.1 Introducing the VBA Environment A.1.1 Working in the Visual Basic Editor A.1.2 Examining the Standard Toolbar A.1.3 Examining the Project Explorer Window A.1.4 Examining the Properties Window A.1.5 Examining the Code Window A.1.6 Debugging Your Procedure Code A.2 Understanding the VBA Language A.2.1 Defining Modules and Procedures A.2.2 Documenting Your Code A.2.3 Understanding Objects A.2.4 Using Properties and Methods A.2.5 Declaring Variables A.2.6 Declaring Constants A.3 Controlling Your Procedures A.3.1 Making Decisions with IF...THEN A.3.2 Making Decisions with SELECT CASE A.3.3 Looping with FOR...NEXT A.3.4 Looping with DO...WHILE A.4 Hands-On Examples A.4.1 Creating a Module in the Database Window A.4.2 Writing and Running Procedures A.4.3 Distributing a Database as an MDE File Appendix Summary Command Summary Key Terms |