Training Course:Access 2003School/Trainer:KnowledgeAir
Buffalo, New York, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.
--------------------------------------------------------------------------------
Course Outline
--------------------------------------------------------------------------------
Lesson 1: An Overview of Access 2003
Relational Databases
The Access Environment
The Database Environment
Examine an Access Table
Lesson 2: Managing Data
Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report
Lesson 3: Establishing Table Relationships
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets
Lesson 4: Querying the Database
The Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
Form Design Guidelines
Create AutoForms
Create a Form Using the Form Wizard
Modify the Design of a Form
Lesson 6: Producing Reports
Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report Adjust the Width of a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report
...''
Please go to the school's official website for training price and schedule:
http://knowledgeair.com/
Phone:866-322-3685
School Address:
KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210
KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618
Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo
Search other schools for Access 2003 training resources.
Other training courses offered by KnowledgeAir:
Business Writing
E-mail Etiquette
Negotiating
Time Management
Personal Workflow System
Personal Branding
Personal Scorecard Workshop
The Habit Creature
Crystal Reports 11
Excel 2003
Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
