;

What's New in the Microsoft Office
2019 Certiport Certifications?


Did you prepare for the Microsoft Office 2016 Certification Exams but now want to take the 2019 Certification Exams? We’re here to help! Check below to see what objectives Certiport has added to and removed from each of their exams. If you’re worried about your readiness for the 2019 exams, check out our Practice Tests and Courses that will help you learn and prepare.

Access Expert 2019 New and Removed Domains

Quick Snapshot

Removed Domains
  • 1.1.1: Create a blank desktop database
  • 1.1.2: Create a database from a template
  • 1.3.1: Navigate specific records
  • 1.3.2: Create and modify a navigation form
  • 1.3.3: Set a form as the startup option
  • 1.3.5: Change views of objects
  • 1.4.1: Compact a database
  • 1.4.2: Repair a database
  • 1.4.3: Back up a database
  • 1.4.4: Split a database
  • 1.4.5: Encrypt a database with a password
  • 1.4.6: Recover data from backup
  • 1.5.3: Save a database as a template
  • 2.1.1: Create a table
  • 2.1.5: Create a table from a template with application parts
  • 2.2.4: Rename tables
  • 2.3.1: Update records
  • 2.3.2: Add records
  • 2.3.3: Delete records
  • 2.3.4: Append records from external data
  • 3.2.1: Rename a query
  • 3.3.1: Add calculated fields
  • 3.3.2: Set filtering criteria
  • 3.3.3: Group and summarize data
  • 3.3.4: Group data by using comparison operators
  • 3.3.5: Group data by using arithmetic and logical operators
  • 4.1.1: Create a form
  • 4.1.2: Create a form from a template with application parts
  • 4.1.3: Save a form
  • 4.2.3: Modify data sources
  • 4.2.7: Add sub-forms
  • 4.3.2: Configure print settings
  • 4.3.4: Apply a theme
  • 4.3.6: Insert backgrounds
  • 5.1.1: Create a report based on the query or table
  • 5.1.2: Create a report in Design view
  • 5.1.3: Create a report by using a wizard
  • 5.2.2: Modify report data sources
  • 5.3.2: Add calculated fields
  • 5.3.8: Apply a theme

Access Expert 2019 New Domains:

3.1.1: Create simple queries

Queries make it easier to view, add, delete, or change data in your database. You can create simple queries through the Query Wizard on the Create tab. You can select which tables, queries, and fields to include in your queries.


3.2.3: Filter data within queries

To filter data in a query, open the query in Datasheet View, click the down arrow at the top of a column, and select a filter option. You can select multiple values from the list to include or not include.


GMetrix Can Help


GMetrix offers practice tests that allow you to check your readiness for the Access Expert 2019 official certification exam. If you don’t feel ready for the practice tests, we also host Access Expert 2019 courses from trusted partners that will teach you the ins and outs of the new and previous domains.


Access Expert 2019 Practice Tests
Access Expert 2019 Course (Coming Soon!)
Microsoft Office 2019 Full Suite
GMetrix interface
Your Content Host
GMetrix is the ultimate study platform
Are you a company who has made learning material for a certification? Host it here!
Email us at [email protected]
© Copyright 2021, GMetrix LLC   Privacy Policy  /  Return Policy