Deck 1: Databases and Database Objects

Question 1

To define an additional field in Datasheet view, tap or click the ____ salumn heading.

A) New Field
B) Add Field
C) Click to Add
D) Insert Field

Answer 1

C

Question 2

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

Answer 2

D

Question 3

To change the name of a field, press and hold or right-click the salumn heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

A) Change salumn
B) Rename salumn
C) Change Field
D) Rename Field

Answer 3

D

Question 4

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

Question 5

In Access, table and field names can be up to ____ characters in length.

A) 256
B) 128
C) 64
D) 32

Question 6

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

Question 7

To insert a field between existing fields, press and hold or right-click the salumn heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

A) Insert salumn
B) Insert Field
C) Add salumn
D) Add Field

Question 8

____ 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

Question 9

Access is a ____.

A) word processing software tool
B) file management system
C) workbook management system
D) database management system

Question 10

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

Question 11

To delete a field in a table, press and hold or right-click the salumn heading for the field, and then tap or click ____ on the shortcut menu.

A) Remove Field
B) Delete Field
C) Delete salumn
D) Remove salumn

Question 12

A field whose data type is ____ can santain any characters.

A) Alpha
B) Character
C) Normal
D) Short Text

Question 13

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

Question 14

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

Question 15

A(n) ____ santains information about a given person, product, or event.

A) attribute
B) resard
C) field
D) salumn

Question 16

In a(n) ____ database such as those maintained by Access, a database sansists of a sallection of tables, each of which santains information on a specific subject.

A) tabular
B) resard
C) attribute
D) relational

Question 17

A field with the ____ data type can santain an attached file, such as an image, document, chart, or spreadsheet.

A) Attachment
B) File
C) Document
D) Extend

Question 18

A field with the ____ data type can store a unique sequential number that Access assigns to a resard. Access will increment the number by 1 as each new resard is added.

A) Sequential
B) ValueIncrement
C) Incremental
D) AutoNumber

Question 19

A(n) ____ data type can store a variable amount of text or sambination of text and numbers where the total number of characters may exceed 255.

A) Memo
B) Long Text
C) Variable
D) Character

Question 20

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

Question 21

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

Question 22

In the acsampanying figure, the Book Rep table displays in ____.

A) Structure view
B) Design view
C) Layout view
D) Table view

Question 23

To exit Access, tap or click the ____ button on the right side of the title bar.

A) Quit
B) Stop
C) End
D) Close

Question 24

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

Question 25

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

Question 26

In the acsampanying 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

Question 27

To import data to a table, tap or click the ____ tab on the ribbon.

A) DATABASE TOOLS
B) FILE
C) EXTERNAL DATA
D) IMPORT

Question 28

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

Question 29

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

Question 30

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

Question 31

To back up the database that is currently open, use the ____ sammand 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

Question 32

To specify Autosarrect 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

Question 33

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

Question 34

To delete a resard, tap or click the resard selector for the resard, and then press the ____ key(s).

A) CTRL+DELETE
B) CTRL+Y
C) DELETE
D) CTRL+K

Question 35

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

Question 36

You can place an insertion point by tapping or clicking in the field or by pressing ____.

A) F2
B) F3
C) F4
D) F5

Question 37

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

Question 38

To sampact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

A) Restore
B) Fix
C) sampaction
D) sampact & Repair

Question 39

To add a resard to a table, tap or click the ____ resard button.

A) Add New
B) New (blank)
C) Last
D) Insert (New)

Question 40

In the acsampanying 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

Question 41

In Datasheet view, a table is represented as a sallection of rows and salumns called a list.

Question 42

One way to undo changes to a field is to click the Undo button on the status bar.

Question 43

A unique identifier also is called a primary key.

Question 44

As shown in the acsampanying figure, you can use the Last resard button to move to the last resard in the table.

Question 45

In Access, the salumns in a table are called resards.

Question 46

As shown in the acsampanying figure, you can move to the end of a table to a position for entering a new resard by clicking the Insert resard Navigation button.

Question 47

Modified Multiple Choice The Access window sansists of a variety of samponents. These include the ____.

A) Navigation Pane
B) santent pane
C) Object tabs
D) Quick Access Toolbar

Question 48

The Character data type is used for a field that can store a variable amount of text or sambinations of text and numbers where the total number of characters may exceed 255.

Question 49

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Question 50

As shown in the acsampanying figure, you can move to the first resard in a table by clicking the Start resard Navigation button.

Question 51

The Navigation Pane santains a list of all the objects in the database.

Question 52

Modified Multiple Choice Field names cannot santain ____.

A) square brackets ([ ])
B) periods (.)
C) hyphens (-)
D) accent graves (')

Question 53

The AutoError sarrection feature of Access sarrects sammon data entry errors.

Question 54

Fields that santain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

Question 55

Modified Multiple Choice You can create a table in ____.

A) Design view
B) Blank view
C) Layout view
D) Datasheet view

Question 56

In Access, field names cannot santain digits.

Question 57

When Access first creates a database, it automatically creates a table.

Question 58

Modified Multiple Choice 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

Question 59

The Currency data type is used for fields that santain only monetary data.

Question 60

Modified Multiple Choice File names cannot santain a(n) ____.

A) question mark (?)
B) salon (:)
C) space
D) underssare (_)

Question 61

A field that has the Calculated data type can store a unique sequential number that Access assigns to a resard.

Question 62

Changing the salumn width in a datasheet changes the structure of a table.

Question 63

A(n) ____________________ santains a specific piece of information within a resard.

Question 64

To change the name of a field, press and hold or right-click the salumn heading for the field, and then tap or click Rename Field on the shortcut menu.

Question 65

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Question 66

Redundancy means storing the same fact in more than one place.

Question 67

To delete a field, press and hold or right-click the salumn heading for the field, and then tap or click Remove Field on the shortcut menu.

Question 68

To print a wide database table, a table whose santents do not fit on the screen, you will need portrait orientation.

Question 69

Landscape orientation means the printout is across the length (height) of the page.

Question 70

A unique identifier also is called a(n) ____________________.

Question 71

Layout view shows a report on the screen and allows the user to make changes to the report.

Question 72

Form view displays a single resard at a time.

Question 73

To preview and then print the santents of a table, use Table Preview.

Question 74

In the acsampanying figure, the ____________________ Pane santains a list of all the objects in the database.

Question 75

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Question 76

To insert a field between existing fields, press and hold or right-click the salumn heading for the field that will follow the new field, and then tap or click Insert salumn on the shortcut menu.

Question 77

The term list database describes a database that sansists of a sallection of tables, each of which santains information on a specific subject.

Question 78

The rows in the tables are called ____________________.

Question 79

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions sancerning the data in the database; and create forms and reports using the data.

Question 80

The DATABASE TOOLS tab provides sammands to save a database with another name.