Deck 3: Access: Creating and Using a Database

Question 1

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

Answer 1

True

Question 2

The URL Address data type can store text that can be used as a hyperlink address.

Answer 2

False

Question 3

Figure 1-1 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.

Answer 3

False

Question 4

Replication is the storing of a piece of data in more than one place.

Question 5

A folder is a specific location on a storage medium.

Question 6

File names can be a maximum of 260 characters including the file extension.

Question 7

The Monetary data type is used for fields that contain only monetary data.

Question 8

Figure 1-1 As shown in the accompanying figure, you can use the Last record button to move to the last record in the table.

Question 9

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Question 10

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

Question 11

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

Question 12

In Access, table names can be up to 128 characters in length.

Question 13

One way to undo changes to a field is to click the Undo button on the Table Tools tab.

Question 14

Database Design Language (DBDL)is a programming language.

Question 15

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

Question 16

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

Question 17

In Access, the columns in a table are called records.

Question 18

In Datasheet view, a table is represented as a collection of rows and columns called a datasheet.

Question 19

Figure 1-1 As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

Question 20

A unique identifier also is called a primary key.

Question 21

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

A)Picture
B)Image
C)OLE Object
D)Bitmap

Question 22

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)AutoNumber
C)Incremental
D)AutoSequence

Question 23

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

A)attribute
B)record
C)field
D)column

Question 24

In Access, a(n)____ consists of a collection of tables, each of which contains information on a specific subject.

A)object
B)relation
C)database
D)tuple

Question 25

The Tools submenu on the Office menu provides commands to compact and repair a database.

Question 26

Grouping means creating separate collections of records sharing some common characteristic.

Question 27

Form view displays a single record at a time.

Question 28

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

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

Question 29

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

Question 30

____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.

A)Special
B)Reserved
C)Significant
D)Restricted

Question 31

To delete a field, right-click the column heading for the field, and then click Delete Column on the shortcut menu.

Question 32

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click Insert Field on the shortcut menu.

Question 33

A DataForm combines both a datasheet and a form.

Question 34

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

A)Alpha
B)Text
C)Normal
D)Lookup

Question 35

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

Question 36

To create a new database, use either the Blank Database option or a template.

Question 37

To use a template to create a table, click Create on the Ribbon and then click the Table Wizards button on the Create tab.

Question 38

The term database management system describes a collection of data organized in a manner that allows access, retrieval, and use of that data.

Question 39

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)Unlimited
B)Variable
C)Memo
D)Character

Question 40

Access is a ____.

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

Question 41

In the accompanying figure, the small box or bar to left of each field is called the ____.

A)row selector
B)field selector
C)field bar
D)current field bar

Question 42

When you maximize a window, the Maximize button changes to a(n)____ button.

A)Minimize
B)Return
C)Original
D)Restore Down

Question 43

Figure 1-2 In the accompanying figure, you would save the changes to the structure of the table by clicking the Save button on the ____.

A)title bar
B)status bar
C)Quick Access Toolbar
D)Home tab

Question 44

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.

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

Question 45

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

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

Question 46

To insert a field as the last field in a table, right-click the Add New Field column heading, click ____ on the shortcut menu, type the desired field name, click the down arrow, and then ensure the correct data type is already selected.

A)Add Column
B)Add Field
C)Rename Column
D)Rename New Field

Question 47

A saved database is referred to as a ____.

A)file
B)databook
C)DBMS
D)template

Question 48

To specify AutoCorrect rules and exceptions to the rules, click ____ on the Office Button menu and then click Proofing in the dialog box that displays.

A)Customize
B)Manage
C)Access Options
D)Grammar

Question 49

In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

A)subtype
B)tiered
C)contextual
D)sublevel

Question 50

You only can delete a primary key in ____ view.

A)Datasheet
B)Layout
C)Print Preview
D)Design

Question 51

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

A)Field1
B)ID
C)AutoCode
D)TableCode

Question 52

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

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

Question 53

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

A)Insert Field
B)Insert Column
C)Add Field
D)Add column

Question 54

To delete a record, click the Record selector for the record, and then press the ____ key(s).

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

Question 55

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

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

Question 56

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

A)New
B)Create
C)Add
D)Insert Table

Question 57

To change the save location for a database, click ____ in the Favorite Links section.

A)Save in
B)Searches
C)Desktop
D)Computer

Question 58

To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.

A)Cancel
B)Escape
C)Back
D)Undo

Question 59

When you create a new database, the name of the database appears on the ____ bar.

A)title
B)Windows
C)menu
D)scroll

Question 60

Figure 1-2 In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.

A)principal key
B)foreign key
C)primary key
D)main key

Question 61

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

A)Portrait/Landscape
B)Orientation
C)Landscape
D)Switch Orientation

Question 62

To show the symbol for the Euro instead of the dollar sign, change the ____________________ property for the field whose data type is Currency.

Question 63

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

Question 64

To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.

A)Insert
B)New Object
C)Create
D)Report

Question 65

Figure 1-3 In the accompanying figure, the entire area that displays on the screen is called the ____________________ work area.

Question 66

To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.

A)Preview/Print
B)Report View
C)Preview View
D)Print Preview

Question 67

A(n)___ combines both a datasheet and a form.

A)DataForm
B)simple form
C)AutoForm
D)split form

Question 68

If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.

A)Field Size
B)Format
C)Decimal
D)Caption

Question 69

Figure 1-3 In the accompanying figure, ____________________ for the open objects appear at the top of the work area.

Question 70

Figure 1-3 In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

Question 71

Figure 1-3 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.

Question 72

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

Question 73

Figure 1-3 In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

Question 74

To quit Access, click the ____ button on the right side of the Access title bar.

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

Question 75

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

A)Byte
B)Smallint
C)Least
D)Integer

Question 76

To back up a database, use the ____ command on the Office Button menu.

A)Manage
B)Data Tools
C)Backup
D)Options

Question 77

To hide the Navigation Pane, click the ____ Button.

A)Hide Navigation Pane
B)Shutter Bar Open/Close
C)Close Pane
D)Navigation Bar Show/Hide

Question 78

To add a record to a table, click the ____ record button.

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

Question 79

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

Question 80

Figure 1-3 In the accompanying figure, the ____________________ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.