How to use Access: MS Access 2010 MS Access 2007 Tutorial Online Course: Learn for Free

These tutorials form a course to learn how to use Microsoft Access and are used in thousands of school institutions with advanced sections for post-secondary users. Microsoft Access 2007 2010 is a powerful windows relational database office software.

The tutorials course is available online for free for the general public to learn through a Computer Literacy Program. Providing free online educational material the program's mandate. Everyone at all ages and abilities can learn how to master databases online with carefully crafted and engaging tutorials.

Click on the buttons above to view on line course lessons and tutorials for Access PowerPoint Excel or Word or select from the links below:

Section one material covers the following topics and more: What is a database, What is a relational database, How to perform data entry, Learn database management, How to create a database, Access Tables, Design field, Format Date, Number and Create Queries, Create Reports, Data Types Field Properties, Lookup Drop-down list forms, Pictures and Images, email database, scholarship database, add Microsoft Access record.

• Online MS Access 2007 Tutorial direct links below or use navigation at top
  • Section 1: Tables/Forms/Images/Drop Lists etc.
    • 1A Intro Databases: Enter Data into Tables, Datasheet View, Types of Databases, Careers in Databases, Overview Microsoft Access
    • 1B Tables: Create Tables, Add Fields in Design View, Primary Key, Data Types, School Database
    • 1C Create Forms: Autoform, Enter Records in Form, Modify Layout, Design and Layout View, Insert Images into Form, AutoFormat, Create Form Header
    • 1D Lookup Lists and Images:Drop List List in Tables and Forms, Lookup Wizard, Add Fields to Form, Insert and Modify Images
    • 1E Movie Database: AutoNumber, Primary Key, Insert Clip Art, Modify Image,
    • 1F: Putting It All Together
  • Section 2 Queries Relationships Subdatasheets etc.
    • 2A Navigating Tables:Find Records and Replace Records
    • 2B Creating Queries: Single and Multiple Criteria, Sorting
    • 2C Lookup Data From Another Table: Lookup Wizard, Delete Relationships
    • 2D Using a Subdatasheet: Insert Subdatasheet From Related Table
    • 2E Primary Keys - Movie Database: Autonumber, Date Function,
  • Section 3 Forms/Reports/Grouping Sorting/Parameters etc.
    • 3A Primary Key / Import and Export: Import Text File, Export Data
    • 3B Autonumber / Import and Export: Append Records in Table
    • 3C Lookups / Subdatasheets / Relationships: Subdatasheet in a Form
    • 3D Reports: Modify Report in Layout and Design View, Add a Group and Sort
    • 3E Report Wizard: Create and Modify Reports Using Wizard
    • 3F Report Parameters
  • Section 4: Functions/Action Queries/Macros etc.
    • 4A Review: Tables, Queries, Forms, Lookups, Subdatasheets, Reports
    • 4B Reports: Headers / Footers / Functions
    • 4C Action Queries: Delete Query, Append Query, Update Query
    • 4D Calculated Fields in Queries / Reports:
    • 4E Automated Database: Custom Buttons, Modules, Macros, Message Boxes
    • 4F: Appointment / Invoicing Database: