Practice Test: Question Set - 13
1. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
- (A) Tabular
- (B) Justified
- (C) Columnar
- (D) Datasheet
2. This query wizard will create a select query.
- (A) Crosstab
- (B) Find
duplicates
- (C) Simple
- (D) Design view
3. In access, this view is used to create and modify the structure of a form.
- (A) Normal
- (B) Datasheet
- (C) Form design
- (D) Control
4. What is the use of description field in table design window?
- (A) The
description will be displayed on status bar when entering data in datasheet
view
- (B) The
description will be displayed on status bar when entering data in form
- (C) Both of
above
- (D) None of a
the above
5. Which of the following is not a section in report design window?
- (A) Report
header section
- (B) Page header
section
- (C) Summary
section
- (D) Report
footer section
6. Which of the following is not a data type?
- (A) Picture/graphic
- (B) Data/time
- (C) Text
- (D) Number
7. Data items groped together for storage purposes are called a
- (A) Record
- (B) Title
- (C) List
- (D) String
8. What are the columns in a Microsoft Access table called?
- (A) Rows
- (B) Fields
- (C) Cells
- (D) Records
9. According to access help, what’s a good way to design a database?
- (A) Start from
data access pages and work backward
- (B) Sketch the
design of your database using a pencil and paper
- (C) Use the
table analyzer to reverse-engineer your flat source data
- (D) None of
above
10. What data type should you choose for a zip code field in a table?
- (A) Text
- (B) Number
- (C) Memo
- (D) All of above
11. What is the purpose of the description column in table design view?
- (A) To define
the data type applied to each field within the table
- (B) To describe
the data that should be entered in each field
- (C) To enter
lookup data that the field should refer to
- (D) None of the above
12. Cascade delete option
- (A) Is used to
delete all the records of all tables in a database
- (B) Will repeat
the recent delete operation to all the records of current table
- (C) Is available
in Edit relationship dialog box which makes sure that all the related records
will be deleted automatically when the record parent table is deleted
- (D) None of
above
13. The third stage in designing a database is when we analyze our tables more closely and create a _________ between tables
- (A) Relationship
- (B) Join
- (C) Query
- (D) None of
these
14. 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
15. To duplicate a controls formatting you can use________
- (A) Manager
- (B) Wizard
- (C) Painter
- (D) Control
Next Tests: