Question 1

You build the links between tables using the___________window.

Accepted Answer

A) relationships 
B) mapping 
C) database relationships 
D) relationship wizard 
E) database diagram 
A) relationships 
B) mapping 
C) database relationships 
D) relationship wizard 
E) database diagram A

Question 2

When you create a new table Access automatically creates an ID field with a(n)__________data type.

Accepted Answer

A) date 
B) text 
C) hyperlink 
D) number 
E) autonumber 
A) date 
B) text 
C) hyperlink 
D) number 
E) autonumber E

Question 3

To create a report form two tables you can use the __________.

Accepted Answer

Report Wizard

Question 4

Forms allow users to view and maintain data in a database.

Accepted Answer

A) True 
 B)False

Question 5

What are data entry forms used for and how are they created in MS Access?

Accepted Answer

In order to help users view the data and

Question 6

What are reports used for ad how are they created in MS Access?

Accepted Answer

Reports allow users to place summarized

Question 7

In MS Access, __________ is a term that refers to the attributes that are described in the data model.

Accepted Answer

A) application 
B) table 
C) data 
D) key 
E) field 
A) application 
B) table 
C) data 
D) key 
E) field

Question 8

The second column at the top of the table design window contains the__________  of the field.

Accepted Answer

A) data type 
B) field name 
C) field size 
D) description 
E) properties 
A) data type 
B) field name 
C) field size 
D) description 
E) properties

Question 9

In MS Access,the __________ data type is used to generate a unique primary key.

Accepted Answer

A) integer 
B) text 
C) autonumber 
D) currency 
E) number 
A) integer 
B) text 
C) autonumber 
D) currency 
E) number

Question 10

Access does not allow users to create queries in SQL.

Accepted Answer

A) True 
 B)False

Question 11

A quick way of creating reports in Access is to use the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 12

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

Accepted Answer

A) True 
 B)False

Question 13

Access' graphical query interface translates statements into ___________

Accepted Answer

A) ASP 
B) SQL 
C) query 
D) C++ 
E) VBA 
A) ASP 
B) SQL 
C) query 
D) C++ 
E) VBA

Question 14

In a form you can_______over any data you wish to change

Accepted Answer

The answer of In a form you can_______over any data...

Question 15

The properties of each field are set at the__________ of the table design window.

Accepted Answer

A) bottom 
B) top 
C) centre 
D) left 
E) right 
A) bottom 
B) top 
C) centre 
D) left 
E) right

Question 16

Forms allow a user to view and maintain the __________  in a database.

Accepted Answer

The answer of Forms allow a user to view and...

Question 17

When creating relationship you should also select__________in the relationships dialog box.

Accepted Answer

A) cascade delete related fields 
B) cascade update related fields 
C) enforce referential integrity 
D) B and C only 
E) A,B and C only 
A) cascade delete related fields 
B) cascade update related fields 
C) enforce referential integrity 
D) B and C only 
E) A,B and C only

Question 18

When creating a new table in Access,the primary key is set by clicking on the__________ icon.

Accepted Answer

A) drive 
B) relationship 
C) exclamation mark 
D) key 
E) switch 
A) drive 
B) relationship 
C) exclamation mark 
D) key 
E) switch

Question 19

Access allows users to create tables in a design view.

Accepted Answer

A) True 
 B)False

Question 20

When designing a database the designer must recognize the __________involved in the business process.

Accepted Answer

A) value 
B) value added 
C) ambiguity 
D) data 
E) problems 
A) value 
B) value added 
C) ambiguity 
D) data 
E) problems

You build the links between tables using the___________window.

When you create a new table Access automatically creates an ID field with a(n)__________data type.

To create a report form two tables you can use the __________.

Forms allow users to view and maintain data in a database.

What are data entry forms used for and how are they created in MS Access?

What are reports used for ad how are they created in MS Access?

In MS Access, __________ is a term that refers to the attributes that are described in the data model.

The second column at the top of the table design window contains the__________ of the field.

In MS Access,the __________ data type is used to generate a unique primary key.

Access does not allow users to create queries in SQL.

A quick way of creating reports in Access is to use the Report Wizard.

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

Access' graphical query interface translates statements into ___________

In a form you can_______over any data you wish to change

The properties of each field are set at the__________ of the table design window.

Forms allow a user to view and maintain the __________ in a database.

When creating relationship you should also select__________in the relationships dialog box.

When creating a new table in Access,the primary key is set by clicking on the__________ icon.

Access allows users to create tables in a design view.

When designing a database the designer must recognize the __________involved in the business process.

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Extensions S: Using Collaboration Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions A: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters

Exam 5: Extensions B: Introduction to Microsoft Excel

You build the links between tables using the___________window.

When you create a new table Access automatically creates an ID field with a(n)__________data type.

To create a report form two tables you can use the __________.

Forms allow users to view and maintain data in a database.

What are data entry forms used for and how are they created in MS Access?

What are reports used for ad how are they created in MS Access?

In MS Access, __________ is a term that refers to the attributes that are described in the data model.

The second column at the top of the table design window contains the__________ of the field.

In MS Access,the __________ data type is used to generate a unique primary key.

Access does not allow users to create queries in SQL.

A quick way of creating reports in Access is to use the Report Wizard.

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

Access' graphical query interface translates statements into ___________

In a form you can_______over any data you wish to change

The properties of each field are set at the__________ of the table design window.

Forms allow a user to view and maintain the __________ in a database.

When creating relationship you should also select__________in the relationships dialog box.

When creating a new table in Access,the primary key is set by clicking on the__________ icon.

Access allows users to create tables in a design view.

When designing a database the designer must recognize the __________involved in the business process.

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Extensions S: Using Collaboration Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions A: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters