Access 2010-Basics

About the Class:

This course is for anyone wanting to develop proficiency with Microsoft Access.  In-class activities will require you to use the latest version of Microsoft Access to create and edit a database document according to specific requirements provided.

What You’ll Learn:

Upon completion of this class, participants will:

  • Gain a basic understanding of a database, and when to use it.
  • Understand the purpose of tables, queries, forms, and reports.
  • Use an existing data base.
  • Look at the design of tables, forms, reports, etc.
  • Change, add, delete, sort, and filter records.
  • Find basic information from a db searching or using filters.
  • Create a small database using a template.
  • Enter a few records using the switchboard.
  • Examine the design of a form.
  • Create a new database
  • Add desired fields into a table.
  • Enter data into a table.
  • Create a form to make data entry easier.
  • Create and browse a report.
  • Use the design view to modify a report
  • Preview and print a report.
  • Create a query.
  • Create a form and add a record.
  • Create a report that generates labels.
  • Create and save a query that shows all people not living in your most frequent city.
  • Include at least one picture someplace.
  • Sort the database.

What You Need to Know:

  • Basic keyboarding and mouse skills are required.

If you don’t have those skills, consider first taking the workshop:

Resources

Access 2010(PC) Access 2012(Mac)
 Microsoft Office: Make the Switch to Access 2010  
 Microsoft Office: Basic Tasks  
 Microsoft Office: Create Tables for a New Database