Provides an overview of the Access 2003 Interface, toolbars and menus. It also covers how to open, close, save, backup, and request help.

  TOPICS COVERED

Opening an existing database
Using the database window
Modifying and reporting results
Saving, closing and backing up the database
Understanding the interface
Using the toolbar and menus
Accessing help

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.

  TOPICS COVERED

Understanding database terminology
Working with fields
Differentiating flat files and relational databases
Building a database
Creating tables
Organizing with a primary key
Building table relationships
Creating an index
Opening databases and tables
Adding, modifying, and deleting records

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.

  TOPICS COVERED

Formatting tables
Using input masks
Creating validations
Navigating the datasheet
Modifying columns and rows
Organizing columns and rows
Changing fonts and the look of the datasheet
Adding and removing table fields
Changing field names

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.

  TOPICS COVERED

Using the find command
Sorting the database
Filtering records
Defining queries
Building a simple query
Using the select query
Using the simple query wizard
Setting up multiple-table queries
Using the wizard for multiple-table queries
Building a multiple-table query by hand

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.

  TOPICS COVERED

Using the AND operator
Using the OR operator
Defining the total row
Using total row options
Developing simple calculations
Performing complex calculations
Using the expression builder
Replacing data
Deleting data
Updating data

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.

  TOPICS COVERED

Using AutoReport
Viewing the report in print preview mode
Customizing the report with page layout
Printing labels with the label wizard
Adding charts with the chart wizard
Using the report wizard
Moving to design view
Working with the formatting toolbar
Viewing and modifying the report
Organizing reports with headers and footers
Grouping records
Fine-tuning the report layout
Controlling headers and footers

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.

  TOPICS COVERED

Building hyperlinks
Publishing data on the internet
Defining forms
Building forms using the form wizard
Building forms using the AutoForm wizard
Enhancing forms
Importing and exporting data
Using the table analyzer
Ten tips for maximizing a database

only £50.00
(approx $88 USD)