Online Courses to Develop Yourself & Advance Your Career at CareerBuilder Institute.

Microsoft Access

Gain access to your potential! Get the tools you need to become an indispensible asset to current or potential employers. Enroll Now!

Price:  $49.00

Availability:  Unlimited use for 90 Days!

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

Outlines

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

Access 2002 - Not For Sale

Gain access to your potential! Attain mastery of Microsoft Access 2002 with our comprehensive online course, and ensure your access to a better job. Our feature packed course covers everything from database design to complex reporting. Get the tools that you need to become an indispensable asset to current or potential employers. Stay ahead of the competition by enrolling now!


Access 2000 - Not For Sale

Gain access to your potential! Attain mastery of Microsoft Access 2000 with our comprehensive online course, and ensure your access to a better job. Our feature packed course covers everything from database design to complex reporting. Get the tools that you need to become an indispensable asset to current or potential employers. Stay ahead of the competition by enrolling now!


Access 2003 - Not For Sale

Gain access to your potential! Attain mastery of Microsoft Access 2003 with our comprehensive online course, and ensure your access to a better job. Our feature packed course covers everything from database design to complex reporting. Get the tools that you need to become an indispensable asset to current or potential employers. Stay ahead of the competition by enrolling now!

Table of Contents


Access 97 - Not For Sale

Gain access to your potential! Attain mastery of Microsoft Access 97 with our comprehensive online course, and ensure your access to a better job. Our feature packed course covers everything from database design to complex reporting. Get the tools that you need to become an indispensable asset to current or potential employers. Stay ahead of the competition by enrolling now!


Related Content

© 2008 - 2010 CareerBuilder Institute, all rights reserved