Access II Queries, Relationships, & Interface
This is where to start for Access. Like anything else, you have to have a strong foundation to build on. In Access, Tables are the foundation. Learn to design for accuracy and ease of use. Start manipulating your data with Queries. Learn how to make data entry easier using Input Masks and Field Properties. TABLES * PROPERTIES * QUERIES
Scheduled Dates
| Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
|---|---|---|---|---|---|---|
| Access II Queries, Relationships, & Interface | 4/29/2023 (Sat) | 1PM - 4PM | 5 | 4 | $95.00 | Register |
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
Topics Include:
- Understanding database vocabulary
- Opening an existing database
- Creating a new database
- Creating a table
- Datasheet View
- Entering and editing data
- Modify Table
- Understanding and adding field properties
- Creating a field input mask
- Finding data
- Replacing data
- Filtering data by form
- Clearing a filter
- Filtering data by selection
- Sorting records
- Creating a query
- Adding and removing tables
- Inserting, moving, and removing fields
- Selecting the sorting order
- Understanding and entering criteria options
- Printing options
- Deleting objects
- Sample tables
- Sample data