Microsoft Access 2003

Complete Computing Inc.
Little Rock, Arkansas, 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.

Upon successful completion of this course, students will be able to:

examine the Microsoft® Office Access 2003 database application.
manage the data in a database.
examine existing table relationships.
query the database.
design simple forms.
create and modify Access reports.
Prerequisites: To ensure the successful completion of Microsoft Access 2003: Level 1, we recommend completion of one of the following Element K courses, or equivalent knowledge from another source:

Windows 2000: Introduction
Windows XP: Introduction
Windows XP: Level 1
Windows XP: Level 2
Certification
This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.


Course Content


Lesson 1: An Overview of Access 2003

Topic 1A: Relational Databases

Topic 1B: The Access Environment

Topic 1C: The Database Environment

Topic 1D: Examine an Access Table



Lesson 2: Managing Data

Topic 2A: Examine an Access Form

Topic 2B: Add and Delete Records

Topic 2C: Sort Records

Topic 2D: Display Record Sets

Topic 2E: Update Records

Topic 2F: Run a Report



Lesson 3: Establishing Table Relationships

Topic 3A: Identify Table Relationships

Topic 3B: Identify Primary and Foreign Keys in the Relationships Window

Topic 3C: Working with Subdatasheets



Lesson 4: Querying the Database

Topic 4A: The Select Query

Topic 4B: Add Criteria to a Query

Topic 4C: Add a Calculated Field to a Query

Topic 4D: Perform a Calculation on a Record Grouping



Lesson 5: Designing Forms

Topic 5A: Form Design Guidelines

Topic 5B: Create AutoForms

Topic 5C: Create a Form Using the Form Wizard

Topic 5D: Modify the Design of a Form



Lesson 6: Producing Reports

Topic 6A: Create an AutoReport

Topic 6B: Create a Report by Using the Wizard

Topic 6C: Examine a Report in Design View

Topic 6D: Add a Calculated Field to a Report

Topic 6E: Modify the Format Properties of a Control

Topic 6F: AutoFormat a Report

Topic 6G: Adjust the Width of a Report
...''

Phone:(800) 880-2949

School Address:

Complete Computing, Inc.
400 West 7th Street
Little Rock, AR USA 72201

Jobs & Resumes: Little Rock
Houses & Roommates: Little Rock

Adobe Acrobat 7.0 Combo
Adobe Acrobat 7.0 Lev 1
Adobe Acrobat 7.0 Lev 2
Adobe Illustrator CS
Adobe InDesign CS
Adobe PageMaker 7.0 Lev 1
Adobe PageMaker 7.0 Lev 2
PhotoShop CS
Access 2003 VBA
Microsoft Excel 2007
Excel 2003
Outlook 2003
PowerPoint 2003
Microsoft Word 2003
CorelDraw 11: Lev 1
CorelDraw 11: Lev 2
Crystal Reports XI
Crystal Reports 10

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: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.