Invest in your future! This course is a complete package tuned to give you the master keys to this powerful database program.

This is not your average “death by memorization” course! By using easily assimilated bite sized learning, and quick reference guides that you can print and save, our course is an on the job tool that is as practical in the workplace as it is in the classroom. Unlike other programs, this course includes all learning topics for all Microsoft Access versions, so you get it all in one package! This allows you to choose what you need to learn when you need to learn it. Best of all, there is nothing to download, just click and learn!

Employers; this course allows for quick on-the-job employee training. Let us expand your employees’ skill sets and save you money! Our program is more cost effective, time flexible, and practical than traditional training strategies and will make your employees even more efficient with a broader range of skills. If you are and individual looking to advance you will find that an expanded skill set means more money, opportunity, and confidence on your current job and future prospects.

Get ready for a vertical move and sign up now!

Our online Access course is way ahead of the curve when compared to other available Microsoft Access training. With our program you will not only learn the fundamentals of Access, but also topics such as:

• creating and working with databases
• finding, filtering, and formatting information
• working with tables and fields
• creating relational databases
• working with queries
• working with forms
• creating and formatting forms and reports
• utilizing macro
• using Access with other programs!

Lead the digital workforce in your office with skill and confidence!

500MHz Pentium or faster with 512MB Ram (1GB recommended) 1024 x 768 minimum monitor screen resolution with 16-bit video card Windows 2000, XP or later MAC Compatible Broadband connection (256 kbps or greater) connection recommended Internet Explorer 6.0+ or Firefox 2.0+ Flash Player 9.0+ required for most courses Sound card with speakers or headphones for audio playback Browser JavaScript must be enabled

Microsoft Access Outline

Chapter One: The Fundamentals Introduction to Databases What´s New in Access? Starting Access and Opening a Database Understanding the Access Program Screen Using Toolbars Hiding, Displaying, and Moving Toolbars Filling Out Dialog Boxes Keystroke and Right Mouse Button Shortcuts Opening and Modifying Database Objects Working with Multiple Windows Tour of a Table Adding, Editing, and Deleting Records Tour of a Form Tour of a Query Tour of a Report Previewing and Printing a Database Object Selecting Data Cutting, Copying, and Pasting Data Using Undo Checking Your Spelling Getting Help from the Office Assistant Changing the Office Assistant and Using the “What´s This” Button Using the Zoom Box Closing a Database and Exiting Access Chapter One Review	Beginning
Chapter Two: Creating and Working with a Database Planning a Database Creating a Database Using the Database Wizard Creating a Blank Database Creating a Table Using the Table Wizard Modifying a Table and Understanding Data Types Creating a New Table from Scratch Creating a Query in Design View Modifying a Query Sorting a Query using Multiple Fields Developing AND and OR Operators Creating a Form with the Form Wizard Creating a Report with the Report Wizard Creating Mailing Labels with the Label Wizard Database Object Management File Management Compacting and Repairing a Database Converting an Access 97 Database Chapter Two Review	Beginning
Chapter Three: Finding, Filtering, and Formatting Data Finding and Replacing Information Sorting Records Filtering by Selection Filtering by Form Creating an Advanced Filter Adjusting Row Height and Column Width Rearranging Columns Changing Gridline and Cell Effects Freezing a Field Hiding a Column Changing the Datasheet Font Chapter Three Review	Intermediate
Chapter Four: Working with Tables and Fields Understanding Field Properties Indexing a Field Adding a Primary Key to a Table Inserting, Deleting, and Reordering Fields Changing a Field´s Data Type Using Field Descriptions Adding a Caption Change the Field Size Formatting Number, Currency, and Date/Time Fields Formatting Number, Currency, and Date/Time Fields by Hand Formatting Text Fields Setting a Default Value Requiring Data Entry Validating Data Creating an Input Mask Creating a Lookup Field Creating a Value List Modifying a Lookup List Chapter Four Review	Intermediate
Chapter Five: Creating Relational Databases Understanding Table Relationships Creating Relationships between Tables Enforcing Referential Integrity Testing Referential Integrity and Deleting a Relationship Understanding of Relationship Types Chapter Five Review	Intermediate
Chapter Six: Working with Queries A Quick Review Creating a Multiple Table Query Creating a Calculated Field Using Expressions Using an IIF Function Summarizing Groups of Records Using Criteria Display Top or Bottom Values Parameter Queries Finding Duplicate Records Finding Unmatched Records Crosstab Queries Delete Queries Append Queries Make Table Queries Update Queries Chapter Six Review	Intermediate
Chapter Seven: Working with Forms Creating a Form with AutoForm Modifying a Form Adding and Deleting Fields Moving and Sizing Controls Changing the Tab Order Working with Control Properties Control Property Reference Working with Form Properties Form and Report Property Reference Working with Multiple Controls Adding, Cutting, Copying, and Pasting Controls Changing a Control´s Data Source Creating a Calculated Control Changing a Control´s Default Value Using the Control Wizard Creating a Subform Modifying and Working with Subforms Chapter Seven Review	Advanced
Chapter Nine: Working with Reports Creating a Report with AutoReport Modifying a Report Adding and Deleting Fields Moving and Sizing Controls Adjusting Page Margins and Orientation Adding Page Numbers and Dates Understanding Report Sections Grouping and Sorting Records Creating Calculated Controls Working with Section Properties Creating Charts with the Chart Wizard Chapter Nine Review	Advanced
Chapter Ten: Formatting Forms and Reports Formatting Fonts with the Formatting Toolbar Changing Text Alignment Using AutoFormat Changing Colors Applying Special Effects Using the Format Painter Adding Pictures and Lines Aligning Controls with One Another Changing a Control´s Formatting Properties Chapter Ten Review	Advanced
Chapter Eleven: Working with Macros Creating and Running a Macro Editing a Macro Working with Macro Groups Assigning a Macro to an Event Creating Conditional Expressions Assigning a Macro to a Keystroke Combination Macro Action Reference Chapter Eleven Review	Advanced
Chapter Twelve: Using Access with Other Programs Importing Information Exporting Information Importing Objects from another Access Database Linking Information from an External Source Analyzing Records with Microsoft Excel Exporting Records to Microsoft Word Mail Merging Records to Microsoft Word Using Hyperlink Fields Using OLE Object Fields Chapter Twelve Review	Advanced