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

17/26

Page

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

Using the keyword _______________ will return records in which the field value equals a defined text.

Select an option to see the answer and solution.

In Datasheet View, what appears at the top of each column?

Select an option to see the answer and solution.

In MS Access "Hyperlink" Data Type can store

Select an option to see the answer and solution.

A database language concerned with the definition of the whole database structure and schema is ________

Select an option to see the answer and solution.

In Access press ALT+F11 to

Select an option to see the answer and solution.

Which of the following queries can create a table?

Select an option to see the answer and solution.

Data can be import into Access Database from

Select an option to see the answer and solution.

Where can you find the undo command in Access?

Select an option to see the answer and solution.

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

Select an option to see the answer and solution.

In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report

Select an option to see the answer and solution.

The ability of a database to grow as the data tracking needs grow is its __________.

Select an option to see the answer and solution.

Which of the following is not one of the methods available in the new query dialog box to create queries?

Select an option to see the answer and solution.

Which of the following statements about calculated fields is NOT true?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

In Access press PAGE UP

Select an option to see the answer and solution.

Which of the following is a method to create a new table in MS Access?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.

Select an option to see the answer and solution.

A _______ name must be unique within a database

Select an option to see the answer and solution.

Queries can be created in Access by

Select an option to see the answer and solution.