Exam 11: The Four Main Database Objects

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

The bottom half of the window in a query's design view is the Query ________.

Free
(Short Answer)
4.9/5
(32)
Correct Answer:
Verified

design grid

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

Free
(True/False)
4.8/5
(44)
Correct Answer:
Verified

True

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

Free
(True/False)
4.7/5
(39)
Correct Answer:
Verified

False

________ are raw facts.

(Multiple Choice)
4.9/5
(42)

Facts that have been manipulated and have meaning become ________.

(Multiple Choice)
4.9/5
(35)

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

(True/False)
4.8/5
(39)

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

(True/False)
4.7/5
(35)
Match the following file extensions with their definition.
accde
Access database template
mdb
Access 2007-2016 database file that is in "execute only" mode
mde
Access 2002-2003 database file that is in "execute only" mode
Correct Answer:
Verified
Premises:
Responses:
accde
Access database template
mdb
Access 2007-2016 database file that is in "execute only" mode
mde
Access 2002-2003 database file that is in "execute only" mode
accdt
Access database file
accdb
Access 2002-2003 database file
(Matching)
4.8/5
(35)

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

(Multiple Choice)
4.9/5
(32)

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

(Short Answer)
4.7/5
(34)

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

(Multiple Choice)
4.9/5
(33)

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

(Short Answer)
4.8/5
(37)

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

(Short Answer)
4.9/5
(39)
Match the following terms with their definition.
Report
Different perspective and different capabilities
Form
Allows you to easily enter new records
Table
Allows you to ask questions about the data
Correct Answer:
Verified
Premises:
Responses:
Report
Different perspective and different capabilities
Form
Allows you to easily enter new records
Table
Allows you to ask questions about the data
View
An easy-to-read format suitable for printing
Query
Stores data organized in columns and rows
(Matching)
4.8/5
(29)

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

(Multiple Choice)
4.8/5
(33)

The file extension for an Access database template is ________.

(Multiple Choice)
4.8/5
(35)

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

(Short Answer)
4.7/5
(34)

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

(Short Answer)
4.8/5
(29)
Match the following terms with their definition.
Field
Shows how fields are defined
Datasheet view
A suffix
Navigation Pane
An attribute
Correct Answer:
Verified
Premises:
Responses:
Field
Shows how fields are defined
Datasheet view
A suffix
Navigation Pane
An attribute
File extension
Allows you to view the objects in the database
Design view
Shows the data contents within a table
(Matching)
4.9/5
(27)

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

(Multiple Choice)
4.9/5
(26)
Showing 1 - 20 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)