Microsoft Office Access 2003 Level 1
Product Code:PN-Office03AccessEKL1

List Price

Sale Price

Quantity
Call for Pricing
Product Options:
Microsoft Office Access 2003 Level 1
Package Includes:
  • 1 DVD-ROM or 2 CDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Exclusive LearningZone Live Mentor Click for Details  Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7)
  • Free 1 Year Upgrade Policy
OURexpertText
Erin Olsen

Erin Olsen - MCAS
Erin Olsen has been involved in the computer training industry for over 15 years. Erin has helped thousands of students worldwide receive quality computer training in a wide range of software titles and subject matter. Erin is a Microsoft Office Specialist Master Instructor and is MCAS certified. As a frequent Microsoft Office user as well as a trainer, Erin utilizes a practical approach in her instruction.

Course Features:
  • Main Menu
    Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
  • PowerPoint
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
  • Exclusive Learning Zone
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
  • Controls
    Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.

  • Full Motion Video
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
  • Study Guides
    Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
  • Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
  • Resume
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
  • Labs
    This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
  • Certificate of Completion
    Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Course Outline TXT
Course Introduction
Course Introduction
Lesson 1 - An Overview of Access 2003
An Overview of Access 2003
Understanding Relational Database
Relational Databases
Access Environment Componets
Access Objects
Naming Conventions
Table Datasheet View
Table Design View
Demo - Access Tour
Lesson 1 Review
Lesson 2 - Managing Data
Managing Data
Forms
Navigation in an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Demo - Navigation
Run a Report
Demo - Reports
Lesson 2 Review
Lesson 3 - Establishing Table Relationships
Establishing Table Relationships
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets
Example of a Subdatasheet
How to Find Data is Subdatasheets
Demo - Relationships
Lesson 3 Review
Lesson 4 - Querying the Database
Querying the Database
Create a Select Query
How to Create a Select Query
Demo - Query
Comeparison Operators
Conditional Operators
How to Add Selection Conditions to the Query
Arithmetic Operators
Access Expressions
The Expression Builder
How to Add a Calculated Field to the Query
Perform a Calculation on a Record Grouping
Demo - Conditions
Lesson 4 Review
Lesson 5 - Designing Forms
Designing Forms
AutoForms
The Form Wizard
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Demo - Create Forms
Demo - Edit Forms
Controls
Lesson 5 Review
Lesson 6 - Producing Reports
Producing Reports
AutoReport
How to Create an AutoReport
How to Create a Report with Wizard
Demo - Create Reports
Report Design View
How to Examine a Report Displayed in Design View
The Toolbox
How to Apply an AutoFormat Style to a Report
Lesson 6 Review
Course Closure

Search
 

Advanced Search


Cart
Your Cart Is Empty

Buy 2 Courses get and additional course free Free Training

Our reputation speaks for itself! See what others are saying... Testimonials

30-Day Money Back Satisfaction Guarantee

Computer Training

"Career Academy's Visual Studio.NET training videos are excellent. the extra information - web site references, tips, techniques, and other general historical information - really made the difference. The classroom like presentations are superb. I give this product a high endorsement. "

Roger Bundy
Chief Technology Officer,
Co-Founder
Southern California
.NET User Group
 www.SocalNETug.org