PITS MS Access Quiz

MS Access is classified as a:

• Spreadsheet software

• Database management system

• Word processor

• Presentation software

Which of the following is a unique identifier for a record in a table?

• Field size

• Data type

• Primary key

• Caption

A collection of related records in Access is known as a:

• Form

• Table

• Query

• Report

Which table view allows you to define fields, data types, and properties?

• Datasheet View

• Layout View

• Design View

• Report View

Which data type is suitable for storing price values in Access?

• Text

• Memo

• Currency

• Date/Time

Which property ensures that no blank entries are allowed in a field?

• Default value

• Required

• Caption

• Validation rule

Which Access object is used to display and enter data graphically?

• Report

• Query

• Form

• Macro

Which Access feature reduces redundant data across tables?

• Normalization

• Sorting

• Filtering

• Importing

What does a query primarily do?

• Store raw data

• Ask questions about data

• Print documents

• Format tables

Which query type allows input criteria at runtime?

• Select Query

• Crosstab Query

• Parameter Query

• Update Query