Course Description
This class builds on the basic database concepts learned in Access I. New topics include displaying totals in queries, creating calculations in queries, automatically updating a table, using parameter and crosstab queries, enhanced form design (including combo boxes and subforms), creating and using PivotTable forms, creating and using a Switchboard, customizing reports to group and sort data, working with macros and creating command buttons for macros, using the Access Analyze tool and using Access data in other applications.
Is this class for you?
Upon successful completion of the course - you will be able to:
  • Building and modifying advanced tables
  • Building and modifying forms
  • Refining queries
  • Using advanced report features
  • Defining relationships
  • Access tools


You may also be interested in ...
search for C.E. courses without log in.
Search for Cont Ed courses without logging into CougarWeb.
Search by Term, then subject(s) and course title (optional).

Log in to online register with CougarWeb
Search and register online for Cont Ed courses by term (semester) using CougarWeb.
Returning student without a login should email cehelp@collin.edu for assistance.


New students who would like to register online need to go through the Continuing Education admissions process to receive a CougarWeb login.


Instructions to search for courses, register online and apply for CE CougarWeb access are found here.


Phone, walk-in and mail-in registration are three additional ways to register for Continuing Education courses.
 

Textbook Information
Other Information