Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

Which of the following is NOT true when creating a backup database?

Accepted Answer

A) In Access,you make backups by using the Back Up Database command. 
B) The Back Up Database command is available on Backstage view under Export. 
C) If you make multiple backup copies,you should give them different names. 
D) If you ever need a backup,simply return to the most recent copy that you have and start working with that file. 
A) In Access,you make backups by using the Back Up Database command. 
B) The Back Up Database command is available on Backstage view under Export. 
C) If you make multiple backup copies,you should give them different names. 
D) If you ever need a backup,simply return to the most recent copy that you have and start working with that file. B

Question 3

________ view shows how fields are defined.

Accepted Answer

Design

Question 4

The Query Wizard uses a question-and-answer dialog box to create a query.

Accepted Answer

A) True 
 B)False

Question 5

Access is a(n)________ DBMS.

Accepted Answer

A) automated 
B) linked 
C) relational 
D) form-based 
A) automated 
B) linked 
C) relational 
D) form-based

Question 6

Match the following report items with their definition.
I.Source
II.Report view
III.Print Preview
IV.Layout view
V.Design view
A.A table or query
B.Shows the report design but not the data
C.Shows the report and the data
D.Continuous page layout
E.Allows for changes to the page layout

Accepted Answer

The answer of Match the following report items with their...

Question 7

Which of the following is NOT true regarding tables and relational databases?

Accepted Answer

A) Tables store data organized in an arrangement of columns and rows. 
B) Do not use special characters,such as an underscore,in table names. 
C) The power of a relational database comes when you link tables. 
D) A relational database is a database where data is stored in tables with relationships between the tables. 
A) Tables store data organized in an arrangement of columns and rows. 
B) Do not use special characters,such as an underscore,in table names. 
C) The power of a relational database comes when you link tables. 
D) A relational database is a database where data is stored in tables with relationships between the tables.

Question 8

________ is data that has been manipulated and processed to make it meaningful.

Accepted Answer

The answer of ________ is data that has been manipulated...

Question 9

Match the following terms with their definition.
I.Database
II.Information
III.Data
IV.DBMS
V.Transaction-based database
A.A tool to work with data
B.Used to keep the business running
C.Facts about people,events,things,or ideas
D.Collection of records
E.Manipulated and processed facts

Accepted Answer

The answer of Match the following terms with their definition.
I.Database
II.Information
III.Data
IV.DBMS
V.Transaction-based...

Question 10

Match between columns
                        Premises: Database
Information
Data
DBMS
Transaction-based database

Accepted Answer

The Answer of A tool to work with data and is...

Question 11

In Access,you make backups by using the ________ command.

Accepted Answer

The answer of In Access,you make backups by using the...

Question 12

________ rearrange(s)objects to use disk space more efficiently,thus releasing the now unused space to be used again.

Accepted Answer

A) Backups 
B) Reports 
C) Queries 
D) Compacting 
A) Backups 
B) Reports 
C) Queries 
D) Compacting

Question 13

Which of the following is NOT a reason to use Access?

Accepted Answer

A) Access is an easily available DBMS. 
B) Access is often used by multiple users at the same time. 
C) Access allows for easy interaction with other products in the Office suite. 
D) Access allows you to create an app database and either give it to others or put it on the Windows App Store. 
A) Access is an easily available DBMS. 
B) Access is often used by multiple users at the same time. 
C) Access allows for easy interaction with other products in the Office suite. 
D) Access allows you to create an app database and either give it to others or put it on the Windows App Store.

Question 14

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

Accepted Answer

A) Navigation 
B) Property 
C) Forms 
D) Shutter 
A) Navigation 
B) Property 
C) Forms 
D) Shutter

Question 15

Match the following terms with their definition.
I.Datasheet view
II.Design view
III.Relationship
IV.Record
V.Field
A.A column of data
B.Shows the data contents within a table
C.A row of data
D.Shows how fields are defined
E.Links between tables

Accepted Answer

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

Question 16

