Which of the following creates a drop down list of values to choose from?
Which of the following is NOT possible when printing Forms?
In MS Access, which data type is appropriate to store large text and numbers?
What determines a table’s sort order?
Which of the following is not a type of Microsoft Access database object?
__________ are documents that when filled in create records.
In a database table, the category of information is called __________
A(n) _______________ query locates data from one or more tables.
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:
Which criteria do not return the position “Officer” as a match?
If you write “Like Su*” in criteria cell of FirstName field it will display
A primary key in any table has the properties
The ‘filter by selection’ allows you to filter those records
Which part of the IIF expression is the action performed if the true condition exists?
In a query, what symbol is used to surround a parameter\’s user prompt?
Which of the following database object produces the final result to present?
Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Which is not a view to display a table in Access?
Which of the following query type is best suitable to analyze data?
Which of the following is NOT true about background images?
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
In MS Access, OLE Object Data type can store
Access file operations can be found by clicking the ____.
In the Relationship window, related fields from each table are connected by a(n) _______________.
To create primary key for a table when in design view
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
Which part of the IIF expression is the action performed if the true condition exists?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
The three parts of an IIF function are separated by _____.
Following is not a database model
A(n) _____ is a control that, when clicked, executes an action or series of actions.
Which of the following is not a logical database structure?
Which colors are used to define a custom color?
Which of the following database object is created first before any other created?
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______.
Which is not an option for Filter on a text field?
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
In access, the best types of queries to use for data analysis are:
This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.