Access 2007

CED Solutions - Calgary
Calgary, Alberta, Canada

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

Course Description:

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

design a simple database.
build a new database with related tables.
manage the data in a table.
query a database using different methods.
design forms
generate reports.
Course Content
Lesson 1: Exploring the Access Environment
Examine Database Concepts
Customize the Access Environment
Use an Existing Access Database
Lesson 2: Designing a Database
Describe the Relational Database Design Process
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
Lesson 3: Building a Database
Create a New Database
Create and Manage a Table
Create a Table Relationship
Lesson 4: Managing Data in a Table
Modify Table Data
Sort Records
Work with Subdatasheets
Lesson 5: Querying a Database
Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
View Data Using an Access Form
Create a Form and Using the Form Wizard
Modify the Design of a Form
Lesson 7: Generating Reports
Create a Report Using the Report Wizard
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat to a Report
Prepare a Report for Print
...''

Phone:(800) 611-1840

School Address:

Suite 107 Burns Building
237 - 8 Avenue SE
Calgary AB T2G 5C3
Canada

Jobs & Resumes: Calgary
Houses & Roommates: Calgary

CIW Associate Boot Camp
CIW Master Site Designer Boot Camp
CIW Master Web Site Manager Boot Camp
CIW Professional Site Designer Boot Camp
CompTIA A+
CompTIA Network+ Certification Boot Camp
CompTIA Project+ Certification Boot Camp
CompTIA Security+ Certification Boot Camp
Microsoft Project
CompTIA Project+
ACT! 2005
MCDBA Windows 2003 Certification Boot Camp
MCITP: Business Intelligence Developer Certification Boot Camp
MCITP: SQL 2005 Database Administrator Boot Camp
MCITP: SQL 2005 Database Developer Boot Camp
MCTS: SQL Server 2005 Boot Camp
SQL Fundamentals
Visual Basic 6.0
Adobe Acrobat 7.0

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.