Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > AL1 C1 C2 > Flashcards

AL1 C1 C2 Flashcards

1
Q

When you delete a table from your computer’s hard drive, the message asking you to confirm the deletion does not display. Why?

A

Access automatically sends the deleted table to the Recycle Bin, where it can be retrieved.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Each field in a table must have a name that is

A

unique

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the first step in creating a table?

A

Determine the fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

To create a new database or open a previously created database, click the Windows Start button and then click the

A

Access tile

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does it mean when a pencil icon displays next to a field entry?

A

The record is being edited and the changes to the data have not yet been saved

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

When a database is being designed, one field in each table has an asterisk next to its name. That field is called the

A

primary key field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Use options in the _____ category in the More Fields button drop-down list to define a data type, assign a field name, and add a group of related fields.

A

Quick Start

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When you have a table open and click the Quick Print option in the Print backstage area, what happens?

A

The information in the table is sent to the printer without making any changes to the printer setup or the table formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

When you open a _____, it displays in _____ in the work area.

A

table; Datasheet view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What data type should you use for a field that will store telephone numbers?

A

Short Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following Access screen elements contains tabs with commands and buttons divided into groups?

A

ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Adjust field column widths in a table by selecting the columns and then _____ one of the selected column boundary lines.

A

double clicking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How can you print a table without the table name, date, and page number?

A

Remove the checkmark from the Print Headings option at the Page Setup dialog box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

To control what objects are shown in the Navigation pane, click which of the following?

A

the button on the menu bar containing the down arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A database is composed of a series of _____ used to enter, manage, view, and print data.

A

objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which of the following Access screen elements displays messages, the current view, and view buttons?

A

Status bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

To freeze a column, click in the column, click the _____ button, and then click _____ at the drop-down list.

A

More; Freeze Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the maximum number of characters that can be stored in a field of the Short Text data type?

A

255

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

A _____ displays data from a table or related tables that meets a conditional statement and/or performs calculations.

A

query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A relational database is a database with related

A

tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

If a new database is opened in the current Access window, what will happen?

A

the existing database will close

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Data in a database is organized into _____, which contain information for related items.

A

tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A field is one piece of information about a person, place, or item, and all the fields for one unit are considered a

A

record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Change a field name by _____ the name, clicking Rename Field at the shortcut menu, and then typing the new name.

A

right-clicking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

When a new field column is added in Datasheet view, where is it added?

A

to the right of existing fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

The Name & Caption button is in the _____ group on the _____ tab.

A

Properties; Table Tools Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

The _____ includes the First and Last record buttons, the Previous and Next record buttons, and the New (blank) record button.

A

Record Navigation Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Which of the following groups is not on the Print Preview tab?

A

Properties

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

When creating a table, you can provide additional information about a field as a caption and a(n)

A

description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

One method for deleting a record is

A

clicking the Delete button arrow on the Home tab and then clicking Delete Record.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

The _____ is the base upon which other objects are created.

A

table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

When a field in a column is active, the text typed in the Description text box displays

A

at the left side of the Status bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

A field name can contain up to _____ characters.

A

64

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

When working in a table, press the Tab key to make the next field active or press _____ to make the previous field active.

A

Shift + Tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

In Access, you can create a table in Datasheet view or in _____ view.

A

Design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

When moving a field column, begin by positioning the mouse pointer on the field name in the header row until the pointer displays as a

A

down-pointing black arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

When designing a database, the first principle is to reduce

A

redundant or duplicate information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

A _____allows fields and records to be presented in a layout different from the datasheet.

A

form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

To display a table in Print Preview, click the _____ option at the Print backstage area.

A

Print Preview

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

In which situation would you want to define a default value for a field in your table?

A

when most records are likely to contain the same field value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

By default, Access prints a table

A

in standard letter size

42
Q

Use the _____ and _____ features to prevent field columns from showing or to view two nonadjacent field columns for comparison.

A

hide; freeze

43
Q

If a value is not entered in a field, Access enters a

A

null value

44
Q

How are relationships indicated in the Relationships window?

A

A black line connects the table field list boxes

45
Q

To display a different subdatasheet, remove the subdatasheet first, before selecting the next subdatasheet. Do this by clicking the _____, pointing to Subdatasheet, and then clicking Remove.

A

More button

46
Q

If Cascade Update Related Fields is selected at the Edit Relationships dialog box and changes are made to the primary key field value in the primary table, Access will automatically _____ the matching value in the related table.

A

update

47
Q

In the Relationships window, what signifies the “one” side of a one-to-many relationship?

A

the number 1

48
Q

In defining a primary key, which step do you complete just before you click the Primary Key button?

A

Click the field

49
Q

Suppose that you have not yet established any relationships among your tables. What happens when you click the Relationships button?

A

The Show Table dialog box displays

50
Q

What are the two general categories of database management systems?

A

file management and relational database management systems

51
Q

When a table is opened, it is sorted by

A

the primary key field

52
Q

Data in a foreign key field _____ match data in the primary key field of the related table.

A

must

53
Q

File management systems are sometimes referred to as

A

flat file databases

54
Q

