Exam 2: Introduction to Access

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

By default,Access uses a(n)________ Documents interface.

(Short Answer)
4.9/5
(32)

A module uses what programming language?

(Multiple Choice)
4.9/5
(35)

A ________ is a stored series of steps or commands.

(Short Answer)
4.8/5
(30)

Access is a ________ Management System.

(Short Answer)
4.8/5
(36)
Match the following terms with their description:
Report
Listing records in a specific sequence
Table
A way of limiting the number of records displayed
Template
The object in which the data is stored
Correct Answer:
Verified
Premises:
Responses:
Report
Listing records in a specific sequence
Table
A way of limiting the number of records displayed
Template
The object in which the data is stored
Selection Filter
Used to jumpstart your database
Sort
An object which displays formatted information in a professional manner
(Matching)
4.9/5
(36)
Match the following acronyms with their description:
ACCDE
Used in several database programs
DBMS
Used to create modules
VBA
A database format that only allows data entry
Correct Answer:
Verified
Premises:
Responses:
ACCDE
Used in several database programs
DBMS
Used to create modules
VBA
A database format that only allows data entry
SQL
A collection of organized data
Database
Access is one example.
(Matching)
4.8/5
(30)
Match the following terms with their description:
Sort
Changes the order of how records are displayed
Filter
A way of displaying data in which the data cannot be changed
Macro
Limits the amount of data displayed
Correct Answer:
Verified
Premises:
Responses:
Sort
Changes the order of how records are displayed
Filter
A way of displaying data in which the data cannot be changed
Macro
Limits the amount of data displayed
Report
A stored set of commands
Form
Using this is the one way of entering data
(Matching)
4.8/5
(24)

A customer's cell phone would be an example of a ________.

(Multiple Choice)
4.8/5
(39)

Which of the following operators will give you the fewest number of hits?

(Multiple Choice)
4.7/5
(33)

Every time you open a database you will receive a security warning.

(True/False)
4.9/5
(41)

Using the Back Up Database utility only saves the structure of the database,not the content.

(True/False)
4.8/5
(40)

When first designing a database,it is not important what data type you assign each field because you can easily change it later.

(True/False)
4.9/5
(27)

How would you sort records in a field so that the oldest birthday is listed first?

(Multiple Choice)
4.9/5
(34)

What is not true about modules?

(Multiple Choice)
4.8/5
(40)

Access is a ________ product.

(Multiple Choice)
4.9/5
(25)

Using Filter by Form allows you to filter on ________ criteria.

(Short Answer)
4.8/5
(38)
Match the following with their description:
Oracle
Comparison operators
Contains "Bill"
A more advanced DBMS
Tabs Documents interface
Could be used in a selection filter
Correct Answer:
Verified
Premises:
Responses:
Oracle
Comparison operators
Contains "Bill"
A more advanced DBMS
Tabs Documents interface
Could be used in a selection filter
<>,=.,>,<
Operators
AND,OR,NOT
Objects open in their own area under the ribbon.
(Matching)
4.9/5
(27)

Which method of creating a database demands the least amount of expertise in Access?

(Multiple Choice)
4.9/5
(28)

In datasheet view,what do the rows indicate?

(Multiple Choice)
4.8/5
(34)

Your birthday would be a good candidate for a primary key.

(True/False)
4.9/5
(31)
Showing 61 - 80 of 87
close modal

Filters

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