Question 1

Which of the following is NOT true about databases?

Accepted Answer

A) Databases are used for two major purposes: for operational processing and for analytical purposes. 
B) The information in databases is summarized and classified to make data available to the decision makers. 
C) In operational or transaction-based databases,each sale or transaction that a business makes is tracked. 
D) Analytical databases are used for extracting data for decision making. 
A) Databases are used for two major purposes: for operational processing and for analytical purposes. 
B) The information in databases is summarized and classified to make data available to the decision makers. 
C) In operational or transaction-based databases,each sale or transaction that a business makes is tracked. 
D) Analytical databases are used for extracting data for decision making.

Question 2

Match between columns
                        Premises: ACCDB
ACCDT
ACCDE
MDB
MDE

Accepted Answer

The Answer of 2007-2013 Access database files and 2002-2003 Access is...

Question 3

Access is often used as a stand-alone DBMS,meaning a DBMS used by ________ users.

Accepted Answer

The answer of Access is often used as a stand-alone...

Question 4

The ________ row of the query design grid is the Field name.

Accepted Answer

A) top 
B) second 
C) third 
D) bottom 
A) top 
B) second 
C) third 
D) bottom

Question 5

The Back Up Database command is available on ________ view under Save As.

Accepted Answer

The answer of The Back Up Database command is available...

Question 6

A ________ is used to ask questions about your data.

Accepted Answer

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

Question 7

Access is often used as a stand-alone DBMS,meaning a DBMS used by multiple users.

Accepted Answer

A) True 
 B)False

Question 8

What you learn about Access is ________ to other relational DBMSs.

Accepted Answer

The answer of What you learn about Access is ________...

Question 9

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

Accepted Answer

The answer of If you select the ________ command,Access automatically...

Question 10

________ shows the report and the data; some report design such as field lengths and fonts can be changed in this view.

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

________ can help in cases of accidental deletion of data.

Accepted Answer

The answer of ________ can help in cases of accidental...

Question 13

How is Access different from Excel?

Accepted Answer

A) Access has numbered rows of data. 
B) Access allows you to manage data,perform calculations,and report on the data. 
C) Access allows multiple tables with relationships between the tables. 
D) Access has columns with labels. 
A) Access has numbered rows of data. 
B) Access allows you to manage data,perform calculations,and report on the data. 
C) Access allows multiple tables with relationships between the tables. 
D) Access has columns with labels.

Question 14

________ shows how the report would look on the printed page and allows you to change the 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 15

________ view of a table shows the data contents within a table.

Accepted Answer

The answer of ________ view of a table shows the...

Question 16

Importing is the process of copying data from another file,such as a Word file or Excel workbook,into a separate file,such as an Access database.

Accepted Answer

A) True 
 B)False

Question 17

When Access runs a query,it puts the results in a(n)________ order based on how the table is defined.

Accepted Answer

The answer of When Access runs a query,it puts the...

Question 18

A(n)________ is the file extension for an Access 2007-2013 database template.

Accepted Answer

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

Question 19

Which of the following is NOT true regarding businesses and databases?

Accepted Answer

A) Records are collected and used for decision making,for sales and marketing,and for reporting purposes. 
B) Businesses keep records about everything they do. 
C) The purpose of a database is to store,manage,and provide access to the business records. 
D) Today's businesses use automated databases to store their records and have completely eliminated paper-based systems. 
A) Records are collected and used for decision making,for sales and marketing,and for reporting purposes. 
B) Businesses keep records about everything they do. 
C) The purpose of a database is to store,manage,and provide access to the business records. 
D) Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.

Question 20

Data is information that has been manipulated and processed to make it meaningful.

Accepted Answer

A) True 
 B)False

Which of the following is NOT true about databases?

Access is often used as a stand-alone DBMS,meaning a DBMS used by ________ users.

The ________ row of the query design grid is the Field name.

The Back Up Database command is available on ________ view under Save As.

A ________ is used to ask questions about your data.

Access is often used as a stand-alone DBMS,meaning a DBMS used by multiple users.

What you learn about Access is ________ to other relational DBMSs.

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

________ shows the report and the data; some report design such as field lengths and fonts can be changed in this view.

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

________ can help in cases of accidental deletion of data.

How is Access different from Excel?

________ shows how the report would look on the printed page and allows you to change the page layout.

________ view of a table shows the data contents within a table.

Importing is the process of copying data from another file,such as a Word file or Excel workbook,into a separate file,such as an Access database.

When Access runs a query,it puts the results in a(n)________ order based on how the table is defined.

A(n)________ is the file extension for an Access 2007-2013 database template.

Which of the following is NOT true regarding businesses and databases?

Data is information that has been manipulated and processed to make it meaningful.

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

Which of the following is NOT true about databases?

Access is often used as a stand-alone DBMS,meaning a DBMS used by ________ users.

The ________ row of the query design grid is the Field name.

The Back Up Database command is available on ________ view under Save As.

A ________ is used to ask questions about your data.

Access is often used as a stand-alone DBMS,meaning a DBMS used by multiple users.

What you learn about Access is ________ to other relational DBMSs.

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

________ shows the report and the data; some report design such as field lengths and fonts can be changed in this view.

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

________ can help in cases of accidental deletion of data.

How is Access different from Excel?

________ shows how the report would look on the printed page and allows you to change the page layout.

________ view of a table shows the data contents within a table.

Importing is the process of copying data from another file,such as a Word file or Excel workbook,into a separate file,such as an Access database.

When Access runs a query,it puts the results in a(n)________ order based on how the table is defined.

A(n)________ is the file extension for an Access 2007-2013 database template.

Which of the following is NOT true regarding businesses and databases?

Data is information that has been manipulated and processed to make it meaningful.

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