Question 1

Access' graphical query interface translates statements into ________.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

In Access,entities are called ________.

Accepted Answer

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

Question 4

A report ______________ can be used to create a report.

Accepted Answer

A)  wizard 
B)  queries 
C)  tables 
D)  modules 
E)  forms 
A)  wizard 
B)  queries 
C)  tables 
D)  modules 
E)  forms

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

It is possible to create a primary key composed of ___________ columns or fields.

Accepted Answer

A)  relational 
B)  linked 
C)  number 
D)  multiple 
E)  text 
A)  relational 
B)  linked 
C)  number 
D)  multiple 
E)  text

Question 9

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 10

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

Accepted Answer

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

Question 11

In a query of two or more tables Access will show

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Access displays the _____________of a field as help text on forms.

Accepted Answer

A)  description 
B)  data type 
C)  name 
D)  colour 
E)  attribute 
A)  description 
B)  data type 
C)  name 
D)  colour 
E)  attribute

Question 15

When defining a relationship between two tables in Access,it is important to be sure to drag the correct ________ in the right direction and lay it on the other table.

Accepted Answer

A)  relationship 
B)  attribute 
C)  window 
D)  key 
E)  table 
A)  relationship 
B)  attribute 
C)  window 
D)  key 
E)  table

Question 16

Relationships are created in the relationships window 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 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Access' graphical query interface translates statements into ________.

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

In Access,entities are called ________.

A report ______________ can be used to create a report.

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

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

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

It is possible to create a primary key composed of ___________ columns or fields.

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

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

In a query of two or more tables Access will show

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

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

Access displays the _____________of a field as help text on forms.

When defining a relationship between two tables in Access,it is important to be sure to drag the correct ________ in the right direction and lay it on the other table.

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

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

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

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

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Database Design and Entity Relationships

Understanding MS Project: Features and Functions

Filters

Exam 16: Creating and Utilizing Forms, Queries, and Reports in MS Access

Access' graphical query interface translates statements into ________.

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

In Access,entities are called ________.

A report ______________ can be used to create a report.

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

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

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

It is possible to create a primary key composed of ___________ columns or fields.

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

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

In a query of two or more tables Access will show

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

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

Access displays the _____________of a field as help text on forms.

When defining a relationship between two tables in Access,it is important to be sure to drag the correct ________ in the right direction and lay it on the other table.

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

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

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

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

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Database Design and Entity Relationships

Understanding MS Project: Features and Functions

Filters