Question 1

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

Accepted Answer

A) True 
 B)False

Question 2

In Access,entities are called __________.

Accepted Answer

A) fields 
B) rows 
C) queries 
D) columns 
E) tables 
A) fields 
B) rows 
C) queries 
D) columns 
E) tables

Question 3

__________are used by the user to enter data in to an Access database.

Accepted Answer

A) Reports 
B) Forms 
C) Modules 
D) Queries 
E) Tables 
A) Reports 
B) Forms 
C) Modules 
D) Queries 
E) Tables

Question 4

A question one asks of the database is known as a(n)

Accepted Answer

A) query. 
B) form. 
C) table. 
D) report. 
E) result. 
A) query. 
B) form. 
C) table. 
D) report. 
E) result.

Question 5

Database forms allow the users to view,add,update or__________data in the underlying  tables.

Accepted Answer

The answer of Database forms allow the users to view,add,update...

Question 6

MS Access makes it easy to generate database queries by providing an easy -to -use __________that generates SQL statements automatically.

Accepted Answer

The answer of MS Access makes it easy to generate...

Question 7

Before creating a database in Access,you should develop a data model based on the user requirements.

Accepted Answer

A) True 
 B)False

Question 8

__________are used to summarize data on paper.

Accepted Answer

A) Queries 
B) Forms 
C) Reports 
D) Modules 
E) Tables 
A) Queries 
B) Forms 
C) Reports 
D) Modules 
E) Tables

Question 9

A data entry form in Access can be created using the Form tool in the Create tab ribbon.

Accepted Answer

A) True 
 B)False

Question 10

Relationships are created by clicking on the primary key in one table and dragging it to the related field in another table.

Accepted Answer

A) True 
 B)False

Question 11

Why are queries so useful and how are they created in MS Access?

Accepted Answer

Creating database queries shows the true

Question 12

The key icon can be found in the__________ tab ribbon.

Accepted Answer

A) Datasheet 
B) Home 
C) Design 
D) Database Tools 
E) Create 
A) Datasheet 
B) Home 
C) Design 
D) Database Tools 
E) Create

Question 13

The description in the table design window is used for __________.

Accepted Answer

A) documentation 
B) additional data type information 
C) additional field name information 
D) formatting fields 
E) setting properties 
A) documentation 
B) additional data type information 
C) additional field name information 
D) formatting fields 
E) setting properties

Question 14

In order to execute a query in MS Access,create the query and then click on the__________ icon.

Accepted Answer

The answer of In order to execute a query in...

Question 15

Queries in Access are translated into  __________ by the query graphical interface.

Accepted Answer

The answer of Queries in Access are translated into ...

Question 16

Access provides a graphical________for creating queries.

Accepted Answer

The answer of Access provides a graphical________for creating queries....

Question 17

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

Accepted Answer

A) True 
 B)False

Question 18

In a query of two or more tables Access will will show

Accepted Answer

A) only records in the parent table 
B) every record in one table joined to each record in the other table. 
C) only records the have matching values in all the tables. 
D) only records that do not have matching records in all the tables. 
E) all the relevant records in both/all tables. 
A) only records in the parent table 
B) every record in one table joined to each record in the other table. 
C) only records the have matching values in all the tables. 
D) only records that do not have matching records in all the tables. 
E) all the relevant records in both/all tables.

Question 19

The most common data type for fields in tables is always the "number" data type.

Accepted Answer

A) True 
 B)False

Question 20

Access provides a graphical user interface for creating database queries.

Accepted Answer

A) True 
 B)False

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

In Access,entities are called __________.

__________are used by the user to enter data in to an Access database.

A question one asks of the database is known as a(n)

Database forms allow the users to view,add,update or__________data in the underlying tables.

MS Access makes it easy to generate database queries by providing an easy -to -use __________that generates SQL statements automatically.

Before creating a database in Access,you should develop a data model based on the user requirements.

__________are used to summarize data on paper.

A data entry form in Access can be created using the Form tool in the Create tab ribbon.

Relationships are created by clicking on the primary key in one table and dragging it to the related field in another table.

Why are queries so useful and how are they created in MS Access?

The key icon can be found in the__________ tab ribbon.

The description in the table design window is used for __________.

In order to execute a query in MS Access,create the query and then click on the__________ icon.

Queries in Access are translated into __________ by the query graphical interface.

Access provides a graphical________for creating queries.

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

In a query of two or more tables Access will will show

The most common data type for fields in tables is always the "number" data type.

Access provides a graphical user interface for creating database queries.

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

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

In Access,entities are called __________.

__________are used by the user to enter data in to an Access database.

A question one asks of the database is known as a(n)

Database forms allow the users to view,add,update or__________data in the underlying tables.

MS Access makes it easy to generate database queries by providing an easy -to -use __________that generates SQL statements automatically.

Before creating a database in Access,you should develop a data model based on the user requirements.

__________are used to summarize data on paper.

A data entry form in Access can be created using the Form tool in the Create tab ribbon.

Relationships are created by clicking on the primary key in one table and dragging it to the related field in another table.

Why are queries so useful and how are they created in MS Access?

The key icon can be found in the__________ tab ribbon.

The description in the table design window is used for __________.

In order to execute a query in MS Access,create the query and then click on the__________ icon.

Queries in Access are translated into __________ by the query graphical interface.

Access provides a graphical________for creating queries.

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

In a query of two or more tables Access will will show

The most common data type for fields in tables is always the "number" data type.

Access provides a graphical user interface for creating database queries.

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