Access 2003

ICI Systems, Inc.
Washington, District of Columbia, 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 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 by using the Microsoft® Office Access 2003 relational database application and its information management tools.

Course Outline

Module 1: An Overview of Access 2003
Lessons

--------------------------------------------------------------------------------

Understand Relational Databases
Examine the Access Environment
Open the Database Environment
Examine an Access Table

Module 2: Managing Data
Lessons

--------------------------------------------------------------------------------

Examine an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Run a Report

Module 3: Establishing Table Relationships
Lessons

--------------------------------------------------------------------------------

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets

Module 4: Querying the Database
Lessons

--------------------------------------------------------------------------------

Create a Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Module 5: Designing Forms
Lessons

--------------------------------------------------------------------------------

Examine Form Design Guidelines
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Modify the Design of a Form

Module 6: Producing Reports
Lessons

--------------------------------------------------------------------------------

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
...''

Phone:202 887 0510

School Address:

ICI Systems, Inc.
1150 17th Street, NW, Suite 100
Washington, DC 20036


Jobs & Resumes: Washington
Houses & Roommates: Washington

Microsoft Exchange Server 2007
Sharepoint Portal Server 2003: Administration & Configuration
Sharepoint Services 2003: Administration & Configuration
Windows XP
Windows Vista
Windows Vista Application and Tools
MCSAs and MCSEs to Windows Server 2003
Microsoft Systems Management Server 2003
Tuning and Optimizing Queries using Microsoft SQL Server 2005
Implementing Microsoft Office SharePoint Server 2007
Excel 2003
Outlook 2003
PowerPoint 2003
Project 2003
E-Commerce Profitability: Online Merchandising Using Office FrontPage 2003
IIS 6.0
BizTalk Server 2004
XML and SLT
Programming with C#

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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.