Microsoft Access 2010

Level 1 Introductory Skills

$59.99

4 Weekly Lessons - Course Coming Soon

This course is designed to take 4 weeks although you have up to 6 months from the date of enrollment to complete the course. With our anytime, anywhere policy, you can complete the assignments at a time and place that is convenient for you. This course is hosted on E-Lab. Upon enrollment, you will receive your class URL and login details for the course.

DESCRIPTION

This introductory ecourse covers beginning-level skills, and is ideal for the newer computer user who wants to become well versed in Access. Topics introduced include the Ribbon interface, creating tables in Datasheet view, previewing and printing data, designing databases, creating database objects, formatting tables, lookup fields, field properties, queries, and more. After completing this course, students can successfully face the challenges presented in Microsoft Access 2010: Level 2 that will be offered at a later date on Officeskills.org.

Pre-Requisites

Be familiar with the keyboard and typing. Knowledge of the Internet, uploading files and operating systems.

Requirements:

• You will need Microsoft Office 2010. 60 Day Free Trials are available at the following link: Microsoft Office 2010 Free Trials. Please note: Depending on the course(s) you are enrolled in, this may not be long enough to complete your course.
• Adobe Flash Player so you can view the Video Lessons. You can download the latest version at the following link: Adobe Flash Player.
• Adobe Reader to view pdf presentation files is available at the following link: Adobe Reader Download

Recommended Books:.

FastCourse Microsoft Access 2010: Level 1 By Pamela R. Toliver . This book is available through the publisher and also very limited copies may be available on Amazon.com.

COURSE OBJECTIVES

Upon successful completion of this course, students should be able to:

• Define database and key terms associated with databases
• Close a database and exit Access 2010
• Identify key database design techniques
• Create a new database using a template
• Change the layout of a table by adjusting column width, hiding columns, and rearranging column layout
• Rename, copy, and delete database objects
• Create, save, and run select queries
• Create unmatched and duplicates queries
• Create a split form
• Identify object dependencies
• Create a select query involving multiple items
• Create and run action queries
• Use Form Design and Layout Views
• Print forms
• Create a report using Report Design View
• Create a labels report using the Labels Wizard
• Create a main form containing a subform
• Add the current date to the form
• Import a report into a database
• Analyze report performance
• Set Access options
• Encrypt a database with a password
• Share Access data with Word, Excel, and Outlook
• Work with HTML files
• Much, much more!

DETAILED COURSE OUTLINE

LESSON 1: EXPLORING ACCESS 2010

Define database and key terms associated with databases
Identify objects contained in modern databases and explain how they are used
Launch Access 2010 and identify elements of the application window
Create a new blank database and database table
Use the Navigation Pane and enter data into a table
Save and close database objects
Preview and print datasheets
Use Help
Close a database and exit Access 2010

LESSON 2: BUILDING A DATABASE

Identify key database design techniques
Open an existing database
Create a database table using Design View
Create a form
Create a report
Create a table from an Excel worksheet
Create a new database using a template

LESSON 3: MAINTAINING A DATABASE

Change the layout of a table by adjusting column width, hiding columns, and rearranging column layout
Locate and update records by sorting, filtering, and using Find and Replace
Enhance a datasheet
Set table field properties
Rename, copy, and delete database objects

LESSON 4: QUERYING A DATABASE

Create, save, and run select queries
Design a query using multiple tables
Set query criteria
Define a query sort order
Create and format a calculated field
Use functions in query expressions
Create a crosstab query
Create unmatched and duplicates queries