Practice Test: Question Set - 28
1. In table design view, which key can be used to switch between the field names and properties panels?
- (A) F3
- (B) F4
- (C) F5
- (D) F6
2. A search value can be an exact value or it can be
- (A) Logical
operator
- (B) Relationship
- (C) Wild card
character
- (D) Comparison
operation
3. Database access levels are specified so as to define who can access what in a database. It is identified through
- (A) User id
- (B) Password
- (C) Status
- (D) None of
above
4. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
- (A) Text
- (B) Form
- (C) Label
- (D) Field
5. You can not import data into access database from
- (A) Dbase iii database
files
- (B) Excel
spreadsheets
- (C) Comma
delimited text files
- (D) None of the
above
6. The complete picture of data stored in database is known as
- (A) Record
- (B) Scheme
- (C) System
flowchart
- (D) Dbms
7. If a piece of data is stored in two places in the database, then a
- (A) Storage
space is wasted
- (B) Changing the
data is one spot will cause data inconsistency
- (C) It can be
more easily accessed
- (D) Both ‘a’ and
‘b’
8. The filter by selection feature allows you to filter:
- (A) Those
records that match an entity in a field
- (B) Records
based on a criterion you specify
- (C) Records that
meet any of several criteria you specify
- (D) All of above
9. A small button with three dots usually displayed at the right of field properties box
- (A) Make button
- (B) Expression
button
- (C) Build button
- (D) None of
above
10. Which of the following is not a field type in Access?
- (A) Memo
- (B) Hyperlink
- (C) OLE Object
- (D) Lookup Wizard
11. What is the maximum length a text field can be?
- (A) 120
- (B) 255
- (C) 265
- (D) 75
12. Which criteria return only those addresses beginning with the letter “K”?
- (A) address =
“K”
- (B) address =
“K*”
- (C) address =
“K?”
- (D) address =
“K#”
13. Which of the following is use to get data from user?
- (A) Query
- (B) Pages
- (C) Form
- (D) Report
14. A(n)_______ is a major object that can run independent of a control.
- (A) Event
- (B) Property
- (C) Procedure
- (D) Macro
15. In a query, what symbol is used to surround a parameter\’s user prompt?
- (A) [ ]
- (B) { }
- (C) ” ”
- (D) ( )
Next Tests:
Blogger Comment
Facebook Comment