Vidyalelo
Computer Fundamentals · all questions

MS Access
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

514

Questions

8/26

Page

Pick an option on a question to see the right answer and solution.

A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.

Select an option to see the answer and solution.

In one-to-many relationship the table in 'one' side is called _______ and on 'many' side is called _______

Select an option to see the answer and solution.

Database properties do NOT include ___________.

Select an option to see the answer and solution.

Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.

Select an option to see the answer and solution.

A collection of related records in database is known as a

Select an option to see the answer and solution.

How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

Select an option to see the answer and solution.

In Access to increase the width of the selected control

Select an option to see the answer and solution.

Saving a database in access is done

Select an option to see the answer and solution.

What is the maximum length a text field can be?

Select an option to see the answer and solution.

This query wizard will create a select query.

Select an option to see the answer and solution.

in a relational schema, each tuple is divided into fields called

Select an option to see the answer and solution.

Which is NOT an option of the Picture Size Mode property?

Select an option to see the answer and solution.

To print information from a table, the __________ tool is the best choice.

Select an option to see the answer and solution.

What data type should yo choose for a zip code field in a table?

Select an option to see the answer and solution.

Which control types is most often associated with a bound control?

Select an option to see the answer and solution.

The most popular commercial DBMS.

Select an option to see the answer and solution.

Which of the following statements regarding charts is incorrect?

Select an option to see the answer and solution.

To apply an AutoFormat to an entire Form, what must you select first?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which of the following views enables users to create and modify the sections of a form?

Select an option to see the answer and solution.