Layout Table~~~~3857~3857~~

Access 3 Sessions - 9 Hours of Interactive Training~
Access 2002 can strengthen your data organization capabilities for powerful results no matter what business you’re in. Expert instructor, Casey McNeal, demonstrates the powerful features of Access 2002 from LearnKey. McNeal successfully integrates solid instruction with an easy-to-follow presentation that arms you with practical knowledge. At the conclusion of this training course, you’ll understand how to use the basic and advanced capabilities of Access 2002 to build databases, query data, design forms and generate reports.

Benefits
• Gain valuable skills and improve personal productivity..
• Acquire knowledge that will add credibility for future career prospects.
• Increase marketability by using the latest information technology. .~~~3857~3858~~

Course Outline Table~~~~3857~3859~~

Session 1~Section A: Introduction
· Database Concepts
· Relational Databases
· Task Pane
· Tables
· Forms
· Queries
· Reports

Section B: Database Wizard
· Database Development
· Build a Database

Section C: Table Essentials
· Table Wizard
· Relationships
· Field Names
· Text & Number Data Types
· Other Data Types
· Primary Key

Section D: Datasheet View
· Add New Record
· Delete Record
· Office Clipboard

Section E: Table Appearance
· Column Width
· Font & Cell Effects
· Moving & Hiding Columns

Section F: Filter Techniques
· Sorting Records
· Find a Record
· Filter By Selection

Section G: Query Essentials
· Relationships
· Query Wizard
· Dynaset Concepts
· Add Criteria
· Comparison Operator
· Wildcards

Section H: Form Essentials
· Form Wizard
· AutoForm

Section I: Report Essentials
· Report Wizard
· Calculated Control
· Print Preview
· Label Wizard~~~3857~3860~~

Session 2~Section A: Field Properties
· Field Size
· Data & Time
· Context Sensitive Help
· Yes & No Fields
· Default Value
· Validation Rule
· Indexed Field

Section B: Create a Lookup
· Insert a field
· Lookup Wizard
· Limit to List

Section C: Importing & Exporting Data
· Export to Excel
· Import from Access
· Import from Excel
· Link Data from Excel
· Share a Database
· Database Splitter

Section D: Relationships
· Relate Tables
· Referential Integrity
· Cascade Options
· Print Relationships

Section E: Advanced Query Techniques
· Parameter Queries
· Multiple Parameters
· Calculated Fields
· Expression Builder
· Summary Queries

Section F: Using Access & HTML
· Properties of HTML
· Creating a Hyperlink
· Using Hyperlinks
· Publish Database to HTML Format
· Creating Data Access Pages
· Accessing Access Pages in Browser~~~3857~3861~~

Session 3~Section A: Merging Access into Word
· Mail Merge Wizard
· Create Letter
· Run Merge

Section B: Action Queries
· Make Table Query
· Append Query
· Delete Query
· Run Delete Query
· Update Query
· Print Queries

Section C: Compact & Backup
· Compact & Repair Utility
· Backup & Restore Tool

Section D: Form Design
· Print Records
· Form Controls
· Calculated Controls
· Object Properties
· Event Procedures
· Working with Controls

Section E: Advanced Form Design
· Adding Fields
· Saving & View Form
· Adjust Tab Order
· Add Combo Box
· Add Command Button
· Add Graphic
· Add Header & Footer
· Add ActiveX Control
· Input Mask Wizard

Section F: Report Design
· Headers & Footers
· Move & Resize Controls
· Add Controls
· Add Calculated Control
· Add Group & Sorting Control
· Pagebreak Control
· Report Footer

Section G: Macros
· Creating, Saving & Running Macros
· Perform Queries from Macros
· Assigning a Macro to Event Procedures

Section H: Switchboard
· Creating Switchboard
· Editing Switchboard
· Switchboard in Action
· Set a Startup Option~~~3857~3862~~

Ordering~~~~3857~3863~~

Access 2002/XP Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~a~PER USER%3A CD Course|670488|PER USER%3A ONLINE Course|!78959|LIBRARY LICENCE%3A CD Course|670485|~3857~3864~access microsoft end user 2002 xp~