Question 1

Each row in the design grid shows information about a record.

Accepted Answer

A) True 
 B)False

Question 2

Match the following query design grid items with their definition.
I.Field
II.Table
III.Sort
IV.Show
V.Criteria
A.Source
B.Content conditions
C.A check box
D.Specify the order of records
E.Top row

Accepted Answer

The answer of Match the following query design grid items...

Question 3

A database is a collection of records that are used for decision making,for sales and marketing,and for reporting purposes.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is NOT a main object in an Access database?

Accepted Answer

A) table 
B) script 
C) query 
D) report 
A) table 
B) script 
C) query 
D) report

Question 5

Match the following terms with their definition.
I.Navigation Pane
II.Shutter Bar
III.Search Box
IV.Tables and Related Views
V.Object Type
A.Default organization of objects
B.Used to display the Navigation Pane
C.Allows you to view the objects in the database
D.Helps you find objects
E.Objects are organized by tables

Accepted Answer

The answer of Match the following terms with their definition.
I.Navigation...

Question 6

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business decisions.

Accepted Answer

A) True 
 B)False

Question 7

Design view shows how fields are defined and structured.

Accepted Answer

A) True 
 B)False

Question 8

When designing a query without using an operator,________ is assumed.

Accepted Answer

The answer of When designing a query without using an...

Question 9

Which of the following is NOT true about database templates?

Accepted Answer

A) You can download a wide variety of templates from Microsoft's website Office.com. 
B) Templates are professionally designed databases that you can either use as is or adapt to suit your needs. 
C) Microsoft provides sample database templates used for managing assets,contacts,issues,projects,and tasks. 
D) A template is a sample database that has presupplied data 
A) You can download a wide variety of templates from Microsoft's website Office.com. 
B) Templates are professionally designed databases that you can either use as is or adapt to suit your needs. 
C) Microsoft provides sample database templates used for managing assets,contacts,issues,projects,and tasks. 
D) A template is a sample database that has presupplied data

Question 10

You can perform ________ Compact and Repair Database action at any time.

Accepted Answer

A) one 
B) two 
C) three 
D) four 
A) one 
B) two 
C) three 
D) four

Question 11

A DBMS is a ________.

Accepted Answer

A) database Microsoft system 
B) database management system 
C) data manipulation system 
D) database management service 
A) database Microsoft system 
B) database management system 
C) data manipulation system 
D) database management service

Question 12

Match the following terms with their definition.
I.Wizard
II.Query results
III.Run time
IV.Recordset
V.Query
A.Answers a question
B.A run time table
C.Uses a question-and-answer dialog box
D.A way to ask a question
E.Results are created each time

Accepted Answer

The answer of Match the following terms with their definition.
I.Wizard
II.Query...

Question 13

Reports have ________ views.

Accepted Answer

The answer of Reports have ________ views....

Question 14

Access is a relational DBMS program created by Microsoft.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT an advantage that automated databases have over paper databases?

Accepted Answer

A) Without paper databases,a business cannot compete. 
B) The information in databases is much easier to find in automated form. 
C) The information in automated databases can be manipulated and processed more rapidly. 
D) Automated databases can be used to enforce accuracy and other quality standards. 
A) Without paper databases,a business cannot compete. 
B) The information in databases is much easier to find in automated form. 
C) The information in automated databases can be manipulated and processed more rapidly. 
D) Automated databases can be used to enforce accuracy and other quality standards.

Question 16

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business ________.

Accepted Answer

The answer of Information includes facts about people,events,things,or ideas,and they...

Question 17

Query results are a recordset that provide an answer to a question posed in a query.

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is the file extension for an Access 2002-2003 database file.

Accepted Answer

A) ACCDB 
B) MDB 
C) MDE 
D) ACCDT 
A) ACCDB 
B) MDB 
C) MDE 
D) ACCDT

Question 19

________ shows how the report would look in a continuous page layout.

Accepted Answer

A) Report view 
B) Print Preview 
C) Layout view 
D) Design view 
A) Report view 
B) Print Preview 
C) Layout view 
D) Design view

Question 20

You can use Backstage view to modify an existing query.

Accepted Answer

A) True 
 B)False

Each row in the design grid shows information about a record.

Match the following query design grid items with their definition. I.Field II.Table III.Sort IV.Show V.Criteria A.Source B.Content conditions C.A check box D.Specify the order of records E.Top row

A database is a collection of records that are used for decision making,for sales and marketing,and for reporting purposes.

Which of the following is NOT a main object in an Access database?

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business decisions.

Design view shows how fields are defined and structured.

When designing a query without using an operator,________ is assumed.

Which of the following is NOT true about database templates?

You can perform ________ Compact and Repair Database action at any time.

A DBMS is a ________.

Match the following terms with their definition. I.Wizard II.Query results III.Run time IV.Recordset V.Query A.Answers a question B.A run time table C.Uses a question-and-answer dialog box D.A way to ask a question E.Results are created each time

Reports have ________ views.

Access is a relational DBMS program created by Microsoft.

Which of the following is NOT an advantage that automated databases have over paper databases?

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business ________.

Query results are a recordset that provide an answer to a question posed in a query.

A(n)________ is the file extension for an Access 2002-2003 database file.

________ shows how the report would look in a continuous page layout.

You can use Backstage view to modify an existing query.

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 1: Workshop 1: The Four Main Database Objects

Each row in the design grid shows information about a record.

Match the following query design grid items with their definition. I.Field II.Table III.Sort IV.Show V.Criteria A.Source B.Content conditions C.A check box D.Specify the order of records E.Top row

A database is a collection of records that are used for decision making,for sales and marketing,and for reporting purposes.

Which of the following is NOT a main object in an Access database?

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business decisions.

Design view shows how fields are defined and structured.

When designing a query without using an operator,________ is assumed.

Which of the following is NOT true about database templates?

You can perform ________ Compact and Repair Database action at any time.

A DBMS is a ________.

Match the following terms with their definition. I.Wizard II.Query results III.Run time IV.Recordset V.Query A.Answers a question B.A run time table C.Uses a question-and-answer dialog box D.A way to ask a question E.Results are created each time

Reports have ________ views.

Access is a relational DBMS program created by Microsoft.

Which of the following is NOT an advantage that automated databases have over paper databases?

Information includes facts about people,events,things,or ideas,and they are an important asset to any organization as information allows companies to make better business ________.

Query results are a recordset that provide an answer to a question posed in a query.

A(n)________ is the file extension for an Access 2002-2003 database file.

________ shows how the report would look in a continuous page layout.

You can use Backstage view to modify an existing query.

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters