Click here if your browser does not automatically forward.
|Course||Access 2003: Intro[LS000549/CR/01]|
|Prerequisites||Participants enrolling in this course should understand the basic concepts involved in working with a personal computer. Participants should also be somewhat familiar with databases and how they are utilized.|
|Requal. Interval||One Time Only|
|Target Audience||People wishing to learn the basics of Access 2003|
|Objective||Participants will design and create databases, tables, queries, forms, and reports. This one day course contributes toward the Microsoft Proficiency Guidelines for Access 2003.
* Working with a Relational Database
* Database Terminology
* Create a New Database Based on a Template
* Planning a Database
* Examine an Access Form
* Building the Basic Structure
* Identify Table Relationships
* Creating and working with Select Queries
* Create Auto Forms and use the Form Wizard
* Creating and using Reports
|Course Content||Learn Microsoft's database management system, starting with a primer of database theory. Explore Access's objects such as tables, forms, reports, and queries. Learn how to create a table, and how to modify your tables already made. Learn to find and edit specific pieces of information from your tables. Next is what to consider when making tables - we'll explore data validation principles Learn queries, how to develop, use, and print them. Explore form creation. Customize how your forms will look and function. Next, we create custom reports to detail your data. Create a query and a form using a Wizard. Report modification is covered to format your data the way you want it. Create an AutoReport and a Report using a Wizard.
|Instructor's Comments||If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.|