Browse and Register for CPE Programs
If you have any questions, please call 973.720.3698 or email CertificateProgram@wpunj.eduCourse Cart
No courses registered.
Browse our online catalog to register.
Important Information
« Back to Programs
Access - Basic/Intermediate - Online
** This program is Open Enrollment and can begin once you recieve your log-in credentials **
This course requires access to Microsoft Access. Program are not included in the course. More information is available at: https://www.microsoft.com/en-us/microsoft-365/p/access/cfq7ttc0k7q8
Microsoft Access is the Office application for creating a variety small business databases and is a good introduction to database technology. A key feature of Access is concurrent access - the ability for multiple users to use the database at the same time. Access databases are built using Objects which include Tables, Forms, Reports and Queries. We will explore all of these features in this course. Course topics include the following:
- Database Concepts
- Exploring Access Objects
- Tables, Forms, Queries and Reports
- Creating a New Access Desktop Database
- Tables
- Creating Table columns and rows
- Refining Table structure
- Defining relationships between Tables
- Maintaining Data Integrity
- Data Validation
- Sorting and Filtering
- Forms
- The Form tool, Form Design and the Form Wizard
- Formatting Forms
- Arranging the layout of Forms
- Entering Data into Forms
- Queries
- The Queries Wizard
- Creating Queries manually
- Summarizing data by using Queries
- Reports
- The Report Wizard
- Modifying report design
- Previewing and printing reports
Prerequisite: Previous knowledge of Microsoft Excel is required
For more information please contact goskowskik@wpunj.edu
Instructor : Frank Asciutto
Dates : 08/31/20
Days : Online
From : -
Fee : $ 575.00
Course Number : T036A
Class is unavailable at this time please call 973-720-2354 for more information or other course options