Deck 6: Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Question 1

The two most common data types are ________.

A) Number and Memo
B) Number and Text
C) Data and Text
D) Memo and Date

Answer 1

B

Question 2

When working with tables,if you ________ a record or records,you CANNOT Undo the change.

A) enter
B) move
C) delete
D) add

Answer 2

C

Question 3

Information about an entity is called a(n)________.

A) field
B) attribute
C) table
D) row

Answer 3

B

Question 4

Record changes are saved automatically,but ________ changes are not saved until you save.

A) form
B) field
C) design
D) multiple

Question 5

A field that CANNOT be blank and and must be unique is called a ________.

A) primary key
B) natural key
C) foreign key
D) composite key

Question 6

When you import an existing table into Access,Access creates a table using the ________ headings for field names.

A) column
B) row
C) table
D) worksheet

Question 7

The characteristic that defines the kind of data that can be entered into a field,such as numbers,text,or dates are ________.

A) data types
B) field types
C) content types
D) information types

Question 8

In a database,data about a person,place,item or event is called a(n)________.

A) row
B) entity
C) field
D) attribute

Question 9

To type data into the table without using a form,you use the ________ view.

A) Datasheet
B) Spreadsheet
C) Design
D) Worksheet

Question 10

When you delete an individual field from a table,the deletion is ________.

A) permanent
B) invariable
C) temporary
D) constant

Question 11

The first field in a table is the ________,which must be a unique entry.

A) export key
B) primary key
C) import key
D) composite key

Question 12

Fields such as names or addresses should be split into their ________ parts.

A) different
B) component
C) individual
D) separate

Question 13

The comma or tab are typical ________ characters.

A) normal
B) spacing
C) delimiter
D) special

Question 14

A set of cells that can be used within a formula or function are a(n)________.

A) export range
B) import range
C) named range
D) called range

Question 15

By default,Access orders tables by the ________.

A) secondary key
B) foreign key
C) primary key
D) composite key

Question 16

To stop editing a record and revert it back to what it was before editing,you press ________.

A) CTRL+ESC
B) ESC
C) Shift+ESC
D) TAB

Question 17

If the Undo button is dimmed,you CANNOT ________ the change you made.

A) Redo
B) Undo
C) Enter
D) Delete

Question 18

An association between tables based on common fields is called a(n)________.

A) attribute
B) relationship
C) liaison
D) association

Question 19

The three columns in the upper pane of a Table Design view are ________.

A) Field Name, Data Type, and Description
B) Field Name, Data Type, and Information
C) Data Type, Description, and Information
D) Field Name, Description, and Information

Question 20

The two methods of entering data directly into Access are typing the data into the table or ________.

A) importing data from a table
B) using a query to add data
C) copy and paste data into a datasheet
D) entering the data in a form

Question 21

Though it does not affect the way data is stored in Access,a ________ tells Access how the data is to be displayed.

A) label
B) preset
C) format
D) design

Question 22

When referential integrity is enforced,you CANNOT ________ a record from the one side table if matching records exist in the many side table.

A) add
B) change
C) move
D) delete

Question 23

When you add relationships to tables,you can work with two or more ________ in the same query,report,or form.

A) records
B) databases
C) fields
D) tables

Question 24

A ________ key is used when two fields are needed to uniquely identify a record.

A) composite
B) natural
C) foreign
D) primary

Question 25

________ are created by joining the tables in a relational database together.

A) Relationships
B) Reports
C) Forms
D) Queries

Question 26

A(n)________ relationship has one record in the first table that corresponds to many records in the second table.

A) cardinal
B) many-to-many
C) one-to-one
D) one-to-many

Question 27

Access stores dates as a(n)________.

A) long integer
B) decimal
C) floating-point number
D) integer

Question 28

The ________ data type is a check box where an empty box represents no and a checked box represents yes.

A) Attachment
B) Memo
C) Yes/No
D) Number

Question 29

________ makes changes and replicates the changes through all related tables so that referential integrity is maintained.

A) Torrent update
B) Flow update
C) Cascade update
D) Waterfall update

Question 30

The maximum length of a data field is the ________.

A) information size
B) field length
C) data size
D) field size

Question 31

When data has a unique identifier included as part of the data,this is called a ________ key.

A) primary
B) natural
C) composite
D) normal

Question 32

In a numeric data type,the Field size property defines the ________ or value.

A) maximum length
B) property
C) calculated value
D) total value

Question 33

If you need to use more than 255 characters in a text field,you should use the ________ data type.

