The result of a query is displayed in a
Which control does access use to link data access page components to Access data?
If you need to edit a relationship
What is an intersection of a row and a column?
Queries are based on this, allowing you to use a query as the source for forms and reports
Which of the following expresses correct order?
-
-
-
-
What is the process of eliminating redundant fields by separating data into tables called?
Which report section only prints one time at the end of the report?
-
-
-
-
What do you call a primary key field included in another table?
Which of the following database object can be used if you need to mail the invoice to customers?
A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
In access, the best types of queries to use for data analysis are:
The __________ performs document tracking.
The content and application of the Search tool CANNOT be retained when you __
This key uniquely identifies each record
Why you can rely on MCQ Sets to prepare your computer jobs exams?
When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z
A(n) _______ is major object that completes an action or a set of actions.
The command center of access file that appears when you create or open the MS Access database file.
Which of the following field properties displays a model or pattern for entering data?
The default and maximum size of text field in access
Which criteria do not return the position “Officer” as a match?
The ascending order of data hierarchy is?
Which object is used to create a form?
A summary query can be created by adding which row to the design grid of a select query?
Which is not a command that is selectable from right click menu of a field column?
Some rules are set in databases to check and permit only correct values. What is this feature called?
Which major database object stores all data?
This form displays multiple records, one per row, in the form window
The operation of checking input data against specified criteria is known as?
Which do you click to display the table\’s primary key and indexes in a separate window?
In Access 2007, to set a table to open as a document tab, you need to go to the ____.
What is a fast way t adjust the width of a column?
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 maximum length a text field can be?
Which of the following is not a section in report design window?
If a color property contains “#336699”, how many blue units are in the color?
Which Form tool creates a new form that show both a form and datasheet views?