Deck 1: Workshop 1: The Four Main Database Objects

Question 1

Which of the following is NOT true about database templates?

A)You can download a wide variety of templates from Microsoft's website Office.com.
B)Templates are professionally designed databases that you can either use as is or adapt to suit your needs.
C)Microsoft provides sample database templates used for managing assets,contacts,issues,projects,and tasks.
D)A template is a sample database that has presupplied data

Answer 1

D

Question 2

A(n)________ is the file extension for an Access 2002-2003 database file.

A)ACCDB
B)MDB
C)MDE
D)ACCDT

Answer 2

B

Question 3

Which of the following is NOT a main object in an Access database?

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

Answer 3

B

Question 4

A(n)________ is the file extension for an Access 2007-2013 database template.

A)ACCDB
B)MDB
C)MDE
D)ACCDT

Question 5

You are reading a report that shows Company A generated $2,000 last week.This would be ________.

A)knowledge
B)a competitive advantage
C)data
D)information

Question 6

When you open a database,Access displays the ________ on the left side.

A)Navigation Pane
B)Property Sheet
C)Forms Pane
D)Shutter Bar Pane

Question 7

Which of the following is NOT a reason to use Access?

A)Access is an easily available DBMS.
B)Access is often used by multiple users at the same time.
C)Access allows for easy interaction with other products in the Office suite.
D)Access allows you to create an app database and either give it to others or put it on the Windows App Store.

Question 8

A ________ is a structure of a database with tables,fields,forms,queries,and reports.

A)template
B)view
C)pattern
D)sample

Question 9

A DBMS is a ________.

A)database Microsoft system
B)database management system
C)data manipulation system
D)database management service

Question 10

________ is/are facts about people,events,things,or ideas.

A)Knowledge
B)A competitive advantage
C)Data
D)Information

Question 11

Which of the following is NOT an Access file extension?

A)ACCDB
B)ACCDE
C)ACCDT
D)ACCTM

Question 12

Which of the following is NOT an advantage that automated databases have over paper databases?

A)Without paper databases,a business cannot compete.
B)The information in databases is much easier to find in automated form.
C)The information in automated databases can be manipulated and processed more rapidly.
D)Automated databases can be used to enforce accuracy and other quality standards.

Question 13

Access is a(n)________ DBMS.

A)automated
B)linked
C)relational
D)form-based

Question 14

Which of the following is NOT true about databases?

A)Databases are used for two major purposes: for operational processing and for analytical purposes.
B)The information in databases is summarized and classified to make data available to the decision makers.
C)In operational or transaction-based databases,each sale or transaction that a business makes is tracked.
D)Analytical databases are used for extracting data for decision making.

Question 15

The Navigation Pane allows for all of the following views EXCEPT ________.

A)Custom
B)Object Type
C)Queries and Related Views
D)Created Date

Question 16

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

A)Navigation
B)Property
C)Forms
D)Shutter

Question 17

Which of the following should NOT be done if Access give you a security warning about your database?

A)Run a virus scan on any file before you say it should be trusted.
B)If you know the database is safe,you can trust a database permanently by storing it in a trusted location.
C)Do not click Enable Content in the security warning if you are not sure if the database is safe.
D)Enable the content.Nothing bad will happen,even if there is a virus embedded in the file.

Question 18

To help you find ________,Access provides a Search box.

A)objects
B)Object Type
C)data
D)file extensions

Question 19

Which of the following is NOT true regarding businesses and databases?

A)Records are collected and used for decision making,for sales and marketing,and for reporting purposes.
B)Businesses keep records about everything they do.
C)The purpose of a database is to store,manage,and provide access to the business records.
D)Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.

Question 20

Which of the following is NOT true about creating new databases?

A)When you create a new database,you can design it yourself starting with an empty database.
B)You can use a template; however,you need to create your own forms and reports.
C)If you design your own database,you develop the tables,fields,and the relationships between the tables.
D)If you build your own database,you need to decide what information you want to keep in your database,how this information should be grouped into tables,what relationships you need,and what queries and reports you need.

Question 21

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

A)Table
B)Report
C)Form
D)Design

Question 22

Which of the following is NOT true regarding a backup database?

A)The backup copy is as current as your real database,and saves you from having to recreate your database.
B)A backup database is an extra copy of your database that you can use to protect yourself from the accidental loss of your database.
C)Backups can help in cases of accidental deletion of data.
D)You can return to the backup copy if you accidentally delete the real database.

Question 23

Which of the following is NOT a problem that can be caused by using Excel to store data?

A)Loss of data
B)Errors in the data
C)Lack of functionality
D)Data redundancy

Question 24

The ________ row of the query design grid is the Field name.

A)top
B)second
C)third
D)bottom

Question 25

Which of the following is NOT true when creating a backup database?

