ECDL/ICDL: Databases v 4.0

ExecuTrain
Alpharetta, Georgia, 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. This training, which has been approved by the ECDL Foundation, includes exercise items intended to assist ECDL Candidates in their training for ECDL. These exercises are not ECDL certification tests. For information about authorized ECDL Test Centers in different national territories, please refer to the ECDL Foundation website at www.ecdl.com

Objectives:
In this course, you will be introduced to the features of the Access 2003 application.
Hardware and Software Required:
Browser Firefox 1.x
Browser Other: Safari 1.x
Browser Microsoft Internet Explorer 6.0
Operating SYSTEM MacOS X 10.3.x
Operating SYSTEM MS-Windows XP, 2000, OR 2003 server
Flash Player 8
Pentium III WITH 500 MHz
128MB RAM
256K connection (broadband recommended)

Table of Contents:

Course Introduction

Course Introduction

Using the Access Application

Lesson Introduction

Understand Database Concepts

Identify Primary and Foreign Keys

Examine the Access Environment

Open the Database Environment

Create a New Database

Get Help Using Access

Lesson Follow Up

Working with Tables

Lesson Introduction

Examine an Access Table

Create a Table

Add a Field to a Table

Add, Modify, and Delete Records

Delete a Table

Sort Records

Modify Table Design

Change the Layout of a Table

Create Relationships Between Tables

Delete Relationships Between Tables

Lesson Follow Up

Working with Forms

Lesson Introduction

Examine an Access Form

Create a Form Using AutoForm

Create a Form Using the Form Wizard

Add, Modify, and Delete Records Using a Form

Add and Modify Headers and Footers in a Form

Lesson Follow Up

Retrieving Information

Lesson Introduction

Retrieve Data Using the Find Command

Retrieve Data Using Filters

Create a Select Query

Add Criteria to a Query

Modify a Query in Design View

Lesson Follow Up

Working with Reports

Lesson Introduction

Create a Report Based on a Table

Create a Report Based on a Query

Modify the Design of a Report

Lesson Follow Up

Preparing Outputs

Lesson Introduction

Preview and Print a Table

Preview and Print a Form

Preview and Print a Query

Preview and Print a Report

Lesson Follow Up

Course Follow Up

Course Follow Up


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Paradox 10
Quattro Pro 12: Creating Charts and Databases
Quicken 2001
Relational Database
SAP R/3 V4.0: User Basics
Security Awareness
StarOffice 5.1
PC Maintenance and Troubleshooting
WordPerfect 12
ECDL/ICDL: Concepts of Information Technology (IT) v 4.0
ECDL/ICDL: Information and Communication v 4.0
ECDL/ICDL: Presentations v 4.0
ECDL/ICDL: Spreadsheets v 4.0
ECDL/ICDL: Word Processing v 4.0
ASP.NET: Using Visual C#, ADO.NET, and XML
ASP.NET: Using VisualBasic.NET, ADO.NET, and XML
Configuring and Managing Microsoft® Exchange Server 2003
Configuring and Managing Project Server 2003
TCP/IP

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.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!