Easy 123 Videos  

Self-Paced Video Tutorial CD on Access – Make Learning Fun & Easy

Learn Excel Quickly and Thoroughly

Preview Easy123 Videos Excel Tutorial

Preview Tutorial

Easy123 Access

Retail Price: $49.95

Special Offer: $29.95

You Save: $20.00

Order Now

CD ships promptly after order

Secure Encrypted Ordering Privacy Protected

Learn Microsoft Access at Your Own Pace from the Comfort of Home

Computer Skills DiplomaLearning to use Microsoft Access has never been this simple. Our video tutorials walk you step-by-step through all key Access features. The video training series begins with the simplest tasks and progresses to more advanced features when you're ready. Whatever you skill level, Easy123 Access helps you learn all aspects of the program, providing a solid foundation for your future growth.

Easy123 CDThere is no need to send back the discs—keep them as a valuable, ongoing reference. Easy123 Access is not only a great value—it actually quickly pays for itself in increased productivity & business skills. There are no hidden costs. Each Easy123 CD includes unlimited usage.
Get the Microsoft Access CD mailed to you today!

Features & Benefits of Easy123 Access

Visual Learning

Are you more of a visual learner? See and hear the material being demonstrated with these video tutorials.

Learning Software
Try Our Other Tutorials

Self-Paced

Just pop in a CD and start learning—at your own speed.

No Internet Connection Needed

Learn at home or on the road with your laptop, anywhere at anytime.

Personal Feel

Enjoy having your own personal instructor at your fingertips.

Gradual Learning

Tutorials go from basic to advanced topics, and are produced by professionals who understand both the programs and the learning process.

Enhance Your Job Skills

Get promoted, increase your salary by learning new skills.

Become the Expert

Realize the freedom of no longer needing to rely on others for help with technology. Become an expert in your home and office, the Easy way.

Order CD 1

 Order CD 2

By choosing Order CD 1, you will have the option to add CD 2 to your order on the next page.
If you wish to just order CD 2, click the CD 2 button.

CD will ship promptly after your order is complete.
We use industry-standard encryption to protect the confidentiality of your personal information.
Please note that all CDs are for Windows only (XP, Vista, Windows 7).

Course Outline: Microsoft AccessTutorial – Disc 1

Disc 1 - Lesson 1: Understanding Database Basics

  1. Welcome - Learn what access is and what it can be used for
  2. What is a database? - learn what a database in Access XP is used for and what it looks like
  3. Interface intro - learn the different windows of Access, how to manipulate the program & more
  4. THe Views - learn about the different views between the database, open page, and Design View
  5. Create a table - This video teaches you how to create a table or database from Design View
  6. Primary Keys - learn how to set a primary key to a certain field in your database
  7. Utilizing the wizard - Learn how to use the wizard of Access to create a database
  8. Datasheet view - In this section you will learn how to navigate throughout Datasheet View

Disc 1 - Lesson 2: Controlling the Database (Click for details)

  1. Editing Database View - In this section you will learn how to edit contents in Datasheet View
  2. Row Height Adjustment - This video shows you how to alter the height of the rows in your database
  3. Adjusting column width - learn how to change the width of the columns in your database
  4. working with columns - Moving, changing size and more
  5. How to Freeze columns - Learn how to freeze a column to keep it in place at all times
  6. formatting text - learn how to add formatting details to the text in your database
  7. sorting text - learn multiple ways to sort the text in your database

Disc 1 - Lesson 3: Sorting Information (Click for details)

  1. finding & replacing information - learn how to use the Find & Replace feature of Access
  2. Filtering - Here you will learn how to filter information in your database
  3. filtering by form - learn to filter by form to show the information you choose on its own datasheet
  4. advanced sorting - how to use the Advanced Filter Sort feature of Access
  5. relationships - learn to create relationships between different databases you have in Access

Disc 1 - Lesson 4: Database Relations (Click for details)

  1. integrity - how to match fields together from different databases to create integrity in relations
  2. adding tables to relations - how to add more tables to relationships that you have already created
  3. simple query wizard - learn to use the Simple Query Wizard to extract records in Access
  4. Linking Cells & Using Comparison Operators
  5. Creating an Absolute Reference
  6. Defining Named Ranges
  7. Exploring the Function Library
  8. Using the AutoSum Function

Disc 1 - Lesson 5: Query Data (Click for details)

  1. Query in design vier - learn how to perform a query, or search, in Design View
  2. Multiple table query - learn how to perform a query throughout multiple databases at once
  3. presorting a query - This video shows you how to pre-sort your data for a query
  4. choosing criteria - learn to sort your criteria to make it easier to choose when performing a query
  5. hiding a data column - learn how to show and hide entire columns in your table

Disc 1 - Lesson 6: Access Forms (Click for details)

  1. Intro to forms - learn how to create a form from a database you have using the Form Wizard
  2. adding records to a form - Here you will learn how to add a new record into an existing form
  3. automatic form creation - learn the fastest and easiest way to create a form from databases

Disc 1 - Lesson 7: What Are Records (Click for details)

  1. Create reports with wizard - learn how to create a new report in Access using the Report Wizard
  2. automatic reports - learn how to automatically create reports using existing criteria

Disc 1 - Lesson 8: Controlling Columns and More (Click for details)

  1. Create a new column - Here you will learn how to insert a new column into your database
  2. sub data sheet - This video teaches you what a Sub Data Sheet is used for and how to create one
  3. look up - learn how to create a Look Up Column that allows you to sort values in your table
  4. hyperlink - Here you will learn how to create hyperlinks from your text in Access
  5. relationships - learn how to format text, background, fields and more about relationships
  6. Character Length/Field Size - how to limit or increase the allowed field size of text you can enter

