MS Access MCQs

Question 1

It is an association established between common fields of two tables.

Accepted Answer

relationship

Answer

line

Answer

primary key

Answer

records

Question 2

In a query, which row do you need to place wildcards to affect a parameter?

Accepted Answer

Criteria

Answer

Arguments

Answer

Fields

Answer

Tables

Question 3

To create a new table, in which method you don't need to specify the field type and size?

Accepted Answer

Create Table by Entering data

Answer

Create table in Design View

Answer

Create Table using wizard

Answer

All of above

Question 4

To assign a macro to an event, users need to open the form in Design View.

Accepted Answer

event

Answer

property

Answer

title

Answer

macro

Question 5

A DBMS that runs on many different operating systems is said to be __________.

Accepted Answer

platform independent

Answer

scalable

Answer

robust

Answer

distributed

Question 6

HSAM stands for ________

Accepted Answer

Hierarchic Sequential Access Method

Answer

Hierarchic Standard Access Method

Answer

Hierarchic Sequential and Method

Answer

Hierarchic Standard and Method

Question 7

What it is called to present information in a particular order based on numeric or alphabetical value?

Accepted Answer

Sorting

Answer

Searching

Answer

Arranging

Answer

Cropping

Question 8

A query summarizes information in a grid, organized by regions and months. Which type of query is this?

Accepted Answer

A cross tab query

Answer

An update query

Answer

A parameter query

Answer

An action query

Question 9

To create a table in Access

Accepted Answer

All of the above

Answer

Database should be created before create table

Answer

Table can be created using Table Templates

Answer

There must be at least one Primary key in a table