Multiple Choice Question for Microsoft Access || 2
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
11 This is the stage in database
design where one gathers and lists all the necessary fields for the database project.
A. data definition
B. data refinement
C. establishing relationship
D. none of the
above
12 The two form layout types will display
multiple records at one time are tabular and_
A. columnar
B. justified
C. date
sheet
D. pivot table
13 The size of a field with
Number data type can not be
A. 2
B. 4
C. 8
D. 16
14 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
15 The size of Yes No field is always
A. 1 bit
B. 1 byte
C. 1 character
D. 1 GB
16 This key uniquely
identifies each record
A. primary key
B. key record
C. unique key
D. field name
17 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
18 A
database language concerned with the definition of the whole database structure and
schema is
A. DCL
B. DML
C. DDL
D. All of above
19 When creating a new table which method can be used to choose fields from standard
databases and tables
A. CREATE TABLE in Design VIEW
B. CREATE TABLE using wizard
C. CREATE TABLE by Entering DATA
D. None of above
20 What happens when you release mouse pointer after you drop the primary key of a
table into foreign key of another table?
A. A relationship is created
B. Edit
relationship dialog box appears
C. Error occurs
D. Nothing happens