Practice Test: Question Set - 18
1. Which of the following is a condensed form of standard generalized markup language?
- (A) HTML
- (B) XML
- (C) XSD
- (D) XSL
2. A(n) _________ is an image control that displays in the background of a page on a form or report.
- (A) Legend
- (B) Icon
- (C) Logo
- (D) Watermark
3. A Smart Tag can be set using the ________ tab in the property sheet.
- (A) Format
- (B) Tag
- (C) View
- (D) Data
4. A summary query can be created by adding which row to the design grid of a select query?
- (A) Arguments
- (B) Group
- (C) Summary
- (D) Total
5. What does an inner join display?
- (A) Records
from the second recordset and only records from the first recordset where the
common fields are equal
- (B) Records
from the first recordset and only records from the second recordset where the
common fields are equal
- (C) Records that
have the same value in the common field
- (D) Records from
the first recordset only
6. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
- (A) Datasheet
- (B) Justified
- (C) Stacked
- (D) Tabular
7. Which of the following search criteria is invalid?
- (A) $45*
- (B) *cal*
- (C) D*m??
- (D) AS150*
8. What type of relationship is created when you select a primary key in both related tables?
- (A) One-To-One
- (B) Indeterminate
- (C) One-To-Many
- (D) Many-To-Many
9. Which of the following field properties displays a model or pattern for entering data?
- (A) Field Size
- (B) Format
- (C) Input Mask
- (D) Validation
Rule
10. Which of the following functions CANNOT be used in the Totals row?
- (A) Average
- (B) Count
- (C) Maximum
- (D) Round
11. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
- (A) Press
[Ctrl]+[C] and [Ctrl]+[V]
- (B) Right-click,
choose from the shortcut menu Copy and Paste
- (C) Press
[Ctrl]+[+] and [Ctrl]+[-]
- (D) From the
ribbon, select Copy and Paste
12. ________ is the clear leader for personal databases.
- (A) Microsoft
Access
- (B) Microsoft
FoxProv
- (C) Borland
dBase
- (D) MySQL
13. The command center of access file that appears when you create or open the MS Access database file.
- (A) Database
window
- (B) Query window
- (C) Design view
window
- (D) Switchboard
14. What are the columns in a Microsoft Access table called?
- (A) Rows
- (B) Records
- (C) Fields
- (D) Columns
15. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
- (A) You need to
delete the whole table. There is no method to remove a particular field only
- (B) Delete all
the fields from third downwards and reenter the required fields again
- (C) Select the
third column in datasheet view then delete
- (D) Select the
third row in table design view then delete
Next Tests: