Duration
1 day
Overview
This level discusses ways to ensure that the data in related tables is accurate, how to use queries to extract data from related tables, and how to create forms and reports that use related tables.
Course Objective
- Structuring a database
- define the appropriate tables, fields, and data types for a database
- create, modify, and print table relationships
- set, change, and remove primary keys
- Creating and modifying queries
- ability to create various types of queries based on one table or multiple tables
- add tables to and remove tables from queries
- add criteria, joins, calculated fields, and aliases
- create sum, average, min, max, and count queries
Lesson 1: Creating and Modifying Queries
- Create a Simple Query
- Create a Find Duplicates Query
- Create a Query from Multiple Tables
- Find Unmatched Records
- Add a Table to a Query
- Add Criteria to a Query
- Sort Data within a Query
- Filter Data within a Query
Lesson 2: Using Controls in Reports and Forms
- Add Unbound Controls
- Add a Bound Control to a Report
- Add a Calculated Control
- Use the Control Wizard
- Use the Control Wizard to Add Button Controls
- Define Control Tab Order
- Format Controls on a Report
- Format Controls on a Form
- Create Conditional Formatting
- Arrange Control Layout
- Add, Move, and Remove a Control from a Layout
- Arrange and Anchor Controls within a Layout
- Arrange Control Alignment, Size, and Position
- Adjust Page Margins and Change Page Orientation for Forms and Reports
Lesson 3: Advanced Tables
- Create a Custom Table in Design View
- Insert and Delete Rows in Design View
- Use the Table Analyzer
- Insert a Total Row
Lesson 4: Advanced Forms
- Create a Multi-Item Form
- Create a Split Form
- Create a Subform
- Use Application Parts to Create Blank Forms
- Create a Navigation Form
Lesson 5: Advanced Reports
- Use the Report Wizard
- Use the Group, Sort, and Total Pane
- Change Grouping Options
- Create Aggregate Fields
- Create a Subform on a Report
- Create the Print Layout
- Use the Label Wizard
Programme scope, delivery arrangements and suitability are confirmed during enquiry.