This course introduces you to application development using Microsoft Access 2002/2003. You'll learn the tools you need to create a simple Microsoft Access application including tables, queries, forms, reports, and just enough VBA code to get you started. By the end of Level 1, you'll learn how to put an application together, including how to create menus and how to launch your application from a startup form.
MS Access Training Prerequisites
Familiarity with a PC environment
MS Access Training Audience
Computer users needing to work in Microsoft Access 2002/2003.
MS Access Training Course Duration
2 Days
MS Access Training Course outline
Creating Tables and Relationships
- A Few Words about Database Design
- Creating Tables
- Creating Tables Using Design View
- Creating Relationships
- Importing from and Linking to External Data
Creating Queries
- Query Basics Creating Query Criteria
- Fine-Tuning Your Queries
- Multi-Table Queries and Joins
Getting Started with Forms
- Why Use Forms?
- Getting Started
- Creating a Bound Form
- Working with Properties
- Working with Other Control Types
- Creating an Unbound Form
- Managing Your Form's Interface
Displaying Data with Reports
- Comparing Forms and Reports
- Creating a Basic Report
- Introducing the Sorting and Grouping Window
- Performing Calculations on Reports
- Making Sections Behave
- Text Box Properties
- Performing More Complex Calculations
- Print Setup/Output
Building a Simple Application
- Putting Together an Access Application
- Using Hyperlinks in Access Applications
- Using the Command Button Wizard
- Creating Custom Menus, Shortcut Menus, and Toolbars
- Creating a Startup Form
Appendix A - The Reddick VBA Naming Conventions, Version 6.0
Appendix B - Useful VBA Functions