While Access allows you to leave several tables open at the same time,it is a good idea to get into the habit of ________ a table when you are finished with it.

Accepted Answer

A) saving 
B) closing 
C) exporting 
D) renaming 
A) saving 
B) closing 
C) exporting 
D) renaming

Question 17

________ rearranges objects to use disk space more efficiently,thus releasing the now unused space to be used again.

Accepted Answer

The answer of ________ rearranges objects to use disk space...

Question 18

When you open a database,Access displays the ________ on the left side.

Accepted Answer

A) Navigation Pane 
B) Property Sheet 
C) Forms Pane 
D) Shutter Bar Pane 
A) Navigation Pane 
B) Property Sheet 
C) Forms Pane 
D) Shutter Bar Pane

Question 19

A ________ is a structure of a database with tables,fields,forms,queries,and reports.

Accepted Answer

A) template 
B) view 
C) pattern 
D) sample 
A) template 
B) view 
C) pattern 
D) sample

Question 20

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

Accepted Answer

The answer of The power of a database system comes...

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

Which of the following is NOT true when creating a backup database?

________ view shows how fields are defined.

The Query Wizard uses a question-and-answer dialog box to create a query.

Access is a(n)________ DBMS.

Match the following report items with their definition. I.Source II.Report view III.Print Preview IV.Layout view V.Design view A.A table or query B.Shows the report design but not the data C.Shows the report and the data D.Continuous page layout E.Allows for changes to the page layout

Which of the following is NOT true regarding tables and relational databases?

________ is data that has been manipulated and processed to make it meaningful.

Match the following terms with their definition. I.Database II.Information III.Data IV.DBMS V.Transaction-based database A.A tool to work with data B.Used to keep the business running C.Facts about people,events,things,or ideas D.Collection of records E.Manipulated and processed facts

In Access,you make backups by using the ________ command.

________ rearrange(s)objects to use disk space more efficiently,thus releasing the now unused space to be used again.

Which of the following is NOT a reason to use Access?

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

Match the following terms with their definition. I.Datasheet view II.Design view III.Relationship IV.Record V.Field A.A column of data B.Shows the data contents within a table C.A row of data D.Shows how fields are defined E.Links between tables

While Access allows you to leave several tables open at the same time,it is a good idea to get into the habit of ________ a table when you are finished with it.

________ rearranges objects to use disk space more efficiently,thus releasing the now unused space to be used again.

When you open a database,Access displays the ________ on the left side.

A ________ is a structure of a database with tables,fields,forms,queries,and reports.

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

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

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

Which of the following is NOT true when creating a backup database?

________ view shows how fields are defined.

The Query Wizard uses a question-and-answer dialog box to create a query.

Access is a(n)________ DBMS.

Match the following report items with their definition. I.Source II.Report view III.Print Preview IV.Layout view V.Design view A.A table or query B.Shows the report design but not the data C.Shows the report and the data D.Continuous page layout E.Allows for changes to the page layout

Which of the following is NOT true regarding tables and relational databases?

________ is data that has been manipulated and processed to make it meaningful.

Match the following terms with their definition. I.Database II.Information III.Data IV.DBMS V.Transaction-based database A.A tool to work with data B.Used to keep the business running C.Facts about people,events,things,or ideas D.Collection of records E.Manipulated and processed facts

In Access,you make backups by using the ________ command.

________ rearrange(s)objects to use disk space more efficiently,thus releasing the now unused space to be used again.

Which of the following is NOT a reason to use Access?

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

Match the following terms with their definition. I.Datasheet view II.Design view III.Relationship IV.Record V.Field A.A column of data B.Shows the data contents within a table C.A row of data D.Shows how fields are defined E.Links between tables

While Access allows you to leave several tables open at the same time,it is a good idea to get into the habit of ________ a table when you are finished with it.

________ rearranges objects to use disk space more efficiently,thus releasing the now unused space to be used again.

When you open a database,Access displays the ________ on the left side.

A ________ is a structure of a database with tables,fields,forms,queries,and reports.

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

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