Using tables and relationships effectively in Microsoft Access

249

Product description

Bag code: COMSO61525024 Days: 5 days Time: 25 training hours Targeted participants: Anyone interested in learning about Microsoft Access Program overview: This program focuses on effectively using tables and relationships in Access. (Definition – Types – Properties – Goals – Advantages – Disadvantages... etc.) It will be presented through the following units: Unit 1: Comparing two tables using join operations and a key field. Unit 2: Relationships, their types, and properties. Unit 3: Types of table relationships. Unit 4: Creating a table relationship using the "Relationships" window. Unit 5: Making changes in the "Relationship Properties" dialog box. Program objectives: - To familiarize the trainee with what is meant by the "Relationships" window. - To identify relationships, their types, and properties. - To learn about the types of table relationships. - To apply creating a table relationship using the "Relationships" window. - To identify how to edit a relationship. Program topics: Unit 1: (Comparing two tables using join operations and a key field) - What is meant by the "Relationships" window? - What can be done. - Comparing two tables using join operations and a key field. Unit 2: (Relationships, their types, and properties) - Relationships, their types, and properties. - Relationships in terms of multiple tables. Unit 3: (Types of table relationships) - Types of table relationships. - Why create table relationships? - Displaying table relationships. Unit 4: (Creating a table relationship using the "Relationships" window) - Creating a table relationship using the "Relationships" window. - Notes. - Creating a table relationship using the "Field List" part to add a field. Unit 5: (Making changes in the "Relationship Properties" dialog box) - Editing a relationship. - Setting the relationship type. - Deleting a table relationship. - Making changes in the "Relationship Properties" dialog box. - Enforcing referential integrity. - Turning referential integrity on or off. - Setting cascade options. - Turning on or off cascade update and/or cascade delete. Bag contents: - PowerPoint: 166 - Trainer's guide: 113 - Trainee guide: 96 - Activities: 12 - Introductory guide: 1 - References: 4 - Evaluation and data forms: 6 - Pre- and post-tests: 6 - Videos: 4 - Images: 10 - Mind maps: 1 - Brochure: 1 Bag contents: 12 Training bag template Please click here to view the training bag template

Questions you might have

‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