Tutorial: Microsoft Office Access 2003 in 24 hours

Please select a chapter from the "Contents" menu at the very bottom of the page.

Microsoft Office Access 2003 in 24 hours

Part I: Introduction to Relational Databases and Access 2003 Hour 1. Relational Databases and Office Access 2003 Introduced What Is a Relational Database? What Types of Things Can I Do with Microsoft Access? Starting Microsoft Access Opening an Existing Database The Access Desktop The Database Window A Preview of the Database Components Closing an Access Database Summary Q&A Workshop Part II: Working with Existing Databases and Objects Hour 2. Tables Introduced Viewing and Navigating Table Data Editing Table Data Adding Records to a Table Deleting Records Finding and Replacing Records Filtering Table Data Modifying the Appearance of a Datasheet Correcting Errors by Using Spell Check and AutoCorrect Summary Q&A Workshop Hour 3. Queries Introduced What Is a Query and When Should You Use One? Opening a Query in Datasheet View Opening a Query in Design View Running a Query Adding and Removing Fields Modifying the Sort Order of a Query Working with Simple Criteria Modifying the Datasheet View of a Query Saving a Query Printing Query Results Closing a Query Summary Q&A Workshop Hour 4. Forms Introduced Uses for Forms Opening a Form Working with Data in a Form Sorting Records Filtering the Data Underlying a Form Viewing the Design of a Form Closing a Form Using the AutoForm Feature Using the Form Wizard to Build a Form Using the Conditional Formatting Feature of a Form Summary Q&A Workshop Hour 5. Reports Introduced Opening and Viewing a Report Printing a Report The AutoReport Feature and the Report Wizard Viewing the Design of a Report Closing a Report Printing Database Objects Summary Q&A Workshop Part III: Creating Your Own Database and Objects Hour 6. Using Wizards to Create a Database Using a Database Template to Create a Database Creating a Database from Scratch Building a Table by Using a Wizard Building a Query by Using a Wizard Building a Form by Using a Wizard Building a Report by Using a Wizard Summary Q&A Workshop Hour 7. Designing Databases Task Analysis Data Analysis and Design Prototyping Testing Implementation Maintenance Summary Q&A Workshop Hour 8. Creating Tables Building a New Table Selecting the Appropriate Field Type for Data The All-Important Primary Key Summary Q&A Workshop Hour 9. Creating Relationships Introduction to Relational Database Design Establishing Relationships in Access Establishing Referential Integrity The Benefits of Relationships Summary Q&A Workshop Hour 10. Creating Queries Query Basics Ordering Query Results Refining a Query by Using Criteria Updating Query Results Building Queries Based on Multiple Tables Creating Calculated Fields Getting Help from the Expression Builder Summary Q&A Workshop Hour 11. Creating Forms Creating a Form in Design View Working with the Form Design Window Selecting the Correct Control for the Job Conditional Formatting What Form Properties Are Available, and Why Should You Use Them? Summary Q&A Workshop Hour 12. Creating Reports Types of Reports The Anatomy of a Report Creating a Report in Design View Working with the Report Design Window Selecting the Correct Control for the Job Report Properties and Why to Use Them Summary Q&A Workshop Hour 13. Creating Macros The Basics of Creating a Macro Running an Access Macro Modifying an Existing Macro Documenting a Macro: Adding Comments Testing a Macro When You Should Use Macros and When You Shouldn't Converting a Macro to VBA Code Creating an 'AutoExec' Macro Creating an 'AutoKeys' Macro Summary Q&A Workshop Part IV: Power Access Techniques Hour 14. Power Table Techniques Working with Field Properties Working with Table Properties Using Indexes to Improve Performance Summary Q&A Workshop Hour 15. Power Query Techniques Adding Calculated Fields to Select Queries Applying Advanced Filters Creating and Running Parameter Queries Creating and Running Action Queries Using Aggregate Functions to Summarize Numeric Data Working with Outer Joins Refining Queries with Field, Field List, and Query Properties Summary Q&A Workshop Hour 16. Power Form Techniques The Other Properties of a Form Control Properties and Why to Use Them Bound, Unbound, and Calculated Controls Using Expressions to Enhance Forms The Command Button Wizard: Programming Without Typing Building Forms Based on More Than One Table Basing Forms on Queries: The Why and How Summary Q&A Workshop Hour 17. Power Report Techniques Other Properties of a Report Control Properties and Why to Use Them Inserting Page Breaks Bound, Unbound, and Calculated Controls Using Expressions to Enhance Reports Building Reports Based on More Than One Table Working with Sorting and Grouping Basing Reports on Stored Queries or Embedded SQL Statements Summary Q&A Workshop Part V: Advanced Topics Hour 18. Sharing Data with Other Applications Importing, Linking, and Opening Files: When and Why Exporting to Another Access Database Exporting to an Excel Spreadsheet Exporting to ASCII Importing from Another Access Database Importing Spreadsheet Data Importing ASCII Data Linking to Tables in Another Access Database Linking to Another Type of Database The Linked Table Manager Summary Q&A Workshop Hour 19. Access and the Internet Saving Database Objects as HTML Linking to HTML Files Importing HTML Files Exporting Data to XML Importing XML Data into Access Creating and Modifying Data Access Pages Saving PivotTables and PivotCharts to Data Access Pages Summary Q&A Workshop Hour 20. Database Administration Backing Up a Database Compacting and Repairing a Database Encrypting and Decrypting a Database Converting a Database to Another Version Creating an MDE File Using the Database Splitter Summary Q&A Workshop Hour 21. Database Documentation Preparing an Application to Be Self-Documenting Using the Documenter The Object Dependencies Feature Summary Q&A Workshop Hour 22. Security Introduced Implementing Share-Level Security: Assigning a Database Password Establishing User-Level Security Summary Q&A Workshop Hour 23. VBA Introduced VBA Explained Access Class Modules, Standard Modules, Form Modules, and Report Modules Working with Variables Adding Comments to Code Using the Line Continuation Character Using the VBA Control Structures Passing Parameters and Returning Values The 'DoCmd' Object: Performing Macro Actions Working with Built-in Functions Summary Q&A Workshop Hour 24. Finishing Touches Adding Custom Menu Bars, Toolbars, and Shortcut Menus Creating an Application Switchboard Setting Startup Options Summary Q&A Workshop