[Grad-Cap Icon] Training

Date	Time
Thu 09/18/2014	9:00am - 12:00pm

Access is a relational database that allows users to create queries, forms, and reports-among other things. This beginning class will introduce you to the Access environment and relational database terminology. You will explore and learn how to create some database objects - tables, queries, a simple form, and report.

Learning Objectives:

• Define the relational database concept
• Explore Access environment
• Examine an Access database table
• Create a table
• Add, edit, and delete records from a table
• Design a criteria to sort the records in a table - primary and secondary sort
• Create select queries to display records
• Update records from a table, a form, and a query
• Run an AutoReport to display records in report format
• Examine tables with existing table relationships
• Create forms to display data by using the AutoForm feature
• Identify primary and foreign key fields
• Import data into Access

Important Notice (Microsoft Silverlight): The 2010 videos require Microsoft Silverlight. If your video does not show or play, click the Silverlight installation icon when displayed to install the application. Click here to learn more about Silverlight.

Online Course Options:

• Access 2013 Training [Atomic Learning]
• Access 2013 [Microsoft Online]
• Access 2010 Introduction [Online Equivalent]
• Access 2010 intermediate [Online Equivalent]

Other Resources:

• Import Data into Access
• What`s new in Microsoft Access 2010 [articles & videos]
• Access 2010 Training Courses - Microsoft
• Access 2010 Video Tutorials - Microsoft
• Access 2010 Help and How-to - Articles and Tutorials
• Using Microsoft Access 2010 - Online VCU E-book

Other Courses:

• Access 2013 Introduction
• Access 2013 Intermediate
• Access 2013: Query Design
• Access 2013: Database Design Strategies