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.
- Start Access
- Open an existing database
- Modify reporting results
- Save, close and back up a database
- Use the toolbar and menus
- Use Access help
Time : 2.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- Build a simple database
- Create and open a table
- Set up a primary key
- Build relationships between tables
- Create an index
- Add, modify and delete records
Time : 3.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- Format a table
- Use masks and validations
- Work with columns and rows
- Change fonts on the datasheet
- Add and remove table fields
- Change field names
Time : 3.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- Sort and filter records in a database
- Build a simple query
- Use the select query and select query wizard
- Set up multiple-table queries
- Build a multiple-table query by hand
Time : 3.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- Use Boolean operators in queries
- Create advanced queries and calculations
- Replace, delete, and update data
Time : 3.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- Use AutoReport
- Print reports and labels
- Use the report wizard
- Modify the report printing features
Time : 5.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
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.
- 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
- Use the Table Analyzer
Time : 3.0 hour(s)
This series is for anyone who wants to get the most out of using Access 2003.
