Question 1

To see how a report would look on a piece of paper,open the report in ________.

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 2

The Query Wizard uses a(n)________ dialog box to create a query.

Accepted Answer

The answer of The Query Wizard uses a(n)________ dialog box...

Question 3

Redundant information leads to ________.

Accepted Answer

The answer of Redundant information leads to ________....

Question 4

A record is all of the data pertaining to one person,place,thing,or event.

Accepted Answer

A) True 
 B)False

Question 5

If no sort criteria is specified when creating a query,Access will sort the results by the ________.

Accepted Answer

A)  first text field 
B)  first numeric field 
C)  foreign key 
D)  primary key 
A)  first text field 
B)  first numeric field 
C)  foreign key 
D)  primary key

Question 6

Data is always stored in a form.

Accepted Answer

A) True 
 B)False

Question 7

Access has six main objects.

Accepted Answer

A) True 
 B)False

Question 8

The process of copying data from another file,like a Word document,into an Access database is called ________.

Accepted Answer

The answer of The process of copying data from another...

Question 9

The ________ operator in a query selects the records in which the field values listed are within the two values.

Accepted Answer

A) Between B) C) > = D) < = A) Between B) C) > = D) < =

Question 10

In a database,data is stored in a ________.

Accepted Answer

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

Question 11

Match between columns Premises: = Between <= >= <>

Accepted Answer

The Answer of Selects records in which the field value is...

Question 12

Which of the following is NOT true about databases?

Accepted Answer

A)  In business, data is collected and used for decision making. 
B)  Information is data that has been manipulated. 
C)  A database eliminates the need for a paper-based system. 
D)  Databases are used for operational processing and for analytical purposes. 
A)  In business, data is collected and used for decision making. 
B)  Information is data that has been manipulated. 
C)  A database eliminates the need for a paper-based system. 
D)  Databases are used for operational processing and for analytical purposes.

Question 13

Microsoft ________ 2016 is Microsoft's most current database management system.

Accepted Answer

A)  PowerPoint 
B)  Access 
C)  Word 
D)  Excel 
A)  PowerPoint 
B)  Access 
C)  Word 
D)  Excel

Question 14

Which of the following is NOT true about compacting and repairing a database?

Accepted Answer

A)  The compact option also looks for damaged data and tries to repair it. 
B)  There are four options for compacting a database. 
C)  Compacting releases unused space to be used again. 
D)  If you do not compact your database, it can become very large quickly. 
A)  The compact option also looks for damaged data and tries to repair it. 
B)  There are four options for compacting a database. 
C)  Compacting releases unused space to be used again. 
D)  If you do not compact your database, it can become very large quickly.

Question 15

The file extension for a 2002-2003 Access database file that is in "execute only" mode is ________.

Accepted Answer

A)  accde 
B)  mdb 
C)  mde 
D)  accdt 
A)  accde 
B)  mdb 
C)  mde 
D)  accdt

Question 16

The data contents within a table can be seen in ________ view.

Accepted Answer

The answer of The data contents within a table can...

Question 17

Match between columns
                        Premises: Database
Object
DBMS
Information
Data

Accepted Answer

The Answer of A software program and Can be used is...

Question 18

Backup options are available on ________ view.

Accepted Answer

The answer of Backup options are available on ________ view....

Question 19

The ________ view shows the query's structure.

Accepted Answer

A)  Query Results 
B)  SQL 
C)  Datasheet 
D)  Design 
A)  Query Results 
B)  SQL 
C)  Datasheet 
D)  Design

Question 20

Data ________ is created through repetition and causes inefficiencies.

Accepted Answer

The answer of Data ________ is created through repetition and...

To see how a report would look on a piece of paper,open the report in ________.

The Query Wizard uses a(n)________ dialog box to create a query.

Redundant information leads to ________.

A record is all of the data pertaining to one person,place,thing,or event.

If no sort criteria is specified when creating a query,Access will sort the results by the ________.

Data is always stored in a form.

Access has six main objects.

The process of copying data from another file,like a Word document,into an Access database is called ________.

The ________ operator in a query selects the records in which the field values listed are within the two values.

In a database,data is stored in a ________.

Which of the following is NOT true about databases?

Microsoft ________ 2016 is Microsoft's most current database management system.

Which of the following is NOT true about compacting and repairing a database?

The file extension for a 2002-2003 Access database file that is in "execute only" mode is ________.

The data contents within a table can be seen in ________ view.

Backup options are available on ________ view.

The ________ view shows the query's structure.

Data ________ is created through repetition and causes inefficiencies.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 11: The Four Main Database Objects

To see how a report would look on a piece of paper,open the report in ________.

The Query Wizard uses a(n)________ dialog box to create a query.

Redundant information leads to ________.

A record is all of the data pertaining to one person,place,thing,or event.

If no sort criteria is specified when creating a query,Access will sort the results by the ________.

Data is always stored in a form.

Access has six main objects.

The process of copying data from another file,like a Word document,into an Access database is called ________.

The ________ operator in a query selects the records in which the field values listed are within the two values.

In a database,data is stored in a ________.

Which of the following is NOT true about databases?

Microsoft ________ 2016 is Microsoft's most current database management system.

Which of the following is NOT true about compacting and repairing a database?

The file extension for a 2002-2003 Access database file that is in "execute only" mode is ________.

The data contents within a table can be seen in ________ view.

Backup options are available on ________ view.

The ________ view shows the query's structure.

Data ________ is created through repetition and causes inefficiencies.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters