In Access 2007, to set a table to open as a document tab, you need to go to the ____.
What is the use of Referential Integrity in MS Access?
Which of the following views displays the field name, description, and properties of a table?
Which of the following can be an example of a database?
How can you display the related records from other tables in datasheet view?
What is an intersection of a row and a column?
Which of the following field properties is an expression that specifies criteria or requirements for entering data?
The__ button on the tool box display data from a related table
Which action will optimize your database performance?
You can enclose the prompt within square braces in criteria to create
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
On the property sheet, which of the following tabs contains the Caption property?
A subset of characters within a data field is known as
The Search tool CANNOT be used on which major Access object?
Following is not a database model
Macros can recover from _______ in a controlled manner.
Which of the following is not a legitimate section for form objects?
In a query, which row do you need to place wildcards to affect a parameter?
In a database table, the category of information is called ____________.
It is an association established between common fields of two tables.
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
Which control type do you use to create a calculated control?
What do you call a primary key field included in another table?
In a module, the VB Name used to display a warning query icon is _______.
A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
What is the maximum length a text field can be?
What MCQ Set offers for the candidates of computer jobs exams?
How do you filter by selection?
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
The complete picture of data stored in database is known as
Query can be use to select data from
Which is not an option for Filter on a text field?
All attachment fields display as a(n) ____ in Datasheet View.
The expression builder is an access tool that controls an expression___ for entering an expression
The complete information about an entity in a database is called
Which of the following types of joins displays records with the same value in the common field?
In an application created using the database wizard, the main menu is presented as a:
How can you define a field so that when entering data for that field it will display ****** instead of actual typed text