Question 1

In MS Access, what is a 'Form' used for?

Accepted Answer

A form in MS Access provides a customized interface for entering, viewing, and editing records from a table.

Question 2

Which MS Access object is used to retrieve specific data from one or more tables based on defined criteria?

Accepted Answer

A query filters and retrieves data from tables based on specified conditions and criteria.

Question 3

Which of the following is the primary purpose of MS Access?

Accepted Answer

MS Access is a database management system designed to store, organize, and retrieve data in tables using relationships.

Question 4

In MS Access, what is a 'Table'?

Accepted Answer

A table in MS Access is the basic data storage unit with rows representing records and columns representing fields.

Question 5

Which of the following is NOT a valid data type in MS Access?

Accepted Answer

MS Access supports Text, Number, Currency, Date/Time, and other data types, but Animation is not a valid data type.

Question 6

What is the function of a 'Primary Key' in an MS Access table?

Accepted Answer

A primary key is a field that uniquely identifies each record in a table and prevents duplicate entries.

Question 7

In MS Access, what does a one-to-many relationship between two tables mean?

Accepted Answer

A one-to-many relationship exists when one record in a primary table can be associated with multiple records in a related table.

Question 8

What is the function of a Primary Key in MS Access?

Accepted Answer

A Primary Key ensures that each record in a table has a unique identifier, preventing duplicate entries.

Question 9

Which MS Access object is used to input and modify data in a user-friendly way?

Accepted Answer

Forms provide an interface for users to enter, view, and edit data in a more organized and visual manner than tables.

Question 10

What is the primary purpose of MS Access?

Accepted Answer

MS Access is a relational database management system designed to store, organize, and retrieve data efficiently.

Question 11

Which of the following is the smallest unit of data organization in MS Access?

Accepted Answer

A field is a single cell containing one piece of data, representing the smallest unit of data organization in Access.

Question 12

In MS Access, what is a collection of related fields?

Accepted Answer

A record is a row in a table that contains related information about a single entity across multiple fields.

Question 13

Which object in MS Access is used to retrieve specific data based on criteria?

Accepted Answer

A query is used to search, filter, and retrieve data from one or more tables based on specified conditions.

Question 14

When creating a primary key in MS Access table design, which field property ensures that each record has a unique identifier?

Accepted Answer

Setting 'Indexed = Yes (No Duplicates)' on a field enforces uniqueness and creates a primary key constraint in MS Access.

Question 15

In MS Access, what is the maximum file size limit for a single database file in the default .accdb format?

Accepted Answer

MS Access .accdb format has a maximum file size limit of 2 GB per database file.

CAPF AC MS Access Basics

MS Access Basics — Practice Questions