Whether an advanced or first time database user, Access XP delivers powerful tools for managing and analyzing data. Learn efficient database design, how to create effective tables and the secrets of querying. Know the logistics of data types and Auto-number fields. Also, see how to create and edit reports, charts and easy-to-use Switchboard forms. No marketing department should try to manage mass-mailings without the help of this great program.

• Learn at your own pace
• Build exactly the skills you need
• Master the tools for building a database that makes information easier to find and use
• Link to data from other Microsoft Office applications, HTML and XML files, and other databases
• Use forms, filters, queries, and reports to capture and analyze data
• Learn ways to prevent data corruption and unauthorized access
• Share your data with colleagues and customers through interactive Web pages
• Prepare for the Microsoft Office User Specialist (MOS) exam

This is a 6 hours course.
You will learn virtually everything you need to know about Access XP.

Understanding Databases

• Welcome
• What is a database?
  
• Introduction to the Interface
• The different Views
  
• Create a Table in Design View
  
• Primary Keys
  
• Utilizing the Wizard
  
• Datasheet View

Controlling the Database

• Editing Datasheet View
  
• Row Height Adjustment
  
• Adjusting with Column Width
  
• Working with Columns
  
• How to Freeze Columns
  
• Formatting Text
  
• Sorting Text

Sorting Information

• Finding Information and
• Replacing Information
  
• Filtering
  
• Filtering by Form
  
• Filtering with some features
  
• Relationships

Database Relations

• Integrity
  
• Adding more Tables to your relations
  
• Simple Query Wizard

Query Data

• Query in Design View
  
• Query multiple tables in
• Design View
  
• Presorting a Query
  
• Choosing the Criteria
  
• Hiding a Column of Data

Access Forms

• Introduction to Forms
  
• Adding a Record into a
• Form
  
• Automatic Form Creation
   

What are Reports?

• Create Reports with Wizard
  
• Automatic Reports

Controlling Columns and More

• Create a New Column
  
• Sub Data Sheet
  
• Look Up
  
• Hyperlink
  
• Relationships
  
• Character Length/Field Size

Data Types,Query Control

• Number Fields
  
• Date/Time Data Types
  
• Yes/No Data Types
  
• Default Values for Access
  
• Rules for Validation
  
• Locate Date info with < =
  And Or Condition
  
• Using the Between Statement
  
• Wild Card
  
• Creating a Calculated field
  
• Grouping By
  
• Parameter Query&
• Compound Parameter
• Query
  
• Make A Table from aQuery
  
• Update Query
  
• Delete Query
  
• Cross Tab Query Wizard
  
• Using a text file forcreating a Database using
• Notepad
  
• Importing the text file and Delimiting.

Advanced Control with Forms

• Welcome to Disk 2
  
• Password Protecting theDatabase
  
• Compacting a Database/Unset Password
  
• Creating a form using wizard and the controls
  
• Working with Controls and Deleting
  
• Align Controls
  Working with Field List
  Spacing
  
• Tool box Label
  
• Properties for objects
  
• Importing an Image
  
• Editing a control
  
• Creating a form with the wizard & understanding sections
  
• Combo Box
  
• List box
  
• Rectangle with Drop Shadow
  
• Tab Order
  
• Header and Footer
  
• Auto forms
  
• Check Box and Option Box
  
• All Properties

Utilizing Reports

• Creating a basic report
  
• Grouping Data
  
• Inserting a Date
  
• Insert a Page Break
  
• Margin Control
  
• Mailing Labels
  
• Font Control
  
• Format Painter
  
• SpellCheck
  
• Switchboard

Expression Builder

• 
  Expression Builder
• Calculation

Web Export

• Understanding the Types of Web Pages
  
• Exporting A Database Into HTML
  
• Creating a Data Access Page
  
• Auto Page Columnar

Macros

• A Basic Macros
  
• Open Report
  
• Open Query for Edit

Putting it all together!

• Creating a Basic Database from Scratch
  
• Customizing the form
  
• Datasheet View
  
• Jumping to different Fields
  Printing a Report from our Work
  
• Query Data for your Database
  
• Inserting a Graphic
  Photos for Each Record
  
• Creating a Macro
  
• User and Group
• Permissions
  
• Switch Board Control