Disc 1 - Lesson 9: Data Types, Query Control (Click for details)

  1. Number Fields - In this section you will learn how to control the number field of your database
  2. date/Time Data Types - Here you will learn how to control the data type using date and time
  3. yes/no data types - how to create yes/no data types for things like checkboxes
  4. default values for access - learn how to create a default value to enter in fields
  5. validation rules - learn to use the validation feature of Access to set rules in your database
  6. locate data info - This video teaches you how to query a specific date throughout your database.
  7. and/or condition - learn how to query a database using the and/or condition
  8. the between statement - learn to use the between query to search within dates or numbers
  9. wild card - Here you will learn how to use the wild card search feature
  10. Create a Calculated Field - learn how to calculate one field by another field
  11. Grouping by - In this section you will learn how to control your query using the group feature
  12. Parameter Query - how to perform a parameter query within a query you have already created
  13. Make a Table from a Query - This video shows you how to create a table from a query
  14. update query - learn how to use hte Update Query command in your Access database
  15. delete query - Here you will learn how to delete or remove a query you have created
  16. Cross Tab Query Wizard - learn how to create a query that displays information in a compact table
  17. Using a text file to create a database - learn how to create a database from an existing text file
  18. Importing text files & delimiting - Learn to import existing text files into your Access database

Course Outline: Microsoft AccessTutorial – Disc 2

Disc 2 - Lesson 1: Advanced Control with Forms (Click for details)

  1. Welcome - This section breifly explains the things you will learn in this chapter
  2. password protection - learn to create a password for your database
  3. compact databases/unset password - learn to unset a password compact the data in your database
  4. creating a form using wizard - create a form using the wizard and add controls to your database
  5. working with controls - move and manipulate the controls; how to remove controls
  6. align controls - learn how to align the controls to a certain starting or ending point
  7. Field List - learn how Access makes working with field lists easy to display the categories
  8. spacing - This section shows you how to alter and set the spacing between your controls
  9. Tool Box Label - In this section you will learn how to add labels into your database
  10. Properties for Objects - View and edit properties of each object.
  11. importing Images - Here you will learn how to insert an image into your form
  12. Editing a Control - In this section you will learn how to edit your existing controls
  13. Creating Forms with Wizard - More detailson creating a form using the wizard
  14. Combo Box - In this section you will learn how to create a Combo Box within a form
  15. List Box - Learn how to create a List Box in your form that displays a list of the values
  16. Rectangle with Drop Shadow - Here you will learn how make your form more attractive
  17. Tab Order - This video teaches you how to control the order in which you tab
  18. Header and Footer - In this section you will learn how to add a header and footer to your form
  19. Auto Forms - In this section you will learn how to create an auto form
  20. Check Box & Option Box - Here you will learn how to input the Yes and No Option into a form
  21. All Properties - In this section you will learn about all the properties of an object

Disc 2 - Lesson 2: Utilizing Reports (Click for details)

  1. Creating Basic Reports - learn how to create a report from existing data in a table
  2. grouping data - You will learn how to group the data in your report in this section
  3. inserting a date - Here you will learn how to insert the date and time into your report
  4. insert a page break - In this section you will learn how to insert a page break into your report
  5. margin control - Here you will learn how to change the margins in Design View
  6. font control - This section teaches you how to change the font in your report
  7. format painter - learn how to use the Format Painter to add formatting to objects
  8. spell check - Here you will learn how to use the Spell Check feature of Access
  9. switchboard - In this section you will learn how to add a Switchboard form

Disc 2 - Lesson 3: Expression Builder (Click for details)

  1. Expression builder calculation - learn to create expression builders to designate to specific forms

Disc 2 - Lesson 4: Web Export (Click for details)

  1. understanding types of web pages - learn the different types of web pages you can use
  2. export a database into html - learn how to export one of your databases into an HTML site
  3. create a data access page - learn how to create a data access page from an existing database
  4. auto page columnar - In this section you will learn how to work with HTML in your document

Disc 2 - Lesson 5: Macros (Click for details)

  1. basic macros - Here you will learn how to create macros, or compiled steps, in your database
  2. open report - In this section you will learn how to create other types of macros
  3. open query for edit - In this section you will learn how to create a query macros

Disc 2 - Lesson 6: Putting it all Together! (Click for details)

  1. create a database from scratch - learn how to create a new database from the top
  2. customizing the form - This section shows you how to customize your Access form in Design View
  3. datasheet view - more customization of your database & adding and editing text in Datasheet View
  4. Jumping to Different Fields - Here you will learn how to navigate quickly between fields
  5. Printing a Report from our Work - In this section you will learn how to print out a report
  6. Query Data for Databases - Here you will learn how to create a new query to search with
  7. Inserting a Graphic - In this section you will learn how to insert graphics into your database
  8. Photos for Each Record - Learn how to embed an image that changes as your records change
  9. Creating a Macro - This video teaches you how to create a new macro
  10. User & Group Permissions - Learn how to create and edit permissions on your database
  11. Switch Board Control - learn how to create a switchboard which is a page with options

Order CD 1

 Order CD 2

By choosing Order CD 1, you will have the option to add CD 2 to your order on the next page.
If you wish to just order CD 2, click the CD 2 button.

CD will ship promptly after your order is complete.
Please note that all CDs are for Windows only (XP, Vista, Windows 7).

Payment Methods

Verisign Secured Secure Transaction

We use industry-standard encryption to protect the confidentiality of your personal information.