A)In Access,you make backups by using the Back Up Database command.
B)The Back Up Database command is available on Backstage view under Export.
C)If you make multiple backup copies,you should give them different names.
D)If you ever need a backup,simply return to the most recent copy that you have and start working with that file.

Question 26

Which of the following is NOT true regarding tables and relational databases?

A)Tables store data organized in an arrangement of columns and rows.
B)Do not use special characters,such as an underscore,in table names.
C)The power of a relational database comes when you link tables.
D)A relational database is a database where data is stored in tables with relationships between the tables.

Question 27

While Access allows you to leave several tables open at the same time,it is a good idea to get into the habit of ________ a table when you are finished with it.

A)saving
B)closing
C)exporting
D)renaming

Question 28

________ shows how the report would look on the printed page and allows you to change the page layout.

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

Question 29

A ________ provides an easy-to-read format suitable for printing.

A)wizard
B)macro
C)form
D)report

Question 30

________ shows the report and the data; some report design such as field lengths and fonts can be changed in this view.

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

Question 31

How is Access different from Excel?

A)Access has numbered rows of data.
B)Access allows you to manage data,perform calculations,and report on the data.
C)Access allows multiple tables with relationships between the tables.
D)Access has columns with labels.

Question 32

You can perform ________ Compact and Repair Database action at any time.

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

Question 33

There are ________ options for compacting a database.

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

Question 34

A ________ provides another interface beyond the table in Datasheet view.

A)wizard
B)macro
C)form
D)report

Question 35

________ shows how the report would look in a continuous page layout.

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

Question 36

________ rearrange(s)objects to use disk space more efficiently,thus releasing the now unused space to be used again.

A)Backups
B)Reports
C)Queries
D)Compacting

Question 37

A ________ is used to ask questions about your data.

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

Question 38

A(n)________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

A)AutoReport
B)form
C)AutoForm
D)wizard

Question 39

________ shows the report design but not the data.

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

Question 40

If you select ________,Access automatically compacts your database anytime you close it.

A)Compact Now
B)Compact on Exit
C)Compact on Close
D)Compact and Repair Database

Question 41

Each row in an Access table is called a record.

Question 42

Query results are a recordset that provide an answer to a question posed in a query.

Question 43

When you open a database,Access displays the Navigation Pane on the right side.

Question 44

Importing is the process of copying data from another file,such as a Word file or Excel workbook,into a separate file,such as an Access database.

Question 45

Design view shows how fields are defined and structured.

Question 46

Data is information that has been manipulated and processed to make it meaningful.

Question 47

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business decisions.

Question 48

What you learn about Access is transferable to other relational DBMSs.

Question 49

The power of a database system comes with the ability to link tables together.

Question 50

A file extension is the suffix on all file names that helps Windows understand what information is in a file and what program should open the file.

Question 51

Each column in Access is called a field.

Question 52

A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Question 53

At the top of the table,Access provides a Navigation bar that allows you to move through the table.

Question 54

Design view of a table shows the data contents within a table.

Question 55

A database is a collection of records that are used for decision making,for sales and marketing,and for reporting purposes.

Question 56

Access allows you to create an app database and either give it to others or put it on the Windows App Store.

Question 57

Access is a relational DBMS program created by Microsoft.

Question 58

The Shutter Bar Open/Close button at the top of the Navigation Pane and opens and closes the pane.

Question 59

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

Question 60

Access is often used as a stand-alone DBMS,meaning a DBMS used by multiple users.

Question 61

Access allows you to create an app database and either give it to others or put it on the ________.

Question 62

Access is a(n)________ DBMS program created by Microsoft.

Question 63

In corporate databases,end users of a database computer system often use queries to enter and change data.

Question 64

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business ________.

Question 65

________ view of a table shows the data contents within a table.

Question 66

Each row in the design grid shows information about a record.

Question 67

________ view shows how fields are defined.

Question 68

You can use Backstage view to modify an existing query.

Question 69

Access is often used as a stand-alone DBMS,meaning a DBMS used by ________ users.

Question 70

Query results show records and fields created at ________,which means that the results are created each time you run the query.

Question 71

When Access runs a query,it puts the results in a(n)________ order based on how the table is defined.

Question 72

The Query Wizard uses a question-and-answer dialog box to create a query.

Question 73

When Access runs a query,it puts the results in a default order based on how the table is defined.

Question 74

The power of a database system comes with the ability to link ________ together.

Question 75

The ________ uses a question-and-answer dialog box to create a query.

Question 76

A(n)________ is a collection of records that are used for decision making.

Question 77

________ is data that has been manipulated and processed to make it meaningful.

Question 78

Each ________ in the query design grid shows information about the field.

Question 79

Query results show records and fields created at recordset time,which means that the results are created each time you run the query.

Question 80

What you learn about Access is ________ to other relational DBMSs.