Learn how to capture and report data in a professional manner using Microsoft Access! This workshop is designed for people looking to learn the fundamentals of creating, using, and manipulating a database.

Our expert instructors will teach you the basics of working in MS Access including how to use fields, queries, and tables; how to work with toolbars; and how to use and search the help function.

In this half day class, you will learn new skills and practice them with hands-on instructor-led exercises. Computers will be provided. Upon successful completion of this course, students will be able to:

Create and build a new database

Work with tables

Set up fields for tables

Change fields in already established tables

Add additional tables to a database

Print the contents of a table

Join tables

Save tables

Create auto forms and auto reports

Add, change, and delete data in a database

Design, save, and print a database

Calculate statistics

Create validation rules

Close a database

This course will also include a brief introduction to querying, which will include how to query a database (all fields), create a new query (select fields), use compound criteria in querying, sort data in a query, and save a query.

You will also learn time-saving tips and shortcuts to work more quickly and efficiently. Our expert instructor will set aside time to answer your specific questions.

Note: While Microsoft Office Access 2013 will be used for in-class demonstrations and hands-on practice, most of the skills taught in this class are also applicable to older versions of Access. Windows operating system is used for instruction in all Microsoft Office workshops.

Prerequisite: Students should be comfortable with working database software programs before taking this class.

Fees

Registration Fee

TBD

There are no refunds for this program. Substitutions are permitted.

Meals

No meals will be provided at this course.

Location

GPS systems may not recognize campus addresses. Even if they take you to the correct building, they will not take you to the assigned parking lot. Therefore, we strongly recommend that you use the directions we provide.

Parking permit required for this location (will be provided to registrants).

Note: Pre-registration is required. We're sorry, but we cannot guarantee a seat, materials or meals for walk-in registrants. Location is subject to change; registrants will be notified in the event of a change.

Register

Sorry, registration is not currently available for this course.

Would you like to be notified when the next offering is scheduled?
Here are 3 convenient ways to be added to our mailing list:
1. Click here to join our mailing list (please reference "Microsoft Office Access - Level 1" or Course Code CS0401)
2. Call us at 848-932-9271, select option 3
3. E-mail us at ocpe@njaes.rutgers.edu

All of the courses offered by the Rutgers Office of Continuing Professional Education are approved by the New Jersey State Approving Agency for Veterans Training for tuition reimbursement through the GI Bill. For more information about the GI Bill, click here.