Skip to content

[Grad-Cap Icon] Training

Search

You may use any or all of the criteria below to search for available instructor-led training classes or for self-paced training materials.

You may optionally refine your search with one or more of the following categories:

[Back Icon] Back to results

Access 2013 Intermediate

David Brobst, Technology Services
Technology Administration Building - 108

No registration available.
Date Time
Tue 03/15/2016 09:00am - 12:00pm

Access is a relational database that allows users to create queries, forms, and reports. This is a second level class that will help you acquire skills necessary to create queries, forms, and reports in an Access database.

Learning Objectives:

  • Use the Access Query Wizard to create and name a query
  • Add selection criteria to the query using design view
    • Boolean operators (and/or)
    • Date criteria
  • Add a calculated field to an Access query
  • Modify a query to perform a summary calculation on a record grouping
    • Average
    • Sum
    • Count
  • Explore the form design environment
  • Create a form with the AutoForm feature
  • Select and modify objects on a form in design view to change the appearance of the form
  • Create a report with the AutoReport feature
  • Create a report with the wizard
  • Explore the design view of a report
  • Add a calculated field to a report
  • Modify the properties of a control
  • Modify the report format by using the AutoFormat feature
  • Adjust the width of a report
Online Course Options: Other Resources: Other Courses:

Prerequisites: Access 2013 or comparable knowledge (i.e. Access 2010 Introduction [Online Equivalent])
Cost:
$0.00
Sponsor:
Technology Services
Audience:
VCU Students, Faculty and Staff Only
Category:
Databases, Microsoft Office
Contact:
VCU helpIT Center
804-828-2227
ts-courses@vcu.edu