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

