CANCELLED
When:
Tuesday, January 10, 2017
9:00 AM - 4:00 PM CT
Where: Parkes Hall, 127, 1870 Sheridan Road, Evanston, IL 60208 map it
Audience: Faculty/Staff - Student - Public - Post Docs/Docs - Graduate Students
Cost: NU Employees $500; Non-NU Participants $955
Contact:
Learning & Organization Development
(847) 467-5081
Group: Office of Human Resources | Talent Development & Well-being
Category: Training
This two-day workshop is designed for both those who wish to create a database from scratch and to make design changes to an existing database.
Prerequisite: HRD108- Access 2016: Enter/View/Find Data. If you have not completed Access 2016: Enter/View/Find Data, please contact the Learning & Organization Development team to verify equivalent experience/skills.
Day 1 Objectives
2016 Environment
Become comfortable in the new Access 2016 environment of Tabs & Ribbons
Database Design & Relationships
-Define a structured purpose, scope, and objectives for the database
-Learn data-gathering techniques that enable quicker starts, clarify the types if information needed from the database, and help in naming fields, grouping them into tables, and relating tables to each other
-Consolidate data into user friendly critical content areas
-Understand and implement three types of table relationships (one-to-one, one-to-many, and many-to-many) and eliminate weak relationships with a junction table
-Apply normalization tests to evaluate the integrity of the database design
Tables
-Create relationships between tables
-Enforce referential integrity between tables to keep records in related fields valid and accurate; view sub-datasheets to related tables
-Create lookup lists and set different properties of a field in the
-Design view of a table
-Create an input mask for data entry
-Set validation rules and text for a field
Day 2 Objectives
Queries
-Understand the purpose of various queries
-Create a query from scratch and specify criteria
-Create queries that are based on more than one table and create a calculated field
-Use queries to summarized data from tables
Forms and Reports
-Create forms & reports using the wizards and modify those forms with styles
-Reorganize the form layout by moving fields to change the order in which they appear on the form
-Modify properties to define an object's appearance, behavior, and characteristics
-Customize headers and footers to prepare for printing
The second day of this workshop will take place on January 11th.