Deck 65: Overview of Databases

Question 1

When you perform an online search to determine available classes to take at your college,you are searching a database.

Answer 1

True

Question 2

The columns in a table are called ____.

A) fields
B) records
C) forms
D) spreadsheets

Answer 2

A

Question 3

Microsoft Access is the perfect tool to use to analyze your grades for the semester and calculate your current grade point average in class.

Answer 3

False

Question 4

All of the following objects are found in a database EXCEPT ____.

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

Question 5

In Access,the Quick Access pane lists all database objects,such as tables,queries,forms,and reports.

Question 6

The best software tool to use for monitoring daily business operations and quickly comparing expected activity to actual performance is a ____.

A) word processor
B) spreadsheet
C) database
D) file manager

Question 7

You open Access and click to select a new blank database.What should you do next?

A) Create and name a new table.
B) Create fields in the database to facilitate record entry.
C) Name the database and save it to the hard disk for storage.
D) Determine whether a template would better suit your needs.

Question 8

Access allows you to use the Undo key to reverse almost any action you perform.

Question 9

Each record contains data relating to a single entity.

Question 10

A ____ is a request to retrieve information stored from a database.

A) field
B) search
C) query
D) filter

Question 11

When you open your database for the first time,a blank ____ in Datasheet view appears where you can add data.

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

Question 12

A newly-created database in Access opens to the Form window,ready to start setting up the contents.

Question 13

In Access,queries are templates generally used to enter records into a database.

Question 14

If you wanted to determine which of the people in your database live in Oregon,you would construct a(n)____ to obtain the answer.

A) form
B) object
C) unique identifier
D) query

Question 15

A report is a formatted printout that can summarize specified data in a database.

Question 16

In Access,each type of object has an identifying icon.For ____,the icon is a grid.

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

Question 17

In a database record,a unique username can also be identified as the ____.

A) object key
B) key
C) primary key
D) table key

Question 18

Access requires you to create and name a new table before you start any work.