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, Level 1

Access 2013, Level 2

Access 2010

Access 2010, Level 1

Access 2010, Level 2

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: June 30 & July 2, 2014 (MW); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2785-C 
Location: UIUC (Champaign) -- Illini Hall, Suite 26 (lower level)

Date / Time: July 30 & Aug. 1, 2014 (WF); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2795-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: May 12 & 14, 2014 (MW); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2760-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: June 2 & 4, 2014 (MW); 1:00 p.m. - 4:30 p.m.
Registration Code: W-2768-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: June 25, 2014 (W); 8:30 a.m. - 4:30 p.m. (lunch on your own)
Registration Code: W-2784-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