KT-9207 Microsoft Access 2003 Level 2 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Microsoft Access 2003 Level 2


Description: 

As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2000, Access XP or Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

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

  • follow the steps required to properly design a simple database.
  • create a new database with related tables.
  • control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
  • find and retrieve desired data by using filters and joins between tables and within a single table.
  • create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
  • enhance the appearance, data entry, and data access capabilities of your forms.
  • customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
  • use Access data in other applications, including Microsoft Word and Excel.

Course Objective: You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Target Student: Microsoft® Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Certification: This course is one of a series of Knowledge Transfer courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsofts business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification. To learn more about the Microsoft Office Specialist Program visit our certifications section.

 
Click here to view the Course Outline
     
Prerequisite: 
 
   
     
Duration: 
1 Day  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

PLEASE CONTACT US TO REQUEST A CLASS DATE.