Audience | Any data base user or manager |
Prerequisites | Windows - User or equivalent To have followed the training: Access - Data structuring and normalization |
Objectives | - Be able to build simple queries allowing the extraction of data from a table.
- Be able to integrate several tables into a selected query
|
Teaching method | Presentations - Demonstrations - Guided and Individual Exercises |
Contents | Chapter 1 - Interrogating the tables of a database - Build a query based on several tables
- Establish relationships between tables
- Understanding relationship types
- Define the appropriate join type
|
Chapter 2 - Use calculated fields - Define a calculated field
- Inserting calculated fields in a query
- Using the expression generator
- Concatenating fields
- Using pre-programmed functions
- Using functions from the Text category
- Using functions from the Math and Date/Time categories
- Use logical functions
- Use calculated fields
|
Chapter 3 - Get statistical results - Create statistical and grouping operations
- Create grouping levels
- Create calculated fields using statistical and domain functions
|
Chapter 4 - Verify data integrity - Apply referential integrity
- Search for duplicates
- Search for non-matching items
|
Chapter 5 - Performing cross-analysis - Create a cross tab
- Modify a Cross Tab query
|
Chapter 6 - Setting up a query - Create and run a parameterized query
|