Creating Queries & Forms with Access 2002

Training Provided by Teach Me IT The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course guides users in efficient presentation of data using PivotTables and PivotCharts. After completing this course, the user will be able to:

Create simple queries
Perform calculations in queries
Specify selection criteria
Create special purpose and action queries
Create SQL specific queries
Identify the components of a form design window
Create a form and add data controls, Object Frame, and Picture controls to it
Create and customize PivotTables and PivotCharts
Adjust the appearance of a form and its controls
Assign form and control properties
Create a subform
Validate data in forms

Creating Queries & Forms with Access 2002

Other Courses in the Curriculum  Getting Started with Access 2002  Creating Reports, Charts, & Macros with Access 2002 Course Name Creating Queries & Forms with Access 2002 Audience All System Administrators, Help Desk/Support personnel, and Application Developers who implement a database solution using Microsoft Access 2002 database management system.  Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.   Pre-requisites Before taking this course, the user should be familiar with MS Office 98/2000 suite and proficient in using Windows 2000 Professional or Windows ME operating systems. Additionally, the user should be able to create and design databases and tables, and query tables.  Course Duration 5.3  hours Course Objectives The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course guides users in efficient presentation of data using PivotTables and PivotCharts. After completing this course, the user will be able to: Create simple queries Perform calculations in queries Specify selection criteria Create special purpose and action queries Create SQL specific queries Identify the components of a form design window Create a form and add data controls, Object Frame, and Picture controls to it Create and customize PivotTables and PivotCharts Adjust the appearance of a form and its controls Assign form and control properties Create a subform Validate data in forms   Course Outline Creating Simple and Advanced Queries Creating Simple Queries Customizing Simple Queries Creating Advanced Queries Quiz Creating Forms Designing Forms Adding Controls to a Form Creating PivotTables and PivotCharts Quiz Customizing Forms & Validating Data Customizing Forms and Controls Creating Subforms & Validating Data Quiz

About The Training Provider: Teach Me IT

More Office XP: Access 2002 Training from Teach Me IT

• Creating Reports, Charts, & Macros with Access 2002
• Getting Started with Access 2002