MS Access Practice Set-1 | Free MCQ Quiz

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

What is the corresponding text for the <#1/1/95# validation rule setting?

Unlike text data type, this can store up to maximum of 65, 535 characters.

In a database table, the category of information is called ____________

According to access help, what’s a good way to design a database?

Which of the following is not a legitimate section for form objects?

The three parts of an IIF function are separated by _____.

Which of the following queries modifies fields not records?

What is the use of Cascade Delete Option in MS Access?

Which of the following expresses correct order?

A file containing relatively permanent data is

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

Which of the following Data Type is used to store picture in MS Access

__________ is the clear leader for personal databases.

When entering field name, how many characters you can type in maximum?

The result of a query is displayed in a

You can move between fields in a form by using any of these keys except

To create queries in Access

Which of the following database objects can have more than one Group Header/Footer section?

Data can be import into Access Database from

Which Form tool creates a new form that show both a form and datasheet views?

In access, this displays the results of a calculation in a query

Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

When creating a new table which method can be used to choose fields from standard databases and tables

A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting record set have?

In Access 2007, to make changes in the Trust Center, you need to go to the ____.

Which of the following is not a view for interacting with a form object?

Which data type is better to use for storing the price of an item?

Which major database object stores all data?

To create primary key for a table when in design view

A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

What is the maximum length a text field can be?

The page count of a report can be determined by clicking the _______ button.

Both conditions display on the same row in the design grid when ___operator is in use

What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

What is the first step in creating a form or report with the form wizard or report wizard?

Which of the following Format supports for Data Type Yes/No?

Which control does access use to link data access page components to Access data?

A part of database that stores only one type of data is

Queries can be created in Access by

Which of the following data types automatically generates a consecutive number?

A database can be best described as

What is the propose to a sub datasheet?

Query design window has two parts. The upper part shows

Which of the following methods CANNOT be used to delete records from a table?

Which of the following is not a valid Data Type in MS Access?

In a module, a(n) _______ is a series of commands and properties that perform a specific task.