Question 1

Be careful before you delete a record from a table.

Accepted Answer

A) True 
 B)False

Question 2

What is not true about the Compact and Repair Database utility?

Accepted Answer

A) It can help when the data becomes corrupt. 
B) It can be set up to run automatically when a database is closed. 
C) It is used when the database gets too many records in it. 
D) It can reduce the size of a database. 
A) It can help when the data becomes corrupt. 
B) It can be set up to run automatically when a database is closed. 
C) It is used when the database gets too many records in it. 
D) It can reduce the size of a database.

Question 3

If you sorted a table which had 53 records by two fields,one ascending and the other descending,how many records would display?

Accepted Answer

A) It depends on how many of the fields are blank. 
B) 53 
C) 106 
D) It depends on how many of the fields contain exactly the same information. 
A) It depends on how many of the fields are blank. 
B) 53 
C) 106 
D) It depends on how many of the fields contain exactly the same information.

Question 4

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 5

When you format a date to display a certain way,you have changed the field's ________.

Accepted Answer

The answer of When you format a date to display...

Question 6

Match between columns
                        Premises: Module
Datasheet view
Compact and Repair Database
Database
Design view

Accepted Answer

The Answer of A collection of data organized as useful is...

Question 7

A primary key can be a combination of several fields.

Accepted Answer

A) True 
 B)False

Question 8

You can only sort records by one field.

Accepted Answer

A) True 
 B)False

Question 9

If you see plus signs (+)next to records in Datasheet view,then you know that two or more tables are related.

Accepted Answer

A) True 
 B)False

Question 10

DBMS stands for ________.

Accepted Answer

database m

Question 11

The ________ command helps you locate specific records.

Accepted Answer

The answer of The ________ command helps you locate specific...

Question 12

A ________ allows you to select only the records you want.

Accepted Answer

The answer of A ________ allows you to select only...

Question 13

When you click the Enable Content warning,the database is now ________.

Accepted Answer

A) trusted on this computer 
B) trusted for this session 
C) trusted for any computer 
D) unlocked 
A) trusted on this computer 
B) trusted for this session 
C) trusted for any computer 
D) unlocked

Question 14

Reports can draw data from tables or queries.

Accepted Answer

A) True 
 B)False

Question 15

Only the most complex databases have more than one table.

Accepted Answer

A) True 
 B)False

Question 16

You can create a(n)________ from your own database so that you can reuse its structure whenever you need.

Accepted Answer

The answer of You can create a(n)________ from your own...

Question 17

When you split a database,what object type is put in the back end?

Accepted Answer

A) Tables 
B) Forms 
C) Reports 
D) Macros and Modules 
A) Tables 
B) Forms 
C) Reports 
D) Macros and Modules

Question 18

What is not true about records?

Accepted Answer

A) They are displayed as rows in datasheet view. 
B) They represent categories of information that is stored in a database. 
C) They are a complete set of fields for a person,place,etc. 
D) They are stored in tables. 
A) They are displayed as rows in datasheet view. 
B) They represent categories of information that is stored in a database. 
C) They are a complete set of fields for a person,place,etc. 
D) They are stored in tables.

Question 19

What is not true about database relationships?

Accepted Answer

A) They are connections between two tables. 
B) They join tables on a common field. 
C) They allow for efficient database design. 
D) They tend to increase the overall file size of a database. 
A) They are connections between two tables. 
B) They join tables on a common field. 
C) They allow for efficient database design. 
D) They tend to increase the overall file size of a database.

Question 20

Which of the following views would you use to view or modify a table's structure?

Accepted Answer

A) Datasheet 
B) Form 
C) Design 
D) Layout 
A) Datasheet 
B) Form 
C) Design 
D) Layout

Be careful before you delete a record from a table.

What is not true about the Compact and Repair Database utility?

If you sorted a table which had 53 records by two fields,one ascending and the other descending,how many records would display?

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

When you format a date to display a certain way,you have changed the field's ________.

A primary key can be a combination of several fields.

You can only sort records by one field.

If you see plus signs (+)next to records in Datasheet view,then you know that two or more tables are related.

DBMS stands for ________.

The ________ command helps you locate specific records.

A ________ allows you to select only the records you want.

When you click the Enable Content warning,the database is now ________.

Reports can draw data from tables or queries.

Only the most complex databases have more than one table.

You can create a(n)________ from your own database so that you can reuse its structure whenever you need.

When you split a database,what object type is put in the back end?

What is not true about records?

What is not true about database relationships?

Which of the following views would you use to view or modify a table's structure?

Office 365 Common Features

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 2: Introduction to Access

Be careful before you delete a record from a table.

What is not true about the Compact and Repair Database utility?

If you sorted a table which had 53 records by two fields,one ascending and the other descending,how many records would display?

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

When you format a date to display a certain way,you have changed the field's ________.

A primary key can be a combination of several fields.

You can only sort records by one field.

If you see plus signs (+)next to records in Datasheet view,then you know that two or more tables are related.

DBMS stands for ________.

The ________ command helps you locate specific records.

A ________ allows you to select only the records you want.

When you click the Enable Content warning,the database is now ________.

Reports can draw data from tables or queries.

Only the most complex databases have more than one table.

You can create a(n)________ from your own database so that you can reuse its structure whenever you need.

When you split a database,what object type is put in the back end?

What is not true about records?

What is not true about database relationships?

Which of the following views would you use to view or modify a table's structure?

Office 365 Common Features

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters