Northwestern Events Calendar

Jan
10
2017

HRD118-Access 2016: Building a Database

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

Description:

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.

Register More Info Add to Calendar

Add Event To My Group:

Please sign-in