Microsoft Office XP - Access 2002 - CAXB

Description Access 2002 can strengthen your data organization capabilities for powerful results no matter what business you’re in. The Access 2002 training course from ATS successfully integrates solid instruction with an easy-to-follow presentation. In this self-paced course, expert instructor Casey McNeal arms you with practical knowledge as he demonstrates the powerful features of Access 2002. At the conclusion of this course, you will understand how to use the basic and advanced capabilities of Access 2002 to build databases, query data, design forms and generate reports.

Course Outline

Module 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 Overview • 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

Module 2

Section A: Field Properties Overview • 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 Overview • 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

Module 3

Section A: Merging Access into Word • Mail Merge Wizard • Create Letter • Run Merge

Section B: Action Queries Overview • 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 Overview • Headers & Footers • Move & Resize Controls • Add Controls • Add Calculated Control • Add Group & Sorting Control Pagebreak • Control Report Footer

Section G: Macros Overview • 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

Price £ 358 (Bundle of 3)

Complementary Courses
Word 2002
Excel 2002
Outlook 2002
Powerpoint 2002
XP Intergration
XP Professional Bundle

<<Back <<Contact Us