Search
You may use any or all of the criteria below to search for available instructor-led training classes or for self-paced training materials.
You may optionally refine your search with one or more of the following categories:
Date |
Time |
Tue 11/10/2015 |
09:00am - 12:00pm |
Have you ever wanted to understand how to design well-formed tables and queries in MS Access? Have you ever wanted to know the pros/cons of table and query design? This is the course for you!
Learning Objectives:
- Should you use Access or Excel
- Think about the End Products, like the Reports, before starting a design
- Remove Excel Design Concepts from your mind
- Things to think about when assigning Fields to a Table
- Assigning a Name to a Field
- Examine Fields and their Data Types
- Examine Field properties
- Determine how/why Fields should be assigned to Tables
- How/why to create a Primary Key
- Determine which Fields from Table to Table
- Relating Fields from Table to Table
- Should a Relationship have Referential Integrity
- How Tables work with Queries, Forms, and Reports
Other Resources:
Other Courses:
Prerequisites: Access 2013 levels I and II (or Online Equivalent) are required for this class.
- Cost:
- $0.00
- Sponsor:
- Technology Services
- Audience:
- VCU Students, Faculty and Staff Only
- Category:
- Databases
- Contact:
- VCU helpIT Center
804-828-2227
helpIT@vcu.edu