Exam 1: Access: Introduction to Access

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

Most users enter information into a database through the use of a ________.

(Multiple Choice)
4.7/5
(39)

In datasheet view, what do the rows indicate?

(Multiple Choice)
4.8/5
(27)

How can you toggle viewing the Navigation Pane?

(Multiple Choice)
4.8/5
(24)

What are the two ways you can view a table?

(Multiple Choice)
4.7/5
(25)

Which of the following is not a valid criteria in a filter?

(Multiple Choice)
4.8/5
(37)
Match the following terms with their description:
Name Box
Always begins with an equals sign (=)
Order of operations
Small green square used to perform various actions
Formula
Displays the address of the active cell
Correct Answer:
Verified
Premises:
Responses:
Name Box
Always begins with an equals sign (=)
Order of operations
Small green square used to perform various actions
Formula
Displays the address of the active cell
Fill handle
Also known as semi-selection
Pointing
PEMDAS
(Matching)
4.8/5
(46)

What database object organizes your data by rows and columns?

(Multiple Choice)
4.8/5
(37)

Deleting a record might have unforeseen consequences, so should be done cautiously.

(True/False)
4.8/5
(38)

You can only sort records by one field.

(True/False)
4.9/5
(32)

You always know when you are using a database.

(True/False)
4.9/5
(31)

Which of the following is not a property of a number data type?

(Multiple Choice)
4.7/5
(30)
Match the following Resource Monitor tabs with their purpose:
Overview
Helps you decide if you have enough primary storage
CPU
A summary of all resource usage
Memory
Helps you see if you are connected to other computers
Correct Answer:
Verified
Premises:
Responses:
Overview
Helps you decide if you have enough primary storage
CPU
A summary of all resource usage
Memory
Helps you see if you are connected to other computers
Disk
Helps you decide if you have enough processing power
Network
Helps you decide if you have enough RAM
(Matching)
4.8/5
(37)

In Datasheet view, ________ represent fields.

(Short Answer)
4.9/5
(39)

Match the following terms with their description: I. Table II. Field III. Record IV. Primary Key V. Query A. Uniquely identifies a record B. Category of information C. Stores all your data D. Asks a question of your data E. Complete set of fields

(Essay)
4.9/5
(44)

Microsoft SSL Server is an example of an advanced DBMS.

(True/False)
4.8/5
(38)

An ________ enables you to add a set of common Access components to an existing database.

(Short Answer)
4.9/5
(34)

What two tabs are unique to Access?

(Multiple Choice)
4.7/5
(23)

Match the following terms with their description: I. Compact and Repair Database II. Database III. Datasheet view IV. Design view V. Module A. A view which displays an object's structure B. An advanced object within VBA C. A utility that makes a database smaller and fixes errors D. A way of displaying data in a row\column grid E. A collection of data organized as useful information

(Essay)
4.7/5
(44)
Match the following terms with their description:
Normal view
Displays data and page breaks
Page Layout view
Allows you to go to the first, previous, next, or last sheet in a workbook
Page Break Preview
Does not display margins or page breaks
Correct Answer:
Verified
Premises:
Responses:
Normal view
Displays data and page breaks
Page Layout view
Allows you to go to the first, previous, next, or last sheet in a workbook
Page Break Preview
Does not display margins or page breaks
View controls
Icons that let you change views
Sheet tab navigation
Displays data and margins
(Matching)
4.8/5
(29)
Match each of the following terms to their meanings:
Template
Acts somewhat like light switch that you can turn on and off
Theme
Provides access to the most common formatting selections such as adding bold or italic
Toggle command
Predesigned file that incorporates formatting elements
Correct Answer:
Verified
Premises:
Responses:
Template
Acts somewhat like light switch that you can turn on and off
Theme
Provides access to the most common formatting selections such as adding bold or italic
Toggle command
Predesigned file that incorporates formatting elements
Format Painter
Enables you to quickly and easily copy formatting from one area to another
Mini toolbar
Collection of design choices used to give a consistent look to your work
(Matching)
4.8/5
(31)
Showing 101 - 120 of 138
close modal

Filters

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