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