In the form wizard dialog box, the fields from the selected table are displayed in this list box.
A. All fields
B. All records
C. Available records
D. Available fields
Select an option to see the answer and solution.
To store your picture in a database requires a(n) __________ field.
A. BLOB
B. text
C. image
D. logical
Select an option to see the answer and solution.
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
A. 7
B. 17
C. 60
D. Not enough information to tell
Select an option to see the answer and solution.
If a color property contains "#336699", how many blue units are in the color?
Select an option to see the answer and solution.
Which colors are used to define a custom color?
A. Red, Blue, Yellow
B. Red, Green, Blue
C. Blue, Green, Orange
D. Green, Orange, Violet
Select an option to see the answer and solution.
Some rules are set in databases to check and permit only correct values. What is this feature called?
A. Data verification
B. Auditing
C. Data filtering
D. Data validation
Select an option to see the answer and solution.
We can remove a relationship defined between two tables by
A. From Edit menu choose Delete Relationship
B. Select the relationship line and press Delete
C. Choose Delete option from Relationship menu
D. All of above
Select an option to see the answer and solution.
The option button ________ identifies each button or check box in an option group.
A. event
B. frame
C. label
D. value
Select an option to see the answer and solution.
The __________ is the software tool to store or access data.
A. table
B. DBMS
C. query
D. report
Select an option to see the answer and solution.
In Access to Increase the height of the selected control
A. SHIFT+RIGHT ARROW
B. SHIFT+DOWN ARROW
C. DOWN ARROW or CTRL+DOWN ARROW
D. None of these
Select an option to see the answer and solution.
Which function extracts the name of the month from a date/time value?
A. Month
B. MonthName
C. MonthLabel
D. MonthValue
Select an option to see the answer and solution.
Which of the following is not a form style available in the form wizard dialog box.
A. Blends
B. Standard
C. Stone
D. Highlights
Select an option to see the answer and solution.
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
A. File menu
B. View menu
C. Database menu
D. Tools menu
Select an option to see the answer and solution.
How can you display sales grouped by country, region, and salesperson, all at the same time?
A. Use the Sort Descending command.
B. Use the Pivot table view command
C. Use the find command on specified groups
D. All of above
Select an option to see the answer and solution.