Deck 5: Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Question 1

A ________ contains all the data concerning one person,place,thing,or event.

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

Answer 1

D

Question 2

Before you trust a file,you should first ________.

A) run a virus scan on it
B) repair it
C) compress it
D) compact it

Answer 2

A

Question 3

A ________ is a database that is presupplied with data.

A) beginner database
B) template database
C) sample database
D) starter database

Answer 3

C

Question 4

A collection of records is a(n)________.

A) folder
B) archive
C) spreadsheet
D) database

Question 5

The file extension for Access files is ________.

A) .acc
B) .accdb
C) .adb
D) .acdb

Question 6

The view that shows how fields are defined is called the ________ view.

A) datasheet
B) design
C) data
D) table

Question 7

The database object that stores data organized in an arrangement of columns and rows is called a ________.

A) field
B) form
C) table
D) record

Question 8

The table view that shows the data contents within a table is called the ________ view.

A) design
B) datasheet
C) data
D) table

Question 9

To produce a printed summary of the fields and records from a table or query in an easy-to-read format you would use a ________.

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

Question 10

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

A) information
B) data
C) lists
D) documents

Question 11

The ability to link ________ is what gives a database system its power.

A) forms
B) records
C) queries
D) tables

Question 12

The four main database objects in Access are ________.

A) tables, forms, programs, and reports
B) tables, records, programs, and reports
C) tables, queries, forms, and reports
D) tables, queries, programs, and reports

Question 13

The file name suffix that helps Windows determine which program should open a file is called a(n)________.

A) file extension
B) data expansion
C) object extension
D) file expansion

Question 14

Data that has been manipulated to make it meaningful and useful is called ________.

A) information
B) a fact
C) content
D) a field

Question 15

Represented by a column in Access,a specific piece of information that is stored in every record is called a ________.

A) field
B) data
C) form
D) table

Question 16

When working with objects in your Access database,you many need to use the ________ to find objects.

A) Search bar
B) Query wizard
C) Query box
D) Search wizard

Question 17

To answer questions about data in your tables,you use ________.

A) forms
B) spreadsheets
C) queries
D) reports

Question 18

The database object that holds organized data arranged in columns and rows is a ________.

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

Question 19

The structure of a database which includes tables,fields,forms,queries,and reports but has no data is a ________.

A) beginner database
B) sample database
C) starter database
D) template database

Question 20

A database management system program developed by Microsoft is ________.

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

Question 21

________ records arranges them together by the value of a single field.

A) Gathering
B) Grouping
C) Joining
D) Sorting

Question 22

A step-by-step guide that asks questions to help you decide what you want to do is called a(n)________.

A) wizard
B) query
C) design guide
D) action guide

Question 23

When you want to limit the amount of data that can be accessed by data entry clerks,you create a database ________ through which they can interact with the data they need to do their work.

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

Question 24

A ________ is a table created at run time.

A) form
B) temporary table
C) record set
D) query result

Question 25

Connie's boss has asked her to provide him a list of all customers who live in San Francisco,CA.To do this,Connie will create a ________.

A) PDF
B) form
C) query
D) question

Question 26

A view that shows a form and the data is the ________ view.

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

Question 27

An object that provides an easy-to-read format suitable for printing is a(n)________.

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

Question 28

The two uses of databases are operational processing and future planning purposes.

Question 29

Your boss is concerned with losing data in the event of a natural disaster.To prevent data loss,you recommend to him that a ________ of the database should be made on a regular schedule.

A) backup
B) compaction
C) substitute
D) compression

Question 30

Since Access does not reuse space when you delete a record,you need to occasionally ________ the database to make more efficient use of space.

A) compact
B) group
C) repair
D) sort

Question 31

A recordset that is created at run time is called a(n)________.

A) question result
B) query result
C) search result
D) answer result

Question 32

To put records within a group into a specific order based on the values of a specific field,you ________ them.

A) join
B) group
C) sort
D) arrange

Question 33

