Quiz 1: Access: Databases and Database Objects: an Introduction
Computing
Q 1Q 1
Access is a ____.
A)word processing software tool
B)file management system
C)workbook management system
D)database management system
Free
Multiple Choice
D
Q 2Q 2
In a(n)____ database such as those maintained by Access,a database consists of a collection of tables,each of which contains information on a specific subject.
A)tabular
B)record
C)attribute
D)relational
Free
Multiple Choice
D
Q 3Q 3
A(n)____ contains information about a given person,product,or event.
A)attribute
B)record
C)field
D)column
Free
Multiple Choice
B
Q 4Q 4
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
A)Reserved
B)Restricted
C)Significant
D)Tagged
Free
Multiple Choice
Free
Multiple Choice
Q 6Q 6
A field whose data type is ____ can contain any characters.
A)Alpha
B)Character
C)Normal
D)Short Text
Free
Multiple Choice
Q 7Q 7
A(n)____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
A)Memo
B)Long Text
C)Variable
D)Character
Free
Multiple Choice
Q 8Q 8
A field with the ____ data type can store a unique sequential number that Access assigns to a record.Access will increment the number by 1 as each new record is added.
A)Sequential
B)ValueIncrement
C)Incremental
D)AutoNumber
Free
Multiple Choice
Q 9Q 9
A field with the ____ data type can contain an attached file,such as an image,document,chart,or spreadsheet.
A)Attachment
B)File
C)Document
D)Extend
Free
Multiple Choice
Q 10Q 10
A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table.
A)Illustration
B)Image
C)Bitmap
D)OLE object
Free
Multiple Choice
Q 11Q 11
A field whose data type is ____ can store text that can be used as a hyperlink address.
A)URL
B)Web
C)Placeholder
D)Hyperlink
Free
Multiple Choice
Q 12Q 12
When you assign a(n)____ to a field,Access will display the value you assign,rather than the field name,in datasheets and in forms.
A)alternate
B)caption
C)abbreviation
D)tag
Free
Multiple Choice
Q 13Q 13
When you create a table in Datasheet view,Access automatically adds a field called ____ as the first field in the table.
A)AutoNumber
B)AutoFill
C)ID
D)PrimaryID
Free
Multiple Choice
Q 14Q 14
To define an additional field in Datasheet view,tap or click the ____ column heading.
A)New Field
B)Add Field
C)Click to Add
D)Insert Field
Free
Multiple Choice
Q 15Q 15
To undo the most recent change to a table structure,tap or click the ____ button on the Quick Access Toolbar.
A)Cancel
B)Reverse
C)Back
D)Undo
Free
Multiple Choice
Q 16Q 16
To delete a field in a table,press and hold or right-click the column heading for the field,and then tap or click ____ on the shortcut menu.
A)Remove Field
B)Delete Field
C)Delete Column
D)Remove Column
Free
Multiple Choice
Q 17Q 17
To change the name of a field,press and hold or right-click the column heading for the field,tap or click ____ on the shortcut menu,and then type the desired field name.
A)Change Column
B)Rename Column
C)Change Field
D)Rename Field
Free
Multiple Choice
Q 18Q 18
To show the symbol for the Euro instead of the dollar sign,change the ____ property for the field whose data type is Currency.
A)Field Size
B)Format
C)Caption
D)Description
Free
Multiple Choice
Q 19Q 19
To insert a field between existing fields,press and hold or right-click the column heading for the field that will follow the new field,and then tap or click ____ on the shortcut menu.
A)Insert Column
B)Insert Field
C)Add Column
D)Add Field
Free
Multiple Choice
Q 20Q 20
To open a table in Design view,press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu
A)Table Design
B)Layout View
C)Structure View
D)Design View
Free
Multiple Choice
Q 21Q 21
-In the accompanying figure,the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.
A)principal key
B)foreign key
C)main key
D)primary key
Free
Multiple Choice
Q 22Q 22
-In the accompanying figure,the Book Rep table displays in ____.
A)Structure view
B)Design view
C)Layout view
D)Table view
Free
Multiple Choice
Q 23Q 23
-In the accompanying figure,the small box or bar to the left of each field is called the ____.
A)row selector
B)field selector
C)field bar
D)current field bar
Free
Multiple Choice
Q 24Q 24
To add a record to a table,tap or click the ____ record button.
A)Add New
B)New (blank)
C)Last
D)Insert (New)
Free
Multiple Choice
Q 25Q 25
You can place an insertion point by tapping or clicking in the field or by pressing ____.
A)F2
B)F3
C)F4
D)F5
Free
Multiple Choice
Q 26Q 26
To delete a record,tap or click the record selector for the record,and then press the ____ key(s).
A)CTRL+DELETE
B)CTRL+Y
C)DELETE
D)CTRL+K
Free
Multiple Choice
Q 27Q 27
To specify AutoCorrect rules and exceptions to the rules,tap or click FILE to open the Backstage view,tap or click ____ ,and then tap or click Proofing in the dialog box that displays.
A)Customize
B)Manage
C)Options
D)Grammar
Free
Multiple Choice
Q 28Q 28
To save the changes to the layout of a table,tap or click the Save button on the ____.
A)status bar
B)TABLE TOOLS tab
C)Navigation Pane
D)Quick Access Toolbar
Free
Multiple Choice
Q 29Q 29
To change the print orientation from portrait to landscape,tap or click the ____ button on the PRINT PREVIEW tab.
A)Portrait/Landscape
B)Orientation
C)Switch Orientation
D)Landscape
Free
Multiple Choice
Q 30Q 30
To import data to a table,tap or click the ____ tab on the ribbon.
A)DATABASE TOOLS
B)FILE
C)EXTERNAL DATA
D)IMPORT
Free
Multiple Choice
Q 31Q 31
To open the Navigation Pane,tap or click the ____ Button.
A)Open Navigation Pane
B)Open Pane
C)Shutter Bar Open/Close
D)Navigation Bar Show/Hide
Free
Multiple Choice
Q 32Q 32
To create a query using the Query Wizard,tap or click ____ on the ribbon and then click the Query Wizard button.
A)CREATE
B)INSERT
C)NEW OBJECT
D)REPORT
Free
Multiple Choice
Q 33Q 33
To view the results of a saved query,press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.
A)Datasheet View
B)Open
C)Results View
D)Run
Free
Multiple Choice
Q 34Q 34
To change the design of a query,press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
A)Open
B)SQL
C)Query Window
D)Design View
Free
Multiple Choice
Q 35Q 35
To create an initial report that can be modified in Layout view,tap or click ____ on the CREATE tab.
A)Layout
B)Report Layout
C)Report
D)Simple Report
Free
Multiple Choice
Q 36Q 36
To exit Access,tap or click the ____ button on the right side of the title bar.
A)Quit
B)Stop
C)End
D)Close
Free
Multiple Choice
Q 37Q 37
To back up the database that is currently open,use the ____ command on the Save As tab in the Backstage view.
A)Close and Back Up
B)Back Up Current
C)Save As Back Up
D)Back Up Database
Free
Multiple Choice
Q 38Q 38
To compact and repair a database,tap or click the ___ button in the Info gallery in the Backstage view.
A)Restore
B)Fix
C)Compaction
D)Compact & Repair
Free
Multiple Choice
Q 39Q 39
To delete a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
A)Erase
B)Trash
C)Delete
D)Remove
Free
Multiple Choice
Q 40Q 40
To rename a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
A)New Name
B)Redefine
C)Rename
D)Save Name
Free
Multiple Choice
Q 41Q 41
File names cannot contain a(n)____.
A)question mark (?)
B)colon (:)
C)space
D)underscore (_)
Free
Multiple Choice
Q 42Q 42
Field names cannot contain ____.
A)square brackets ([ ])
B)periods (. )
C)hyphens (-)
D)accent graves (')
Free
Multiple Choice
Q 43Q 43
The Access window consists of a variety of components.These include the ____.
A)Navigation Pane
B)Content pane
C)Object tabs
D)Quick Access Toolbar
Free
Multiple Choice
Q 44Q 44
A field with a Yes/No data type can store only one of two values.The choices are ____.
A)True/False
B)One/Zero
C)Yes/No
D)On/Off
Free
Multiple Choice
Free
Multiple Choice
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 51Q 51
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
Free
True False
Q 52Q 52
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
Free
True False
Free
True False
Q 54Q 54
The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
Free
True False
Free
True False
Free
True False
Free
True False
Q 58Q 58
-As shown in the accompanying figure,you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button.
Free
True False
Q 59Q 59
-As shown in the accompanying figure,you can use the Last record button to move to the last record in the table.
Free
True False
Q 60Q 60
-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.
Free
True False
Free
True False
Free
True False
Q 63Q 63
To print a wide database table,a table whose contents do not fit on the screen,you will need portrait orientation.
Free
True False
Free
True False
Free
True False
Free
True False
Q 67Q 67
Standard properties are associated with all Microsoft Office documents and include author,title,and subject.
Free
True False
Free
True False
Q 69Q 69
Each customer has one book rep,but each book rep can have many customers.This is an example of a one-to-many relationship.
Free
True False
Free
True False
Q 71Q 71
The term list database describes a database that consists of a collection of tables,each of which contains information on a specific subject.____________________
Free
Essay
Q 72Q 72
A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.____________________
Free
Essay
Q 73Q 73
To change the name of a field,press and hold or right-click the column heading for the field,and then tap or click Rename Field on the shortcut menu.____________________
Free
True False
Q 74Q 74
To insert a field between existing fields,press and hold or right-click the column heading for the field that will follow the new field,and then tap or click Insert Column on the shortcut menu.____________________
Free
Essay
Q 75Q 75
To delete a field,press and hold or right-click the column heading for the field,and then tap or click Remove Field on the shortcut menu.____________________
Free
Essay
Q 76Q 76
A(n)____________________ is software that can be used to create a database;add,change,and delete data in the database;ask and answer questions concerning the data in the database;and create forms and reports using the data.
Free
Essay
Free
Essay
Free
Essay
Free
Essay
Q 80Q 80
-In the accompanying figure,the ____________________ Pane contains a list of all the objects in the database.
Free
Essay
Q 81Q 81
-In the accompanying figure,the words Datasheet View at the lower left of the screen appear on the ____________________.
Free
Essay
Q 82Q 82
-In the accompanying figure,the entire area that displays on the screen is called the ____________________ work area.
Free
Essay
Q 83Q 83
-In the accompanying figure,____________________ for the open objects appear at the top of the work area.
Free
Essay
Q 84Q 84
-In the accompanying figure,the database name,Bavant Publishing appears on the ____________________.
Free
Essay
Q 85Q 85
-In the accompanying figure,the buttons at the bottom-right edge of the screen are ____________________ buttons,which you use to change the view that is currently displayed.
Free
Essay
Free
Essay
Q 87Q 87
The Short Text data type replaces the ____________________ data type in previous editions of Access.
Free
Essay
Free
Essay
Q 89Q 89
To define an additional field in Datasheet view,tap or click the ____________________ column heading,select the data type,and then type the field name.
Free
Essay
Q 90Q 90
To insert a field between existing fields,press and hold or right-click the column heading for the field that will follow the new field,and then tap or click ____________________ on the shortcut menu.
Free
Essay
Q 91Q 91
Society encourages users to contribute to ____________________ computing,which involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.
Free
Essay
Q 92Q 92
A hard copy or ____________________ is information that exists on a physical medium such as paper.
Free
Essay
Q 93Q 93
____________________ refers to the process of determining the tables and fields that make up the database.
Free
Essay
Q 94Q 94
The determination of database requirements is part of a process known as ____________________.
Free
Essay
Q 95Q 95
Designing to omit ____________________ will help to produce good and valid database designs.
Free
Essay
Q 96Q 96
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
Free
Essay
Q 97Q 97
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.
Free
Essay
Q 98Q 98
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can contain any characters and the total numbers of characters cannot exceed 255.
Free
Essay
Q 99Q 99
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can contain only monetary data.
Free
Essay
Q 100Q 100
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Field can store a unique sequential number that Access assigns to the record.
Free
Essay
Q 101Q 101
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-A commonly accepted shorthand representation for showing the structure of a relational database.
Free
Essay
Q 102Q 102
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-View that shows a report as it will appear when printed.
Free
Essay
Q 103Q 103
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-View that shows a report on the screen and allows changes to the report.
Free
Essay
Q 104Q 104
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-View that shows a report on the screen and does not allow changes to the report.
Free
Essay
Q 105Q 105
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.AutoNumber
f.Currency
b.Layout view
g.Metadata
c.DBDL
h.Print Preview
d.Report view
i.Short Text
e.Long Text
j.status bar
-Can include such information as the file's author,title,or subject.
Free
Essay