Access 2007

Computer Training Center - South Bend
South Bend, Indiana, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Overview: In this course, students will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access 2007 relational database application.

Topics covered include:
Lesson 1: Exploring the Access Environment

Topic 1A: Examine Database Concepts

Topic 1B: Explore the User Interface

Topic 1C: Explore the Ribbon

Topic 1D: Customize the Access Environment

Topic 1E: Obtain Help

Topic 1F: Use an Existing Access Database

Lesson 2: Designing a Database

Topic 2A: Describe the Relational Database Design Process

Topic 2B: Define Database Purpose

Topic 2C: Review Existing Data

Topic 2D: Determine Fields

Topic 2E: Group Fields into Tables

Topic 2F: Normalize Data

Topic 2G: Designate Primary and Foreign Keys

Topic 2H: Determine Table Relationships

Lesson 3: Building a Database

Topic 3A: Create a New Database

Topic 3B: Create a Table

Topic 3C: Manage Tables

Topic 3D: Create a Table Relationship

Lesson 4: Managing Data in a Table

Topic 4A: Modify Table Data

Topic 4B: Sort Records

Topic 4C: Work with Subdatasheets

Lesson 5: Querying a Database

Topic 5A: Filter Records

Topic 5B: Create a Query

Topic 5C: Add Criteria to a Query

Topic 5D: Add a Calculated Field to a Query

Topic 5E: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

Topic 6A: View Data Using an Access Form

Topic 6B: Create a Form

Topic 6C: Create a Form Using the Form Wizard

Topic 6D: Modify the Design of a Form

Lesson 7: Generating Reports

Topic 7A: View an Access Report

Topic 7B: Create a Report

Topic 7C: Create a Report Using the Report Wizard

Topic 7D: Add a Custom Calculated Field to a Report

Topic 7E: Format the Controls in a Report

Topic 7F: Apply an AutoFormat to a Report

Topic 7G: Prepare a Report for Print

Prerequisites: The student does not need to have database experience. However, a good understanding of Windows is required.

...''

Phone:574.287.1053

School Address:

St. Joseph: 2364 S. Cleveland Ave | St Joseph, MI 49085 | 269.983.3903

South Bend: 2750 Foundation Drive| South Bend, IN 46628 | 574.287.1053


Jobs & Resumes: South Bend
Houses & Roommates: South Bend

Microsoft Outlook 2003 - Level II
GroupWise 6.0
Acrobat 7.0
InDesign CS - Level I
InDesign CS - Level II
PageMaker 7.0
Microsoft Publisher 2003
QuarkXPress 6
Lotus Approach ME 9.5
Lotus Notes 6.0 - Database Features
Oracle 10g - Introduction
Relational Database
SQL Fundamentals
Oracle 9i
Oracle 8i - SQL, PL/SQL, and SQL*Plus
Illustrator CS
PageMill 3.0
Photoshop CS
CorelDRAW

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.