The ‘filter by selection’ allows you to filter those records
In Datasheet View, what appears at the top of each column?
A __ name must be unique within a database
Which part of the IIF expression is the action performed if the true condition exists?
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:
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______
The complete information about an entity in a database is called
It is a database object to view, change, and analyze data in different ways
A __________ enables you to view data from a table based on a specific criterion
What is the memo data type field used for?
Which function evaluates a “true/false” expression and then performs one of two actions?
This is the stage in database design where one gathers and list all the necessary fields for the database project.
Which field type will you select when creating a new table if you require to enter long text in that field?
What is the use of description field in table design window?
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
Which of the following statements does NOT hold true for the Top Values property?
Which data type is better to use for storing the price of an item?
How can you add a table to the relationship window?
In MS Access, OLE Object Data type can store
Which data type is better to use for storing the price of an item?
Which is the valid data type in Access?
In MS Access query, which of the fields is derived field? Query: SELECT product.qty AS Quantity, product.rate AS Rate, product.qty*product.rate AS Amount FROM product;
In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
To duplicate a controls formatting you can use___
Database properties do NOT include ___________.
What happens when you add the asterisk (*) from any field list ot a query?
Which of the following creates a drop down list of values to choose from a list?
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
Which function can not be used for calculated controls in a report?
If a piece of data is stored in two places in the database, then a
Which of the following is not one of the methods available in the new query dialog box to create queries?
To achieve and effect when you are entering criteria in a query design window
In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Query can be use to select data from
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
In Access 2007, to make changes in the Trust Center, you need to go to the ____.
If you need to edit a relationship
Query design window has two parts. The upper part shows
Saving a database in access is done