Access XP Proficient and Expert

Access XP Proficient and Expert
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. Whether you are new to Access, upgrading from a previous release or need to obtain your MOS certification, this course takes you step-by-step through your mastery of Access XP. Access XP Proficient and Expert

Product Details

INCLUDES 2 Interactive Training CD-ROMs featuring MOS Proficient and Expert Training with audio animation and software simulations. Step by Step Demonstrations . Hands-on Lab Simulations with detailed instructions. Designed to help users learn at their own pace, allowing them to repeat topics or jump to anywhere in the course. Testing Modules to insure that you fully understand the subject matter. COURSE INTRODUCTION 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. Whether you are new to Access, upgrading from a previous release or need to obtain your MOS certification, this course takes you step-by-step through your mastery of Access XP. COURSE OUTLINE MS ACCESS XP PROFICIENT TRAINING CD 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 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 and Analyse 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 COURSE OUTLINE MS ACCESS XP EXPERT TRAINING CD Build and Modify Databases Build a Relational Database Build A Relational Database Defining Relationships Establish A One-To-Many Relationship Control Data Entry In Tables What Is A Validation Rule? Use Validation Rules Set Validation Text Create An Input Mask Lookup Fields Create Lookup Fields Link Tables Between Access Databases Link to Information In Another Database Link Tables Work with Forms Create A Form Create Form In Design View Use Subforms Forms & Subforms Create A Subform Switchboard Forms Create A Switchboard Form Set Startup Options Retrieve Data Locate Information Locate & Display Information Filter Data Use Advanced Filters Create Queries Queries That Perform Calculations Use Aggregate Functions Specify Multiple Query Criteria Create A Parameter Query Modify Data Using Action Queries Action Queries Create A Delete Query Create An Update Query Create An Append Query Work with Reports Create Reports Report Sections Create A Report In Design View Modify Reports Modify Section Properties Modify Control Properties Modify Report Properties Sort & Group Report Data Use Subreports Subreports Create A Subreport Operate Access on the Web Use Data Access Pages Data Access Pages Create A Data Access Page In Design View Modify A Data Access Page PivotTables & PivotCharts Create PivotTables In A Data Access Page Create PivotCharts In A Data Access Page Import & Export Access Data Export Access Data To An XML Document Import an XML Document To Access Manage an Access Database Database Security Database Permissions Ass Permissions to A Database Set & Modify A Password Encryption & Decryption Encrypt A Database Decrypt A Database Use Database Replication Replicate A Database Use Database Splitter Database Splitter Split An Access Database Compact & Repair Databases Compact A Database Repair A Database Create Access Modules Visual Basic Models Create An Access Module Use Visual Basic To Create An Access Module Distribute Databases As MDE Files MDE Files Create An MDE File