In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Which of the following statements about option group is incorrect?
Collection of related records in a database is known as
This data type allows alphanumeric characters and special symbols.
The arranging of data in a logical sequence is called
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
If you need to edit a relationship
The option button ____ identifies each button or check box in an option group.
In a database table, the category of information is called ____________.
What type of relationship is created when you select a primary key in both related tables?
Referential integrity cannot be set for _______________ relationships.
A(n) ____ in the Record Selector indicates a new record.
The command center of access file that appears when you create or open the MS Access database file.
Which of the following is not a database object in MS Access?
What is the difference between ‘Open’ and ‘Open Exclusively’?
Which of the following SQL query deletes Product table from Store database?
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
Which tool do you use to create a query object?
Search engines use a(n) __________ to automatically index sites.
If a color property contains “#336699”, how many blue units are in the color?
The Input Mask wizard does NOT include the ability to do which of the following?
To sort records in a table
In order to use dbms, it is important to understand
In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
How can you display pivot table report summary data in a currency format?
To create queries in access
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
Which of the following is the DBMS type
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______.
Which of the following statements does NOT hold true for the Top Values property?
What is a form in MS Access?
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
Which is not a view to display a table in Access?
which of the following is not a database object?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
-
-
-
-
What is the use of description field in table design window?
If you write criteria values vertically (one in a row) it will mean