Microsoft Access 2003
by Dave Mercer
Start the free chapterMicrosoft 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.
Course content
Introduction9 lessons
Using Access 2003 Databases13 lessons
- Opening a Database/Creating Shortcuts4:011 credit or ad
- Setting a Simple Password3:231 credit or ad
- Compacting/Repairing a Database2:281 credit or ad
- Converting a Database6:411 credit or ad
- Using the Documentation Feature pt. 14:171 credit or ad
- Using the Documentation Feature pt. 24:171 credit or ad
- Opening a Form View1:591 credit or ad
- Searching Fields in a Form3:111 credit or ad
- Navigating Records in a Form2:581 credit or ad
- Sorting Records in a Form1:411 credit or ad
- Filtering Records in a Form3:351 credit or ad
- Data Entry Tips and Tricks6:501 credit or ad
- Printing Forms and Reports2:051 credit or ad
Creating Database Objects - Tables11 lessons
- Creating Tables2:131 credit or ad
- Fields/Names/Indexes3:051 credit or ad
- Data Types4:491 credit or ad
- Primary Keys2:471 credit or ad
- Field Validation (Required)6:031 credit or ad
- Field Validation (Rules)4:141 credit or ad
- Lookup Fields4:031 credit or ad
- Setting Default Values2:041 credit or ad
- Using Input Masks pt. 16:171 credit or ad
- Using Input Masks pt. 23:131 credit or ad
- Making Captions1:151 credit or ad
Creating Database Objects - Forms11 lessons
- What is a Form?2:111 credit or ad
- Using the Form Wizard5:011 credit or ad
- Creating a Form Manually5:351 credit or ad
- Using the Toolbox/Adding Controls4:161 credit or ad
- Sizing and Aligning Controls5:181 credit or ad
- Form Properties/Caption/Default View5:531 credit or ad
- Form Field Properties2:361 credit or ad
- Tabbing/Tab Order/Tab Stops4:241 credit or ad
- Form Field Cosmetic Properties4:271 credit or ad
- Adding a Text Field2:571 credit or ad
- Formatting Field Values2:471 credit or ad
Creating Database Objects - Queries10 lessons
- What is a Query?2:551 credit or ad
- Creating a Query in Design View6:001 credit or ad
- Using the Query Wizard2:171 credit or ad
- Moving Fields in a Query4:201 credit or ad
- Sorting Query Results4:211 credit or ad
- Setting Search Criteria in a Query3:431 credit or ad
- Using Operators and Wildcard Characters5:211 credit or ad
- Searching for a Range of Values3:031 credit or ad
- Using AND/OR/NOT in a Query2:091 credit or ad
- Creating Parameter Queries2:561 credit or ad
Creating Database Objects - Reports9 lessons
- What is a Report?2:401 credit or ad
- Using the Report Wizard7:161 credit or ad
- Creating a Report Manually2:411 credit or ad
- Adding Fields to a Report4:411 credit or ad
- Using Report and Page Sections5:111 credit or ad
- Setting Page Breaks and Margins3:441 credit or ad
- Adding Lines and Boxes4:261 credit or ad
- Adding Images to a Report3:001 credit or ad
- Setting Field Properties3:521 credit or ad
Using the Properties Window6 lessons
Using the Expression Builder7 lessons
- Opening the Expression Builder Tool4:331 credit or ad
- What are Expressions?3:471 credit or ad
- Expression Builder Parts3:531 credit or ad
- Using String Operators5:421 credit or ad
- Using Values in Other Forms4:271 credit or ad
- Using SQL Aggregate Functions8:071 credit or ad
- Using the IIf Function4:451 credit or ad
Relational Databases8 lessons
- What is a Relational Database?3:101 credit or ad
- Primary and Foreign Keys5:441 credit or ad
- The Relationships Window2:561 credit or ad
- Creating Relationships Between Tables5:301 credit or ad
- Editing Relationships4:301 credit or ad
- Resetting the AutoNumber Field5:301 credit or ad
- Fixing Data For Relationships5:401 credit or ad
- Setting Relationships in a Query3:441 credit or ad
Advanced Forms Design10 lessons
- Creating a Switchboard Form4:341 credit or ad
- Using the Switchboard Manager5:331 credit or ad
- Creating Admin Tables/Forms5:501 credit or ad
- Adding a Combo Box5:161 credit or ad
- Setting Combo Box Properties Manually6:561 credit or ad
- Setting Control Default Properties4:531 credit or ad
- Adding a Subform with the Wizard5:501 credit or ad
- Adding a Subform Manually4:101 credit or ad
- Creating Calculated Fields pt. 12:381 credit or ad
- Creating Calculated Fields pt. 26:361 credit or ad
Advanced Queries7 lessons
- Using SQL View6:101 credit or ad
- Creating Relational Queries4:511 credit or ad
- Grouping in Queries (Aggregates)5:271 credit or ad
- Creating Update Queries6:331 credit or ad
- Creating Delete Queries3:251 credit or ad
- Using Null Values in a Query5:011 credit or ad
- Creating Additional/Calculated Fields5:541 credit or ad
Advanced Reports7 lessons
- Connecting Reports to Queries5:541 credit or ad
- The Sorting and Grouping Window7:031 credit or ad
- Cleaning up the Report pt. 14:151 credit or ad
- Cleaning up the Report pt. 23:501 credit or ad
- Using Counts and Sums by Group5:051 credit or ad
- Advanced Report Formatting4:391 credit or ad
- Using the Labels Wizard8:521 credit or ad