Question 1

You only need to save an object when ________.

Accepted Answer

A) you make changes to its data 
B) you make changes to its structure 
C) you add or delete fields 
D) you want to rename the object 
A) you make changes to its data 
B) you make changes to its structure 
C) you add or delete fields 
D) you want to rename the object

Question 2

A web app is a ________-based database.

Accepted Answer

The answer of A web app is a ________-based database....

Question 3

To create a database from a template you would use which view?

Accepted Answer

A) Design 
B) Layout 
C) Create database 
D) Backstage 
A) Design 
B) Layout 
C) Create database 
D) Backstage

Question 4

What produces a subset of your data?

Accepted Answer

A) Macro 
B) Field 
C) Table 
D) Query 
A) Macro 
B) Field 
C) Table 
D) Query

Question 5

Naming a table carefully is very important because it is the only way to describe what data that table contains.

Accepted Answer

A) True 
 B)False

Question 6

Match the following acronyms with their description:
I. VBA
II. DBMS
III. ACCDE
IV. RAM
V. SQL
A. Where most Office programs store their files while the user is working
B. Used in several database programs
C. Used to create modules
D. A database format that only allows data entry
E. Access is one example.

Accepted Answer

The answer of Match the following acronyms with their description:
I....

Question 7

Match between columns
                        Premises: LastName, FirstName, CellPhone
AutoNumber, Short Text, Number
Social Security Number, Student ID, AutoNumber
<>4, >2000, ="Fred"
Validation Rule, Field Size, Caption

Accepted Answer

The Answer of Examples of filter criterion and Examples of is...

Question 8

What interface element shows you the various objects in your database?

Accepted Answer

A) The Database Tools menu 
B) The Database Properties pane 
C) The Home menu 
D) The Navigation pane 
A) The Database Tools menu 
B) The Database Properties pane 
C) The Home menu 
D) The Navigation pane

Question 9

To assign a field size of 12 to a field you would ________.

Accepted Answer

A) pick Short Text from the Data Type list 
B) pick Long Text from the Data Type list 
C) type 12 in the Description area of that field 
D) enter 12 in the Field Size property of that field 
A) pick Short Text from the Data Type list 
B) pick Long Text from the Data Type list 
C) type 12 in the Description area of that field 
D) enter 12 in the Field Size property of that field

Question 10

What does opening a database in exclusive mode assure?

Accepted Answer

A) That a password has been set previously 
B) That no changes can be made to the structure of the database 
C) There is no such thing as exclusive mode. 
D) That you are the only person with that database open 
A) That a password has been set previously 
B) That no changes can be made to the structure of the database 
C) There is no such thing as exclusive mode. 
D) That you are the only person with that database open

Question 11

The ________ comparison operator indicates "not equal."

Accepted Answer

The answer of The ________ comparison operator indicates "not equal."...

Question 12

When does Access save a record?

Accepted Answer

A) When you press the Save icon 
B) When you move to a different field 
C) When you move to a different record 
D) When you close the form or table 
A) When you press the Save icon 
B) When you move to a different field 
C) When you move to a different record 
D) When you close the form or table

Question 13

Match the following with their description:
I. LastName, FirstName, CellPhone
II. AutoNumber, Short Text, Number
III. Social Security Number, Student ID, AutoNumber
IV. 4, >2000, ="Fred"
V. Validation Rule, Field Size, Caption
A. Examples of filter criterion
B. Examples of field properties
C. Examples of field names
D. Examples of Primary keys
E. Examples of Data Types

Accepted Answer

The answer of Match the following with their description:
I. LastName,...

Question 14

Match between columns
                        Premises: Data
View
Insert
Home
File

Accepted Answer

The Answer of Alt + F and Alt + N is...

Question 15

How many records do most forms display?

Accepted Answer

A) 0 (Forms don't display records) 
B) 1 
C) 2 
D) All the records at the same time 
A) 0 (Forms don't display records) 
B) 1 
C) 2 
D) All the records at the same time

Question 16

DBMS stands for ________.

Accepted Answer

database m

Question 17

The ________ data type is generated by Access whenever a new record is created.

Accepted Answer

The answer of The ________ data type is generated by...

Question 18

Filters do not delete data or records.

Accepted Answer

A) True 
 B)False

Question 19

The ACCDE format allows users to ________.

Accepted Answer

A) view data, but make no changes to the structure or to enter data 
B) do anything to the structure and data because it is just a format for compressing data 
C) enter data, but not add, modify, or delete objects 
D) run the Access database without Access installed 
A) view data, but make no changes to the structure or to enter data 
B) do anything to the structure and data because it is just a format for compressing data 
C) enter data, but not add, modify, or delete objects 
D) run the Access database without Access installed

Question 20

Match between columns
                        Premises: Document properties
Footer
Header
Insertion point
Word wrap

Accepted Answer

The Answer of Information displayed at the top of a is...

You only need to save an object when ________.

A web app is a ________-based database.

To create a database from a template you would use which view?

What produces a subset of your data?

Naming a table carefully is very important because it is the only way to describe what data that table contains.

What interface element shows you the various objects in your database?

To assign a field size of 12 to a field you would ________.

What does opening a database in exclusive mode assure?

The ________ comparison operator indicates "not equal."

When does Access save a record?

How many records do most forms display?

DBMS stands for ________.

The ________ data type is generated by Access whenever a new record is created.

Filters do not delete data or records.

The ACCDE format allows users to ________.

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters

Exam 1: Access: Introduction to Access

You only need to save an object when ________.

A web app is a ________-based database.

To create a database from a template you would use which view?

What produces a subset of your data?

Naming a table carefully is very important because it is the only way to describe what data that table contains.

What interface element shows you the various objects in your database?

To assign a field size of 12 to a field you would ________.

What does opening a database in exclusive mode assure?

The ________ comparison operator indicates "not equal."

When does Access save a record?

How many records do most forms display?

DBMS stands for ________.

The ________ data type is generated by Access whenever a new record is created.

Filters do not delete data or records.

The ACCDE format allows users to ________.

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters