MS Access MCQ with Answers

Set the record set type to snapshot

Use the compact and repair database tool

Create a replica of the database

All of the above

Sorting

Classifying

Reproducing

Summarizing

Start from data access pages and work backward

Sketch the design of your database using a pencil and paper

Use the table analyzer to reverse-engineer your flat source data.

None of above

Storage space is wasted

Changing the data is one spot will cause data inconsistency

It can be more easily accessed

Storage space is wasted and Changing the data is one spot will cause data inconsistency

Tables

Relations

Tuple

Tables and Relations