Microsoft Access 2010

Introductory Skills

6 Weekly Lessons - Open Entry/Open Exit (Join Anytime)

This course is designed to take 6 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 e-course is an introduction to Microsoft Access 2010.  Introductory skills covered include building, managing, and maintain databases containing numerous objects, and more. Intermediate topics covered include designing relational databases, querying databases, customizing input forms, working with advanced queries, and more. Finally, advanced topics covered complex forms and reports, customizing the database interface, security options, and integration with other Office applications.

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 Book: Microsoft Access 2010 Essentials, Mastery Series. This book is available through the publisher and also limited copies are now available on Amazon.com. You could also use this text for the Advanced course on Access that may be offered on Officeskills.org at a later date.

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

LESSON 5: DESIGNING A RELATIONAL DATABASE

Identify and apply principles for good relational database design
Modify field settings and create Lookup fields that return multiple values
Create a split form
Identify database relationship types and create and print a relationships report
Identify object dependencies

LESSON 6: CREATING COMPLEX QUERIES

Create a select query involving multiple tables
Create a report based on multiple tables in a query
Create and run parameter queries
Create a calculated field in a query
Create and run action queries
Analyze, compact, repair, backup, and restore a database