Follow Us :

Access 2003 Level 3

Course_Reference: 
DAC03L3
Manufacturer: 
0
Training_Provider: 
9
Summary: 

Your training in and use of Microsoft ® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft ® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

PreRequisites: 

  • Microsoft ® Office Access 2003: Level 1
  • Microsoft ® Office Access 2003: Level 2

Audience: 

This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft ® Office Access 2003 database program.

Objectives: 

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

  • restructure an existing set of data to improve the design of a database.
  • use a variety of techniques to summarize and present data with queries.
  • create and revise basic Access macros.
  • create macros that improve data entry efficiency and integrity.
  • improve the effectiveness of data entry in forms.
  • improve the effectiveness of data displayed in reports.
  • maintain an Access database by using various utility tools.

Structuring Existing Data

  • Import Data
  • Analyse Tables
  • Create a Junction Table
  • Improve Table Structure

Simplifying Tasks with Macros

  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition

Adding Interaction and Automation with Macros

  • Require Data Entry with a Macro
  • Display a Message Box with a Macro
  • Automate Data Entry

Making Forms More Effective

  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages

Writing Advanced Queries

  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form

Making Reports More Effective

  • Cancel Printing of a Blank Report
  • Include a Chart in a Report
  • Arrange Data in Columns
  • Create a Report Snapshot

Maintaining an Access Database

  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyse the Performance of a Database

Description: 

Your training in and use of Microsoft ® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft ® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Keywords: 
Access 2003,Microsoft Access,advanced capabilities,advanced operations,specialize capabilities

Software Vendor

IT Technical

Business Skills