Access 2019: Level 2
Broaden your relational database design skills for increased data integrity with Microsoft Office Access.
Access 2019: Level 2
Broaden your relational database design skills for increased data integrity with Microsoft Office Access.
What you’ll be able to do — competencies
- Provide input validation features to promote the entry of quality data into a database
- Organize a database for efficiency and performance, and to maintain data integrity
- Improve the usability of Access tables
- Create advanced queries to join and summarize date
- Use advanced formatting and controls to improve form presentation
- Use advanced formatting and calculated fields to improve reports
Course description
Expand your knowledge of relational database design; promote quality input from users; improve database efficiency and data integrity; and implement advanced features in tables, queries, forms and reports. Extending your knowledge of Microsoft Office Access will result in a robust, functional database for you and your users.
Note: The Microsoft Office Specialist (MOS) certification test voucher is also available as an option for specific applications.
Prerequisites
- Access 2019: Level 1 or equivalent knowledge
Syllabus
Lesson 1: Promoting Quality Data Input
- Restrict data input through field validation
- Restrict data input through forms and record validation
Lesson 2: Improving Efficiency and Data Integrity
- Data normalization
- Associate unrelated tables
- Enforce referential integrity
Lesson 3: Improving Table Usability
- Create lookups within a table
- Work with subdatasheets
Lesson 4: Creating Advanced Queries
- Create query joins
- Create subqueries
- Summarize data
Lesson 5: Improving Form Presentation
- Apply conditional formatting
- Create tab pages with subforms and other controls
Lesson 6: Creating Advanced Reports
- Apply advanced formatting to a report
- Add a calculated field to a report
- Control pagination and print quality
- Add a chart to a report
Next available start dates
Online — Days
Access 2019: Level 2
Total classroom hours
8 hours
Schedule
Online
Days, 1:00 PM - 5:00 PM, 2 T Th - 5/11/2021 - 5/13/2021
Quarter: Spring
Total cost
$299
Instructor: Cliff Hanks
Notes
Online courses require an internet connection and the ability to interact both through audio and video using either a webcam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity are the responsibility of the student.
Interested in custom learning solutions for your team?
Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.
Get started