In Datasheet View, new records are added to a table ____.
Validation Rule in a field will
What is the use of Cascade Delete Option in MS Access?
A Smart Tag can be set using the _____ tab in the property sheet.
A global join will be created automatically when using tables in a(n) _____.
A __ name must be unique within a database
Which of the following functions is used to all the values in a numeric field?
Which is not an option for customizing a datasheet window?
Which of the following is not a section in report design window?
The __________ is the software tool to store or access data.
The quickest way to add a field to the selected fields list is to double-click its field name in this list.
The page count of a report can be determined by clicking the _______ button.
Why you can rely on MCQ Sets to prepare your computer jobs exams?
Which of the following is use to get data from user?
The ________ button on the tool box display data from a related table.
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Which of the following terms does not describe a database structure used by a dbms to link data from several files?
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
Which data type is better to use for storing the price of an item?
Relationship can be establish between two tables by
Saving a database in access is done
In table design view what are the first column of buttons used for
The _________ operator will cause a record to be selected only if two or more conditions are satisfied
In MS Access, AutoNumber Data Type
In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
Which of the following properties identifies the type of information stored in a field?
Which of the following statements does NOT hold true for the Top Values property?
In a database table, the category of information is called ____________.
What is the type of query that extracts data from a table and puts them into separate table?
In Access 2007, to make changes in the Trust Center, you need to go to the ____.
Which of the following statements does NOT hold true for the Top Values property?
A(n) _______________ query locates data from one or more tables.
Which of the following can be an example of a database?
What are the columns in a Microsoft Access table called?
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
Which data type is better to use for storing phone number in the following format “977-1-1234567”?
The default and maximum size of text field in access
What is the maximum length a text field can be?
Which of the following is the file extension for an Extensible Markup Language?