Deck 11: The Four Main Database Objects

Question 1

The ________ view of a table displays the data stored in the table.

A) Layout
B) Datasheet
C) Design
D) Report

Answer 1

B

Question 2

You can use a database ________ to ask a question of the data.

A) report
B) form
C) table
D) query

Answer 2

D

Question 3

Each column in an Access table is called a(n)________.

A) record
B) field
C) piece
D) section

Answer 3

B

Question 4

A(n)________ is a specific piece of information that is stored in every record.

A) record
B) link
C) attribute
D) relationship

Question 5

The file ________ for an Access database is .accdb.

A) extension
B) name
C) location
D) path

Question 6

The Navigation ________ on the left side of the application allows you to view all the objects in a database.

A) filter
B) bar
C) window
D) Pane

Question 7

To close the Navigation Pane,click the ________ Open/Close button.

A) Layout view
B) object
C) Shutter Bar
D) record selector

Question 8

The Navigation Pane is located on the ________ when Access is opened.

A) top
B) bottom
C) right side
D) left side

Question 9

Microsoft ________ 2016 is Microsoft's most current database management system.

A) PowerPoint
B) Access
C) Word
D) Excel

Question 10

Which of the following is NOT true about databases?

A) In business, data is collected and used for decision making.
B) Information is data that has been manipulated.
C) A database eliminates the need for a paper-based system.
D) Databases are used for operational processing and for analytical purposes.

Question 11

The file extension for a 2002-2003 Access database file that is in "execute only" mode is ________.

A) accde
B) mdb
C) mde
D) accdt

Question 12

The power of a(n)________ is the ability to link tables to one another.

A) suite
B) ACCDB
C) DBMS
D) database

Question 13

A structure of a database that is already populated with tables,fields,forms,queries,and reports is a(n)________.

A) template
B) DBMS
C) starting file
D) relationship

Question 14

________ are raw facts.

A) Data
B) Information
C) Queries
D) Objects

Question 15

Access includes a ________ to make it easier to find objects in a larger database.

A) Search box
B) Help window
C) Navigation bar
D) Navigation Pane

Question 16

In a database,data is stored in a ________.

A) report
B) form
C) table
D) query

Question 17

Facts that have been manipulated and have meaning become ________.

A) information
B) data
C) knowledge
D) objects

Question 18

Facts about people,events,ideas,or things are ________.

A) information
B) data
C) knowledge
D) objects

Question 19

The file extension for an Access database template is ________.

A) accde
B) mdb
C) mde
D) accdt

Question 20

Which of the following is NOT true about the advantages that automated databases have over paper databases?

A) The information in an automated database is much easier to find.
B) Automated databases can be used to enforce accuracy and other quality standards.
C) The information in an automated database can be manipulated and processed more rapidly.
D) Paper databases make it easier for businesses to be competitive.

Question 21

Reports have ________ views.

A) two
B) three
C) four
D) five

Question 22

If no sort criteria is specified when creating a query,Access will sort the results by the ________.

A) first text field
B) first numeric field
C) foreign key
D) primary key

Question 23

To see how a report would look in a continuous page layout,open the report in ________.

A) Report view
B) Print Preview
C) Layout view
D) Design view

Question 24

An Access wizard is a(n)________.

A) type of template
B) shortcut to building objects
C) storage methodology
D) operator

Question 25

The Back Up Database command is located on ________ view.

A) Report
B) Backstage
C) Form
D) Datasheet

Question 26

Which of the following is NOT true about compacting and repairing a database?

A) The compact option also looks for damaged data and tries to repair it.
B) There are four options for compacting a database.
C) Compacting releases unused space to be used again.
D) If you do not compact your database, it can become very large quickly.

Question 27

To view a form and the data,click ________ view.

A) Form
B) Layout
C) Design
D) Print

Question 28

________ an Access database rearranges objects so disk space is used more efficiently.

A) Backing up
B) Recovering
C) Compacting
D) Saving

Question 29

The ________ operator in a query selects the records in which the field values listed are within the two values.