When a relationship is established between two tables, the primary key in one table is joined to the _____ key in the other table.

A

foreign

55
Q

In which situation would using a one-to-one relationship be helpful?

A

when you need to divide a large table with many fields into two separate tables

56
Q

If only Enforce Referential Integrity is selected at the Edit Relationships dialog box and the related table contains a record, then a _____ key field value in the primary table cannot be changed.

A

primary

57
Q

What is displayed in the three-row grid in the middle of the Edit Relationships dialog box?

A

the names of the fields to be used to join the tables

58
Q

Choosing Cascade Update Related Fields and Cascade Delete Related Records at the Edit Relationships dialog box will cause primary key updates and deletions in _____ to be made automatically in _____.

A

the primary table; the related table

59
Q

The _____ integrity rules ensure that a record added to a related table has a matching record in the primary table.

A

referential

60
Q

Where is the Primary Key button?

A

in the Tools group on the Table Tools Design tab

61
Q

In the Relationships window, what signifies the “many” side of a one-to-many relationship?

A

the infinity symbol (¥)

62
Q

How does joining tables help ensure data integrity?

A

by avoiding the need to enter the same data in multiple tables

63
Q

A table should be about _____ subject(s).

A

one

64
Q

Which of the following features is found in a relational database management system but not in a file management system?

A

the ability to define relationships between tables

65
Q

To close subdatasheets for all records, begin by clicking the _____ button.

A

More

66
Q

What is done at the Show Table dialog box?

A

Tables are added to the Relationships window

67
Q

Once a relationship is established between tables, clicking the Relationships button displays which of the following?

A

the Relationships window

68
Q

If a table has more than one relationship defined, clicking the expand indicator will display the

A

Insert Subdatasheet dialog box

69
Q

To edit a specific relationship, position the mouse pointer _____, click the right mouse button, and then click the Edit Relationship option.

A

on the middle portion of the black line that connects the related tables

70
Q

In a one-to-many relationship, the table containing the “one” is referred to as the _____ table.

A

primary

71
Q

What happens when you position the mouse pointer on the join line connecting related tables, click the right mouse button, and then click Delete at the shortcut menu?

A

You are prompted to confirm the deletion

72
Q

In defining a one-to-many relationship between two tables, what is the next step after placing the two tables in the Relationships window?

A

Drag the common field from the primary table to the related table

73
Q

Access is a(n) _____ database management system in which relationships are defined between sets of data.

A

relational

74
Q

When you perform a join, you are

A

establishing a relationship between tables

75
Q

A database table can contain which of the following two types of key fields?

A

primary and foreign

76
Q

To print a report showing the relationships among tables, click the Relationship Report button, which is in the

A

Tools group in the Relationships window

77
Q

To display subdatasheets for all records in the primary table, begin by clicking the

A

More button in the Records group on the Home tab

78
Q

When a relationship is established between two tables, a subdatasheet displays

A

records in related tables

79
Q

What happens if a primary key field is left blank?

A

Access will not allow closing the database until a value is entered in the field

80
Q

A one-to-one relationship is _____ a one-to-many relationship.

A

not as common as

81
Q

Typically, a primary key field in one table becomes _____ in a related table.

A

the foreign key field

82
Q

Which of the following steps should be performed first to edit a relationship?

A

Click the Relationships button

83
Q

In planning a database and its related tables, it is important to consider

A

what each table is about

84
Q

To add a table to the Relationships window, click the table name at the Show Table dialog box and then click the _____ button.

A

Add

85
Q

For primary key fields, Access enforces entity integrity, which means that

A

it expects a value in the primary key field(s) for each record in the table.

86
Q

The Relationships window displays _____ that have been defined between tables.

A

all the relationships

87
Q

The ability to relate, or _____, tables is what makes Access a relational database system.

A

join

88
Q

A relational database management system eliminates the need for

A

data redundancy

89
Q

Abbreviate field names so that they are _____ but still easily understood.

A

as short as possible

90
Q

The plus symbols (+) in a subdatasheet are referred to as

A

expand indicators

91
Q

Relationships between tables are edited

A

at the Edit Relationships dialog box

92
Q

To add a new record to an open table, make sure the _____ tab is active and then click the _____ button in the Records group.

A

Home; New

93
Q

To insert a new field column in a table in Datasheet view, click in the first cell below the

A

Click to Add heading

94
Q

To create a one-to-many relationship, open the database containing the tables to be related and then click the Relationship button in the _____ group on the _____ tab.

A

Relationships; Database Tools

95
Q

Changes made to fields in a _____ affect the table and any related tables.

A

subdatasheet

96
Q

In database design, the lines drawn between tables that represent relationships are called

A

join lines

97
Q

The Add & Delete group is on the _____ tab and contains five buttons for assigning data types plus a More Fields button.

A

Table Tools Field

98
Q

Use the keyboard shortcut _____ to display the Open backstage area.

A

Ctrl + O

99
Q

What happens if you enter four characters into a text field that has a field size of 2?

A

Access will not accept the additional text.

100
Q

Why would you click the Enable Content button?

A

to indicate that a file originated from a trusted location on your computer

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions