100+ Free MOS Access Expert Practice Questions

Manage databases

Modify database structure by importing objects and data, deleting objects, and hiding or displaying objects in the Navigation Pane; manage table relationships and keys including setting primary and foreign keys and enforcing referential integrity; and configure print options and export objects to alternative formats.

Create and modify tables

Create tables by importing or linking data and importing tables from other databases; manage tables with hidden fields, total rows, and descriptions; manage records using find and replace, sorting, and filtering; and create and modify fields including validation rules, captions, sizes, data types, auto-increment, default values, and input masks.

Create and modify queries

Create and run select, crosstab, parameter, and action queries and multiple-table queries with the correct join type; add calculated fields and aggregate (Totals) functions; and modify queries by showing or hiding fields, sorting, applying operators and criteria, filtering, and formatting fields.

Modify forms in Layout view

Configure form controls by adding, removing, and moving controls, setting control properties, and managing labels; and format forms by setting tab order, sorting records, controlling positioning, inserting form headers and footers, and inserting images, including linking subforms.

Modify reports in Layout view

Configure report controls by grouping and sorting records, adding controls and labels, and adding totals; and format reports through page setup, section placement, properties such as Can Grow, Force New Page, and Hide Duplicates, and conditional formatting.