A(n)________ located at the bottom of the table allows you to move through the table.

A) Object bar
B) Table bar
C) Navigation bar
D) Content bar

Question 34

Data stored and organized in an arrangement of columns and rows is called a(n)________.

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

Question 35

A database that allows multiple connected tables is called a(n)________.

A) relational database
B) joined database
C) connected database
D) associated database

Question 36

The four main objects in an Access database are tables.,queries,forms,and reports.

Question 37

Data is an important asset,because it permits businesses to make better decisions once it is converted into information.

Question 38

A view that shows how a report will look on the printed page is the ________ view.

A) design
B) layout
C) report
D) print preview

Question 39

Julio will use a process called ________ to add content from an Excel worksheet to an Access table.

A) inserting
B) importing
C) moving
D) copying

Question 40

An interface often used by end users of a database to enter and change data is called a(n)________.

A) object
B) table
C) template
D) form

Question 41

If you need to print your results,your BEST option is to create a query.

Question 42

Breaking up a field such as address into multiple fields makes it easier to develop a report based on city or state.

Question 43

When you name a table in Access,you should use a long name that specifically identifies the data in the table.

Question 44

When you delete a record or object,Access reuses the original space for the next record or object you create.

Question 45

In an Access database,a column is a record,while a row is a field.

Question 46

Grouping records puts them within a specific ascending order based on field values.

Question 47

The Back Up Database command is available in the Backstage view on the Save & Publish tab.

Question 48

Once you run a virus scan,you can trust a file permanently.

Question 49

Having multiple large tables open at once in Access can slow the database management system down.

Question 50

To open or close the Navigation Pane,use the Shutter Bar Open/Close button.

Question 51

To prevent data entry clerks from having access to data that is not needed in their jobs,such as salaries or social security numbers of employees,a form can be developed that gives them only the access they need to complete their work.

Question 52

When you need to analyze the data in an Access database,you should export a query to Excel and use the analysis tools in Excel.

Question 53

A database and a database management system are not the same thing.A database is a collection of data,while a database management system is a software program that manages the data.

Question 54

While it is possible to import data from an Excel file,it is NOT possible to import data from a Word file.

Question 55

Access automatically saves data changes,so the query does not need to be saved.

Question 56

A sample database is empty,while a template database has presupplied example data.

Question 57

The ONLY view available in the Navigation Pane is all objects such as tables,queries,forms,and reports organized by object type.

Question 58

One of the limitations of the Access database management system is that it can NOT calculate information such as total sales or baseball scores.

Question 59

A query creates a run time table called a recordset.

Question 60

Data redundancy occurs when you have tables that are not related to the other tables in the database.

Question 61

Data ________ is the result of repetition of data in tables in a database.

Question 62

The operator ________ selects the records where the field values listed are within the two values.

Question 63

Copying data from another file in an Excel worksheet is called ________.

Question 64

Storing,managing,and providing access to business records is the purpose of a(n)________.

Question 65

In Access,data is stored in an arrangement of columns and rows called ________.

Question 66

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

Question 67

Access is a(n)________ DBMS (database management system).

Question 68

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

Question 69

A(n)________ can be based on the data in a table or query.

Question 70

The view that shows the data contents within a table is the ________ view.

Question 71

A way to interface with a table other than in the Datasheet view is a(n)________.

Question 72

Linking ________ together is what makes databases powerful.

Question 73

You have to tell Access that you trust content before features that a(n)________ might use to infect your computer will work.

Question 74

A step-by-step guide that walks users through tasks to help you create a form,query,or report is a(n)________.

Question 75

Arranging records together by the value of a single field is called ________.

Question 76

The view that shows how fields are defined is the ________ view.

Question 77

A(n)________ is the run time table created as the result of a query.

Question 78

While a sample database has sample data included with it,a(n)________ is a database that has a structure and definitions,but no data.

Question 79

The way to find answers based on data in a database is to create a(n)________.

Question 80

The data pertaining to one person,place,thing,or event is called a(n)________.