Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports.
Class Outline
Unit 1: Designing a Relational databases
- Topic A: Relational database design
- Topic B: Create a table
- Topic C: Create table relationships
Unit 2: Joining tables
- Topic A: Create Query joins
- Topic B: Relate data within a table
- Topic C: Work with Subdatasheets
Unit 3: Using data validation
- Topic A: Use field validation
- Topic B: Use form and record validation
Unit 4: Creating Advanced Queries
- Topic A: Create parameter queries
- Topic B: Summarize data
- Topic C: Create subqueries
- Topic D: Create Action queries
- Topic E: Create unmatched and duplicate queries
Unit 5: Organizing a database for efficiency
- Topic A: Data normalization
- Topic B: Create a junction table
- Topic C: Improve table structure
Unit 6: Using Advanced Reporting Techniques
- Topic A: Including control formatting in a report
- Topic B: Add a calculated field to a report
- Topic C: Add a subreport to an existing report
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.