DeskReady
Sign inSign up free

Database

Practice for Access tests

Tables, field rules, queries with totals and joins, relationships, forms and reports.

0%
Start the course →Shortcut drills23 tasks · 3 free · unlock all

Records

0/1
  1. 1Add a record to a tableFreeStart →

Sorting and filtering

0/2
  1. 2Sort a tableFree
  2. 3Filter recordsFree

Editing records

0/2
  1. 4Edit a recordJob Test Prep
  2. 5Delete a recordJob Test Prep

Table design

0/7
  1. 6Set a primary keyJob Test Prep
  2. 7Change a field's data typeJob Test Prep
  3. 8Create a tableJob Test Prep
  4. 9Add a field to a tableJob Test Prep
  5. 10Set a default valueJob Test Prep
  6. 11Make a field requiredJob Test Prep
  7. 12Add a validation ruleJob Test Prep

Queries

0/8
  1. 13Create a query with criteriaJob Test Prep
  2. 14Query, filter and sort numbersJob Test Prep
  3. 15Query a date rangeJob Test Prep
  4. 16Query with OR criteriaJob Test Prep
  5. 17Query with a wildcardJob Test Prep
  6. 18Add a calculated fieldJob Test Prep
  7. 19Total with a Totals queryJob Test Prep
  8. 20Query two tables togetherJob Test Prep

Relationships

0/1
  1. 21Create a relationshipJob Test Prep

Forms

0/1
  1. 22Create a formJob Test Prep

Reports

0/1
  1. 23Create a grouped reportJob Test Prep