We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Microsoft Access 2003 now makes it easier for anyone to use, or create powerful database solutions to help organize, access, and share data, in no time. Virtual Training Company author, Dave Mercer, guides users through the Access 2003 set of powerful tools that are easy enough to learn for beginners, but sophisticated enough for the most complex developers. Mercer first covers the basics of using Access 2003, including navigating within the interface and relational database development and design principles. He then moves on to object design construction (tables, queries, forms, and reports) and more advanced features that developers can enjoy. To begin learning today, simply click on a link below.
Opening a Database/Creating Shortcuts
Compacting/Repairing a Database
Using the Documentation Feature pt. 1
Using the Documentation Feature pt. 2
Using the Toolbox/Adding Controls
Form Properties/Caption/Default View
Form Field Cosmetic Properties
Creating a Query in Design View
Setting Search Criteria in a Query
Using Operators and Wildcard Characters
Searching for a Range of Values
What is a Relational Database?
Creating Relationships Between Tables
Resetting the AutoNumber Field
Setting Relationships in a Query
Setting Combo Box Properties Manually
Setting Control Default Properties
Adding a Subform with the Wizard
Creating Calculated Fields pt. 1
Creating Calculated Fields pt. 2
Grouping in Queries (Aggregates)
Creating Additional/Calculated Fields
The Sorting and Grouping Window
Using Counts and Sums by Group
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.