Question 1

A(n)________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Accepted Answer

A) AutoReport 
B) form 
C) AutoForm 
D) wizard 
A) AutoReport 
B) form 
C) AutoForm 
D) wizard

Question 2

Match the following objects with their definition.
I.Table
II.Form
III.Report
IV.Query
V.View
A.Used to enter,edit,delete or display records
B.Provides an easy-to-read view of data
C.Stores data in columns and rows
D.Ask questions about the data
E.Gives a different perspective

Accepted Answer

The answer of Match the following objects with their definition.
I.Table
II.Form
III.Report
IV.Query
V.View
A.Used...

Question 3

You are reading a report that shows Company A generated $2,000 last week.This would be ________.

Accepted Answer

A) knowledge 
B) a competitive advantage 
C) data 
D) information 
A) knowledge 
B) a competitive advantage 
C) data 
D) information

Question 4

When you open a database,Access displays the Navigation Pane on the right side.

Accepted Answer

A) True 
 B)False

Question 5

The power of a database system comes with the ability to link tables together.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: Table
Form
Report
Query
View

Accepted Answer

The Answer of Used to enter,edit,delete or display records and is...

Question 7

Which of the following is NOT true about creating new databases?

Accepted Answer

A) When you create a new database,you can design it yourself starting with an empty database. 
B) You can use a template; however,you need to create your own forms and reports. 
C) If you design your own database,you develop the tables,fields,and the relationships between the tables. 
D) If you build your own database,you need to decide what information you want to keep in your database,how this information should be grouped into tables,what relationships you need,and what queries and reports you need. 
A) When you create a new database,you can design it yourself starting with an empty database. 
B) You can use a template; however,you need to create your own forms and reports. 
C) If you design your own database,you develop the tables,fields,and the relationships between the tables. 
D) If you build your own database,you need to decide what information you want to keep in your database,how this information should be grouped into tables,what relationships you need,and what queries and reports you need.

Question 8

If you select ________,Access automatically compacts your database anytime you close it.

Accepted Answer

A) Compact Now 
B) Compact on Exit 
C) Compact on Close 
D) Compact and Repair Database 
A) Compact Now 
B) Compact on Exit 
C) Compact on Close 
D) Compact and Repair Database

Question 9

Match the following Access file extensions with their definition.
I.ACCDB
II.ACCDT
III.ACCDE
IV.MDB
V.MDE
A.2007-2013 Access database files
B.2002-2003 Access database files
C.2002-2003 "execute only" Access database files
D.2007-2013 "execute only" Access database files
E.2007-2013 Access database templates

Accepted Answer

The answer of Match the following Access file extensions with...

Question 10

Access is a(n)________ DBMS program created by Microsoft.

Accepted Answer

The answer of Access is a(n)________ DBMS program created by...

Question 11

A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Accepted Answer

A) True 
 B)False

Question 12

A ________ provides an easy-to-read format suitable for printing.

Accepted Answer

A) wizard 
B) macro 
C) form 
D) report 
A) wizard 
B) macro 
C) form 
D) report

Question 13

Access allows you to create an app database and either give it to others or put it on the ________.

Accepted Answer

The answer of Access allows you to create an app...

Question 14

________ is/are facts about people,events,things,or ideas.

Accepted Answer

A) Knowledge 
B) A competitive advantage 
C) Data 
D) Information 
A) Knowledge 
B) A competitive advantage 
C) Data 
D) Information

Question 15

Query results show records and fields created at ________,which means that the results are created each time you run the query.

Accepted Answer

The answer of Query results show records and fields created...

Question 16

Query results show records and fields created at recordset time,which means that the results are created each time you run the query.

Accepted Answer

A) True 
 B)False

Question 17

________ shows the report design but not the data.

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 18

Each ________ in the query design grid shows information about the field.

Accepted Answer

The answer of Each ________ in the query design grid...

Question 19

Match between columns
                        Premises: Datasheet view
Design view
Relationship
Record
Field

Accepted Answer

The Answer of A column of data and Shows the is...

Question 20

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

Accepted Answer

A) Table 
B) Report 
C) Form 
D) Design 
A) Table 
B) Report 
C) Form 
D) Design

A(n)________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Match the following objects with their definition. I.Table II.Form III.Report IV.Query V.View A.Used to enter,edit,delete or display records B.Provides an easy-to-read view of data C.Stores data in columns and rows D.Ask questions about the data E.Gives a different perspective

You are reading a report that shows Company A generated $2,000 last week.This would be ________.

When you open a database,Access displays the Navigation Pane on the right side.

The power of a database system comes with the ability to link tables together.

Which of the following is NOT true about creating new databases?

If you select ________,Access automatically compacts your database anytime you close it.

Access is a(n)________ DBMS program created by Microsoft.

A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

A ________ provides an easy-to-read format suitable for printing.

Access allows you to create an app database and either give it to others or put it on the ________.

________ is/are facts about people,events,things,or ideas.

Query results show records and fields created at ________,which means that the results are created each time you run the query.

Query results show records and fields created at recordset time,which means that the results are created each time you run the query.

________ shows the report design but not the data.

Each ________ in the query design grid shows information about the field.

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

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

A(n)________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Match the following objects with their definition. I.Table II.Form III.Report IV.Query V.View A.Used to enter,edit,delete or display records B.Provides an easy-to-read view of data C.Stores data in columns and rows D.Ask questions about the data E.Gives a different perspective

You are reading a report that shows Company A generated $2,000 last week.This would be ________.

When you open a database,Access displays the Navigation Pane on the right side.

The power of a database system comes with the ability to link tables together.

Which of the following is NOT true about creating new databases?

If you select ________,Access automatically compacts your database anytime you close it.

Access is a(n)________ DBMS program created by Microsoft.

A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

A ________ provides an easy-to-read format suitable for printing.

Access allows you to create an app database and either give it to others or put it on the ________.

________ is/are facts about people,events,things,or ideas.

Query results show records and fields created at ________,which means that the results are created each time you run the query.

Query results show records and fields created at recordset time,which means that the results are created each time you run the query.

________ shows the report design but not the data.

Each ________ in the query design grid shows information about the field.

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

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