Introduction to MS Access 2010

Access Basics

• 1
  Introduction to Databases

  Learn all about an Access database and how it works.
• 2
  Introduction to Objects

  Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database.
• 3
  Getting Started in Access

  Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar.
• 4
  Managing Databases and Objects

  Learn how to to open and close an Access database, as well as how to open, close, and save objects.

Working With Data

• 5
  Working with Tables

  Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.
• 6
  Working with Forms

  Learn how to use forms to enter new records and view and edit existing ones.
• 7
  Sorting and Filtering Records

  Learn how to sort and filter data so you can customize how you organize and view it.

Running Queries and Reports

• 8
  Designing a Query

  Learn how to create both a simple one-table query and a slightly more complex multi-table query.
• 9
  More Query Design Options

  Learn how to modify and sort queries, as well as how to use the Totals function to create a query that can perform calculations with your data.
• 10
  Creating Reports

  Learn how to create, modify, and print reports.
• 11
  Advanced Report Options

  Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report.

Database Design Tips

• 12
  Modifying Tables

  Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types.
• 13
  Creating Forms

  Learn how to create and modify forms using options like design controls and form properties.
• 14
  Formatting Forms

  Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts.
• 15
  Designing Your Own Database

  Learn how to create a database from an existing template and find resources to learn more about database design.

Extras

• 16
  Tables: How to Create Calculated Fields and Totals Rows

  Learn how to create calculated fields and totals rows.
• 17
  Queries: How to Create a Parameter Query

  Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms.
• 18
  Queries: How to Create a Find Duplicates Query

  Learn how to run an Access duplicates query to erase duplicates and strengthen your database.
• 19
  Query Criteria Quick Reference Guide

  Use this quick reference guide for 20 of the most common criteria used in Access queries.
• 20
  4 Free Alternatives to Microsoft Office

  Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice.