FAST3 banner
Faculty and Staff Technology Training Team
  Home Workshops Calendar Registration General Information About FAST3 Contact Us  

Microsoft Access Training

Our Microsoft Access workshops include:

Access 2013

Access 2013: Getting Started (2 hours)

Access 2013: Queries (2 hours)

Access 2013: Forms & Reports (2 hours)

Access 2013, Level 1 (7 hours)

Access 2013, Level 2 (7 hours)

Access 2010
NOTE: After this fall (2014), Access 2010 workshops will no longer be offered.

Access 2010, Level 1

Access 2010, Level 2

Access 2013: Getting Started

This two-hour short course will introduce you to Microsoft's relational database application, Access 2013. Attendees will take a tour of the objects in an Access database, including tables, queries, forms, and reports.

Prerequisite: Familiarity with Windows
Instructor: FAST3 Staff
Hours: 2
Fee: $49

Date / Time: Sept. 29, 2014 (M); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2841-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Date / Time: Nov. 18, 2014 (Tu); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2879-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Access 2013: Queries

In this two-hour short course attendees will learn how to create Access queries. We will learn about the different types of queries: simple select queries, parameter queries, crosstab queries, and action queries. We will also work with calculated fields in a query.

Prerequisite: Completion of "Access 2013: Getting Started" workshop or equivalent knowledge
Instructor: FAST3 Staff
Hours: 2
Fee: $49

Date / Time: Oct. 1, 2014 (W); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2844-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Date / Time: Nov. 19, 2014 (W); 10:00 a.m. - 12:00 p.m.
Registration Code: W-2880-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Access 2013: Forms & Reports

Access forms provide a fast and easy way to enter and view data in a table. Reports are the end product of a database and are the best way to format, summarize, and print data. In this 2-hour short course we will cover the basics of working with Access 2013 forms and reports. You will learn the steps for setting up a form or report from design/layout to creation.

Prerequisite: Completion of "Access 2013: Getting Started" workshop or equivalent knowledge
Instructor: FAST3 Staff
Hours: 2
Fee: $49

Date / Time: Oct. 1, 2014 (W); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2845-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Date / Time: Nov. 19, 2014 (W); 1:00 p.m. - 3:00 p.m.
Registration Code: W-2881-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

Access 2013: Level 1

The Level 1 course is for those whose job responsibilities include working with table data, asking questions of the data, and generating reports. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as designing databases.

Upon successful completion of Level 1, attendees will be able to identify the components of the Access 2013 environment; modify, sort and filter records, and work with lookups; join data from different tables in a query, perform calculations in a query, create parameter queries, action queries, unmatched and duplicate queries, and summarize data; and generate reports.

Prerequisite: Familiarity with Windows
Instructor: FAST3 Staff
Hours: 7
UIUC CEUs: 0.7
CPDUs: 7 (Illinois teachers are eligible to earn 7 CPDUs for this workshop)
Fee: $179

Date / Time: Oct. 20 & 22, 2014 (MW); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2861-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Access 2013: Level 2

In Access 2013 Level 2, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Topics will include designing a relational database; working with query joins; learning ways to organize a database for efficiency; look at sharing data across applications; and advanced reporting.

Prerequisite: Completion of Access 2013 Level 1 or equivalent knowledge
Instructor: FAST3 Staff
Hours: 7
UIUC CEUs: 0.7
CPDUs: 7 (Illinois teachers are eligible to earn 7 CPDUs for this workshop)
Fee: $179

Date / Time: Dec. 9 & 11, 2014 (TuTh); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2887-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Access 2010: Level 1

The Level 1 course is for those whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Upon successful completion of Level 1, attendees will be able to identify the components of the Access 2010 environment; identify the components of a database; organize and view data in tables; query a database; design forms; and generate reports.

Prerequisite: Familiarity with Windows
Instructor: FAST3 Staff
Hours: 7
UIUC CEUs: 0.7
CPDUs: 7 (Illinois teachers are eligible to earn 7 CPDUs for this workshop)
Fee: $179

Date / Time: Sept. 23 & 25, 2014 (TuTh); 8:30 a.m. - 12:00 p.m.
Registration Code: W-2839-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

Access 2010: Level 2

This intermediate-level course is targeted for individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the integration of Access data with other applications such as Microsoft Word or Excel. Upon successful completion, attendees will be able to streamline data entry and maintain data integrity; join tables to retrieve data from unrelated tables; create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries; improve forms; customize reports to organize the displayed information and produce specific print layouts; and share data between Access and other applications.

Prerequisite: Completion of Level 1 or equivalent experience
Instructor: FAST3 Staff
Hours: 7
UIUC CEUs: 0.7
CPDUs: 7 (Illinois teachers are eligible to earn 7 CPDUs for this workshop)
Fee: $179

Date / Time: Oct. 29 & 31, 2014 (WF); 8:30 a.m. - 12:00 p.m.
Registration Code: W-2867-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Calendar      Back to Top

Registration Options (please choose your preferred method of payment):

Register and charge to a University account number

Register and charge to a credit card (if UI affiliated -- UI "netid" required)

Register and charge to a credit card (general public -- no "netid")

To register and pay by check, or to "register now but pay later", see our "Registration Options" page.

 

 

University of Illinois at Urbana-Champaign