Microsoft® Access 2010: A Case Approach, Complete

Tim O'Leary has taught courses at Stark Technical College in Canton, Ohio, and at Rochester Institute of Technology in upstate New York. He currently is a professor emeritus at Arizona State University. Linda O'Leary offered her expertise at Arizona State University for several years as an academic advisor. She also presented and developed materials for major corporations, such as Motorola, Intel, Honeywell, and AT&T, as well as various community colleges in the Phoenix area.

Access 2010 Complete
Lab 1 Creating a Database
Designing a New Database
Creating a New Database
Creating a Table
Modifying Field Properties
Entering and Editing Records
Changing Column Width
Navigating Among Records
Deleting Records
Creating a Table in Design View
Creating Relationships
Setting Database and Object Properties
Previewing and Printing a Table
Closing and Opening a Database
Exiting Access
Lab 2 Modifying and Filtering a Table and Creating a Form Customising Fields
Hiding and Redisplaying Fields
Creating a Lookup Field
Searching, Finding and Replacing Data
Sorting Records
Formatting the Datasheet
Filtering a Table
Creating a Simple Form
Modifying a Form
Using a Form
Organising the Navigation Pane
Previewing and Printing a Form
Identiying Object Dependencies
Lab 3 Querying Tables and Creating Reports
Refining the Database Design
Defining and Modifying Relationships
Creating a Query
Displaying a Totals Row
Creating Reports
Preparing Reports for Printing
Compacting and Backing Up the Database
Working Together 1 Exporting Data
Exporting Data
Lab 4 Importing and Querying Tables
Importing Data
Controlling Field Input
Using Action Queries
Using Memo Fields
Adding a Multivalued Field
Using Calculations in Tables and Queries
Creating a Top-Values Query
Creating a Crosstab Query
Lab 5 Creating Custom Forms
Creating a Split Form
Creating a Datasheet Form and Subform
Creating a Form for Multiple Tables
Changing Control Properties
Adding Label Controls
Enhancing Form Controls
Aligning and Spacing Controls
Adding Subforms
Setting Tab Order
Using Command Buttons
Creating Page Headers and Footers
Previewing a Form
Deleting a Form
Lab 6 Creating Custom Reports, Charts, Pivot Charts and Mailing Lables
Creating a Grouped Report
Using the Report Wizard to Create a Grouped Report
Customising the Report Layout
Enhancing the Report
Changing the Record Source
Using Calculated Controls in a Report
Applying Conditional Formatting
Printing a Grouped Report
Creating a Chart in a Report
Using Pivot Chart View
Creating Mailing Labels
Creating a Startup Display Form
Securing a Database
Working Together 2: Linking and Splitting Databases
Linking to External Data Sources
Splitting a Database