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.
Objectives:
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
Topics:
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.