A) Between
B) < >
C) > =
D) < =

Question 30

To see how a report would look on a piece of paper,open the report in ________.

A) Report view
B) Print Preview
C) Layout view
D) Design view

Question 31

A ________ helps create objects using a step-by-step process.

A) template
B) shortcut
C) file extension
D) wizard

Question 32

The Navigation ________ makes it easy for you to move through records in a table.

A) file
B) window
C) bar
D) Pane

Question 33

The view used to add or edit data in a form is ________.

A) Form
B) Layout
C) Design
D) Print

Question 34

A ________ is used to ask a question of the data.

A) report
B) table
C) query
D) form

Question 35

Query results can be printed from the ________ tab.

A) File
B) Home
C) View
D) Create

Question 36

The ________ operator in a query selects the records in which the field value is not equal to the value provided.

A) Between
B) < >
C) > =
D) < =

Question 37

A(n)________ database is an extra copy of a database that you keep just in case something happens to the original one.

A) repaired
B) compacted
C) backup
D) advance

Question 38

The ________ view shows the query's structure.

A) Query Results
B) SQL
C) Datasheet
D) Design

Question 39

All of the following can be performed in Excel EXCEPT:

A) manage data.
B) perform calculations.
C) relate worksheets.
D) report on data.

Question 40

The process of copying data from another file into a database is known as ________.

A) importing
B) filing
C) inserting
D) reconciling

Question 41

You can easily integrate Access with other products in the Office suite.

Question 42

A template can be used as a starting point when creating a new database.

Question 43

A column in an Access table is called a characteristic.

Question 44

Operational databases are used for extracting data for decision making.

Question 45

A DBMS and database are synonymous.

Question 46

The data contents within a table can be seen in Design view.

Question 47

Data is always stored in a form.

Question 48

Data is an important asset to any organization after it is converted to information.

Question 49

A database is a collection of the data that companies spend a lot of time and money on gathering.

Question 50

The Navigation Pane is used to navigate through a table.

Question 51

A table organizes data in columns and rows.

Question 52

Access has six main objects.

Question 53

Databases are used for operational processing and for analytical purposes.

Question 54

Relationships are links between the tables.

Question 55

A form pulls records from a table in an easy-to-read format suitable for printing.

Question 56

Every time Joe's customers purchase an item,he stores the sale in a database.The best option for him is to use an analytical database.

Question 57

What you learn about one relational database can be transferred to other relational databases.

Question 58

A query is another word for a question.

Question 59

A report allows you to enter,edit,and delete data.

Question 60

A record is all of the data pertaining to one person,place,thing,or event.

Question 61

If you want to insert data from another file into an Access database,you must use copy and paste.

Question 62

A column or field in an Access table is also known as a(n)________.

Question 63

The import data options are located on the ________ tab.

Question 64

Before working in a database,it is beneficial to explore the database ________.

Question 65

A table organizes data in ________ and rows.

Question 66

To move through the data in a table,Access provides a(n)________ at the bottom of the table.

Question 67

Data ________ is created through repetition and causes inefficiencies.

Question 68

Because there are many Access functions that use a table and will not work if the table is open,it is best practice to close a table when you are finished working with it.

Question 69

A database that includes linked tables is said to be a(n)________ database.

Question 70

A(n)________ pulls records from a table in an easy-to-read format suitable for printing.

Question 71

The process of copying data from another file,like a Word document,into an Access database is called ________.

Question 72

When you create relationships in a relational database,you give it power.

Question 73

To create objects,a(n)________ can be used to serve as a step-by-step guide.

Question 74

The data contents within a table can be seen in ________ view.

Question 75

Redundant information leads to ________.

Question 76

Access 2016 uses a different file extension than previous versions of Access.

Question 77

Backing up a database will help protect you against any mishaps with the original database such as accidental loss of data.

Question 78

A(n)________ is all of the data pertaining to one person,place,thing,or event.

Question 79

If you have redundant data in your database,then you have duplicate data that should be corrected or deleted.

Question 80

The ________ row at the end of a table allows you to enter new records into the table.