Data Manipulation  «Prev  Next»

Access Data Type Usage - Exercise

Matching Data Types to Their Uses

Objective: Match Microsoft Access data types to their most appropriate real-world use.

Instructions

Click one data type in the left column, then click its best matching use in the right column. Your matches will appear in the “Your matches” list. Use Validate to check your work. When finished, click Submit to send your selections to the results page (which also shows the correct answers).

Exercise Scoring

You will receive 2 points for this exercise. The exercise is auto-scored; to receive full credit, click Submit.

Data types

  1. Text
  2. Memo (Long Text)
  3. Number
  4. Date/Time
  5. Currency
  6. AutoNumber
  7. Yes/No
  8. Hyperlink

Uses

  1. Notes on project progress
  2. Invoice number
  3. Project description
  4. Count of number of projects in table
  5. Estimated cost
  6. Time of meeting
  7. Company website address
  8. Indicator of whether this is the first project for this client

Your matches

Optional notes

If you want, you can paste your reasoning or a short summary below. This is optional and does not affect the auto-score.