A) Lookup
B) Memo
C) Attachment
D) Date/Time

Question 34

Using an ________,Access gives you a way to consistently enter data.

A) input table
B) input form
C) input record
D) input mask

Question 35

If you need to use a ________ data type,you do NOT have to select it,since it is the default data type.

A) number
B) date/time
C) text
D) memo

Question 36

A set of rules that Access uses to make sure that the relationships you are forming between the records in your tables make sense are called ________.

A) table integrity
B) referential integrity
C) cascade rules
D) relationship rules

Question 37

A ________ is the primary key of one table stored in a second table to allow a relation to be created.

A) foreign key
B) composite key
C) unique key
D) natural key

Question 38

If you need to form a many-to-many relationship between two tables,you will need to create two one-to-many relationships called ________ to represent the many-to-many relationship.

A) junction tables
B) related tables
C) cardinal tables
D) one-to-one relationships

Question 39

The characteristic that determines the kind of data that can be entered into a field is called a(n)________.

A) data field
B) data type
C) entity
D) relationship

Question 40

When you ________ the tables in a database,there will be no redundancy in the tables.

A) systemize
B) normalize
C) relate
D) format

Question 41

When a table is open in Design view,you can type data directly into a table or form.

Question 42

Delimited text has a special character such as a tab or a comma separating field entries.

Question 43

A shirt is an example of an item,or attribute,in a clothing store database,while an entity is information about the shirt,such as the color or style.

Question 44

To allow for creating reports based on city or zip code,you should split address fields into their component parts.

Question 45

There is an upper limit of 155 characters for a text field.

Question 46

Design changes are not saved until you save,but data changes are automatically saved.

Question 47

Normalization is the process of cascading updates throughout a database.

Question 48

When you delete individual fields from a table,these are permanent deletions that cannot be undone.

Question 49

When table data has a unique identifier that is already a part of the data,it is called a natural primary key.

Question 50

Redundancy occurs when data is repeated several times in a database.

Question 51

Formats change the way data is stored in a database.

Question 52

You can add primary key data later after defining a primary key in a table.

Question 53

The foreign key uniquely identifies each of the records in a table.

Question 54

When cutting and pasting columns from Excel to Access,they must be the exactly the same.

Question 55

Data types define the kinds of data that can be entered into a field.

Question 56

The Text data types give users the ability to calculate values.

Question 57

To reference part of a worksheet in formulas or graphics by cell addresses or range addresses,you have to use a named range.

Question 58

The relationships in a relational database are created by joining the tables together and relating fields.

Question 59

Access has a wizard that creates automatic masks for items such as zip codes,passwords,dates,and times.

Question 60

When two fields are needed to uniquely identify a record,use a composite key.

Question 61

In table design,the ________ field property allows you to customize how data is displayed and printed in tables,queries,reports,and forms.

Question 62

The field called the ________ that uniquely identifies a record in a table must be a field that will not change.

Question 63

A person,place,item,or event that you want to preserve data about is called a(n)________.

Question 64

You should use cascade delete to maintain your records and prevent redundancies.

Question 65

Primary and foreign keys form a common field between tables that makes it possible to form a(n)________ between the two tables.

Question 66

A(n)________ defines a consistent template and provides the punctuation.

Question 67

Information about an entity is called a(n)________.

Question 68

The ________ pane in Design view gives information on how data is stored,entered,and processed.

Question 69

When two fields are required to uniquely identify a record,they are called a(n)________ key.

Question 70

Cardinality represents the relationship between two tables when one record in the first tables corresponds to many records in the second table.

Question 71

A relationship between tables where a record in the first table has only one matching record in the second table is called a(n)________ relationship.

Question 72

A(n)________ allows you to work with two or more tables in the same query,report,or form.

Question 73

The ________ data type can store up to 1 gigabyte of characters and should be used when the text data type will not hold enough text.

Question 74

A relationship represents an entity in a database,while a field represents the data that connects the two tables.

Question 75

A(n)________ is a set of cells that can be referred to by a name rather than by the cell references.

Question 76

When you open a table in ________ view,you can type data directly into the table.

Question 77

When a database is ________,the result is several smaller tables,each representing a different thing.

Question 78

________ occurs when data is repeated several times in a database.

Question 79

In Access,the relationship information is stored in the ________ window.

Question 80

When you have a relationship between tables in which one record in one table has many matching records in a second table,and one record in the second table has many matching records in the first table,you have a(n)________ relationship.