INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
  Windows Essentials  
  SQL Server Administrator  
  Windows Server 2003  
   
  Office Power User  
  Office Specialist  
  MICROSOFT CERTIFICATION  
  MICROSOFT TRAINING & CERT.  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
Microsoft Office - Access 2003 (Full Package)

Access is a popular database management system which allows you to store, analyze and organize information. This course covers how to use an existing database, create a new database, search & find information, prepare & format reports, and use Access to keep information secure. The course will also introduce you to relational database concepts.

 
 

Course Schedule

Duration: 3 days.
To view the schedule for this class, click here.

Who should attend

This course is intended for all IT Professionals who want to learn the Access 2003 Database Management System.

Prerequisites

Basic Microsoft Windows skills

Course Outline

GETTING TO KNOW MICROSOFT ACCESS 2003
•  Understanding Databases
•  Opening an Existing Database
•  Exploring Tables, Queries, Forms, Reports, & Other Access Objects
•  Previewing and Printing Access Objects

CREATING A NEW DATABASE
•  Creating a Database Structure the Simple Way
•  Checking the Work of a Wizard
•  Creating Tables the Simple Way
•  Refining How Data Is Displayed
•  Manipulating Table Columns and Rows

GETTING INFORMATION INTO AND OUT OF A DATABASE
•  Importing Information from Excel, a Delimited Text File, a Fixed-Width Text File, an Access Database, Other Databases, an HTML File, and an XML File
•  Exporting Information to Other Programs
•  Linking a Database to Information in Another Database
•  Other Ways to Share Access Data

SIMPLIFYING DATA ENTRY WITH FORMS
•  Creating a Form by Using a Wizard
•  Refining Form Properties, & Form Layout
•  Adding Controls to a Form
•  Using Visual Basic for Applications to Enter Data in a Form
•  Creating a Form by Using an AutoForm
•  Adding a Subform to a Form

LOCATING SPECIFIC INFORMATION
•  Sorting Information
•  Filtering Information in a Table
•  Filtering by Form
•  Locating Information that Matches Multiple Criteria
•  Creating a Query in Design View and with a Wizard
•  Performing Calculations in a Query

KEEPING YOUR INFORMATION ACCURATE
•  Using Data Type Settings, Field Size Properties , Input Masks, Validation Rules, or Lookup Lists to Restrict Data
•  Updating & Deleting Information in a Table

WORKING WITH REPORTS
•  Creating a Report by Using a Wizard
•  Modifying a Report
•  Creating a Report from Scratch
•  Adding a Subreport to a Report
•  Previewing and Printing a Report

MAKING IT EASY FOR OTHERS TO USE YOUR DATABASE
•  Creating a Switchboard by Using Switchboard Manager
•  Creating a Splash Screen
•  Setting Startup Options
•  Keeping Your Application Healthy

KEEPING YOUR INFORMATION SECURE
•  Encrypting and Decrypting a Database
•  Assigning a Password to a Database
•  Sharing, Replicating, & Splitting a Database
•  Setting Up & Maintaining a Workgroup
•  Preventing Changes to a Database
•  Securing a Database for Distribution

WORKING WITH PAGES AND MODULES
•  Creating Static Web Pages
•  Exploring Visual Basic for Applications (VBA)
•  Using VBA to Create a Web Page
•  Creating a Data Access Page with AutoPage or Using the Page Wizard
•  Allowing Others to Analyze Data On the Web

 
 
 

 
 


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail: info@informit.tc

 
  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved