Access XP Proficient Expert

Training Provided by 123-CBT Computer Based Training DiscoverWare's a Discover Access XP a is an interactive productivity tool for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts such as planning, forms, and data management, to more advanced concepts including sorting, filtering, reporting, and operating Access on the Web.

Access XP / 2002 (Proficient)

Access XP Basics

• Database Basics
  - What Is A Database?
  - What Is Access XP?
  - Access XP Capabilities
  - Database Objects
  
• Planning Basics
  - Planning Basics
  
• Define Tables
  - What Is A Table?
  - Defining Tables
  
• Define Fields
  - What Is A Field?
  - Defining Fields
  - Identify Primary Keys
  
• Define Relationships
  - What Is A Relationship?
  - One-To-Many Relationships
  - Many-To-Many Relationships
  - One-To-One Relationships
  
• Review The Design
  - Refine The Design
  - Queries, Forms & Reports
  
• Screen Layout
  - The Access XP Window
  - The Database Window
  
• Help In Access XP
  - Ask A Question
  - Microsoft Access Help
  

Build a Database

• Use Database Wizards
  - Database Wizards
  - Use A Database Wizard
  
• Create A Blank Database
  - Create A Blank Database
  
• Work With Table Data
  - Enter Data
  - Edit Data
  
• Modify A Database
  - Open A Database
  - Use The Objects Bar & Views
  - Modify Table Structure
  - Modify Table Format
  - Work With Field Properties
  - Use The Lookup Wizard
  
• Build A Relational Database
  - Use The Table Wizard to Create Relationships
  - Create Relationships Manually
  
• Maintain Data Integrity
  - Referential Integrity
  - Enforce Referential Integrity
  

Work with Forms

• Form Basics
  - What Is A Form?
  - What Is A Sub-Form?
  
• Create Forms Automatically
  - Use AutoForm
  - Use The Form Wizard
  
• Create A Form Manually
  - Work With Controls
  - Get Help With Controls
  - Controls & Data Entry
  - Types Of Controls
  - Create A Form Manually
  - Add A Calculated Control
  
• Modify Form Controls
  - Control Properties
  - Modify Control Properties
  

Sort, Retrieve & Analyze Data

• Sort Data
  - Sorting Records
  - Sort Order
  - Perform An Advanced Sort
  
• Find Data
  - Find A Record
  
• Work With Filters
  - What Is A Filter?
  - Apply & Remove Filters
  
• Use Queries To Retrieve Data
  - What Is A Query?
  - Create A Select Query
  - Add a Calculated Field To A Query
  

Work With Reports

• Create Reports Automatically
  - What Is A Report?
  - Use AutoReport
  - Use The Report Wizard
  
• Create A Report Manually
  - Report Controls
  - Work With Controls
  - Types Of Controls
  - Create A Report Manually
  - Add A Calculated Control
  

Integrate Access With Other Applications

• Import Data To Access
  - Importing Data
  - Into A New Table
  
• Export Data From Access
  - Exporting Data
  - Export Data
  
• Publish A Database To The World Wide Web
  - Access & The World Wide Web
  - Data Access Pages
  - Create A Data Access Page
  

Access XP / 2002 (Expert)

Build & Modify Databases

• Build A Relational Database
  - Defining Relationships
  - Establish A One-To-Many Relationship
  - Establish A Many-To-Many Relationship

  This is primarily cdrom training This program may be available on CD Contact 123-CBT Computer Based Training for more information

  Training Presented in: English

  Click here for more information or to take this course

Access XP Proficient Expert --

About The Training Provider: 123-CBT Computer Based Training

More Microsoft Access XP Training from 123-CBT Computer Based Training

• Access 2002 Advanced
• Access 2002 Basic
• Access 2002 Intermediate
• Access 2002 Set of 3
• Access XP Curriculum
• Access XP Essentials Set of 3
• Access XP Expert User
• Access XP Fundamentals
• Access XP Proficient User