When:
Tuesday, April 14, 2015
9:00 AM - 4:00 PM CT
Where: Wieboldt Hall North Entrance, 415, 339 E Chicago Ave, Chicago, IL 60611 map it
Cost: NU Employees $355; Non NU Registrants $615
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.
Day 1 Objectives
2010 Environment
Become comfortable in the new Access 2013 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
When:
Wednesday, April 15, 2015
9:00 AM - 4:00 PM CT
Where: Wieboldt Hall North Entrance, 415, 339 E Chicago Ave, Chicago, IL 60611 map it
Cost: NU Employees $355; Non NU Registrants $615
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.
Day 1 Objectives
2010 Environment
Become comfortable in the new Access 2013 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