Question 1

The ______________ keyword tells Access to present the text data in alphabetical order.

Accepted Answer

A)  order 
B)  table 
C)  plus 
D)  red 
E)  Ascending 
A)  order 
B)  table 
C)  plus 
D)  red 
E)  Ascending E

Question 2

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

Accepted Answer

Reports allow users to place summarized data either from tables or queries on paper in creative formats.They allow users to communicate better and turn data into information.In Access reports are best made by using the report wizard which allows users to build reports from 2 or more tables or queries.In many instances reports are built from queries,putting them into well formatted printouts.

Question 3

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 update it by entering new data,making changes,and deleting data,there are a variety of form options in Access.First,by clicking on the table itself in the Object Window,users can then view and modify data directly in the table.Another way is to use the Form Wizard in Access to guide you through the creation of a more customized form.There is also a form editor that will give developers even more control over the look and feel and content on the form.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Access provides a graphical user interface for creating database queries.

Accepted Answer

A) True 
 B)False

Question 6

_______________ is one of many reserved words in the Access environment.

Accepted Answer

A)  "Value" 
B)  "Data" 
C)  "Colour" 
D)  "Name" 
E)  "Variable" 
A)  "Value" 
B)  "Data" 
C)  "Colour" 
D)  "Name" 
E)  "Variable"

Question 7

In the table design mode in Access the field and data type are required to create an attribute.

Accepted Answer

A) True 
 B)False

Question 8

The relationships window allows users to define the relationships between tables.

Accepted Answer

A) True 
 B)False

Question 9

Access does not allow users to create queries in SQL.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

The key icon can be found in the ________ tab ribbon.

Accepted Answer

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

Question 12

Data entry forms in Access are used to generate reports.

Accepted Answer

A) True 
 B)False

Question 13

You build the links between tables using the ________ window.

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

In an _____________ field,Access creates values for the user.

Accepted Answer

A)  number 
B)  hyperlink 
C)  long integer 
D)  text 
E)  Autonumber 
A)  number 
B)  hyperlink 
C)  long integer 
D)  text 
E)  Autonumber

Question 16

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

Accepted Answer

Creating database queries shows the true

Question 17

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 18

Access allows users to create tables in a design view.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

________ ask questions about the data.

Accepted Answer

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

The ______________ keyword tells Access to present the text data in alphabetical order.

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

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

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

Access provides a graphical user interface for creating database queries.

_______________ is one of many reserved words in the Access environment.

In the table design mode in Access the field and data type are required to create an attribute.

The relationships window allows users to define the relationships between tables.

Access does not allow users to create queries in SQL.

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

The key icon can be found in the ________ tab ribbon.

Data entry forms in Access are used to generate reports.

You build the links between tables using the ________ window.

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

In an _____________ field,Access creates values for the user.

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

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

Access allows users to create tables in a design view.

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

________ ask questions about the data.

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

The ______________ keyword tells Access to present the text data in alphabetical order.

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

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

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

Access provides a graphical user interface for creating database queries.

_______________ is one of many reserved words in the Access environment.

In the table design mode in Access the field and data type are required to create an attribute.

The relationships window allows users to define the relationships between tables.

Access does not allow users to create queries in SQL.

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

The key icon can be found in the ________ tab ribbon.

Data entry forms in Access are used to generate reports.

You build the links between tables using the ________ window.

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

In an _____________ field,Access creates values for the user.

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

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

Access allows users to create tables in a design view.

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

________ ask questions about the data.

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