Access 2003
The Access 2003 series of courses starts off with an overview of both database concepts in general and Access in particular. Learners then find out how to design, build, and use Access tables. Further topics include using queries, find, filter, and sort to unearth answers from data. Learners finally move on to the Access report system and delve into wizards, timesaving tips, and even a bit of programming.
This series is for anyone who wants to get the most out of using Access 2003. This online course contains 7 lessons and should take approximately 22 hours to complete.
Introduction to Access
This course provides an overview of the Access 2003 Interface, toolbars and menus It also covers how to open, close, save, backup, and request help and teaches you how to start Access, open an existing database, modify reporting results, save, close and back up a database, use the toolbar and menus, and use Access help.
Designing and Building Tables
This course shows learners how to use Access 2003 to design and build tables and an index It also covers working with fields, primary keys, and records and teaches you how to build a simple database, create and open a table, set up a primary key, build relationships between tables, create an index, and add, modify and delete records.
Enhanced Tables and Datasheets
This course shows learners how to use Access 2003 to format tables and use masks and validations It also covers working with columns and rows, changing fonts, using table fields and field names and teaches you how to format a table, use masks and validations, work with columns and rows, change fonts on the datasheet, add and remove table fields, and change field names.
Searches and Queries
This course shows learners how to use Access 2003 to build simple, select and multiple-table queries using wizards or by hand It also covers filtering records and teaches you how to sort and filter records in a database, build a simple query, use the select query and select query wizard, set up multiple-table queries, and build a multiple-table query by hand.
Advanced Queries and Calculations
This course shows learners how to use Access 2003 to construct calculations and use Boolean operators (AND/OR) to build advanced queries It also covers how to use the Total Row and Expression Builder, and to modify data and teaches you how to use Boolean operators in queries, create advanced queries and calculations, and replace, delete, and update data.
Access Report System
This course shows learners how to use Access 2003 to view, organize, and customize reports It also covers the use of AutoReport, and the Label, Chart, and Report wizards and teaches you how to use AutoReport, print reports and labels, use the report wizard, and modify the report printing features.
The Internet, Forms, and the Analyzer
This course shows learners how to use Access 2003 to build hyperlinks and publish data to the Web It also covers building forms, importing and exporting data, and using database analysis tools and teaches you how to build and use hyperlinks, publish Access data to the Web, build a form with the Form Wizard, build a form with the AutoForm Wizard, import and export Access data, and use the Table Analyzer.