Question 1

There are a specific set of tasks that need to be completed when building a business report.Which of these is not a part of the first three tasks?
A)Choose tables and/or queries
B)Edit relationships
C)Choose fields
D)Click on Create and Report Wizard

Accepted Answer

Editing relationships is not one of the first three steps involved in building a business report.

Question 2

The default length for a text field is 225 characters.

Accepted Answer

The Field Size defaults to 255 characters.

Question 3

If you needed to print the date in the report footer,what function would you use?
A)dt.now
B)date?
C)&date
D)=Now()

Accepted Answer

In the Page Footer section,the box with "Now()" is the command that places the date at the bottom of each page of our report.The box to the right keeps track of the current page and the total number of pages.

Question 4

When generating a new report,within which screen is the Summary Option button located?
A)Top-level grouping
B)Further grouping
C)Sorting
D)Field properties

Accepted Answer

The sorting screen has a Summary Options button.

Question 5

Microsoft Access's data manipulation subsystem is used to enter and change information and build queries.

Accepted Answer

Microsoft Access's data manipulation subsystem is used to enter and change information and build queries.

Question 6

If you needed a title to print on the top of each page of a multi-page report,where would you place this title in the report design?
A)First line of the detail
B)Group header
C)Report header
D)Page header

Accepted Answer

Page headers allow the words to spread over two lines and avoid the overlapping.The headers can also be spaced out so that they are distributed more evenly over the page.

Question 7

Microsoft Excel is the most popular database management system software.

Accepted Answer

Microsoft Access is the most popular DBMS software.

Question 8

How can you change the structure of the form?
A)Click on File Menu and then click Display Properties.
B)Double-click Insert tab and then select Change View.
C)Double click View tab and select Edit Relationships.
D)Right-click on the Order tab and then select Design View.

Accepted Answer

You can change the structure of the form by right-clicking on the Order tab and then selecting Design View.

Question 9

Individuals seeking employment today have a competitive advantage if they have knowledge of database management system software.

Accepted Answer

Today,the competitive advantage for many people seeking employment is knowledge of database management system software.

Question 10

Access assumes that the first field name is ID and that its Data Type is AutoNumber,meaning that the first record will have an ID of 1,the second will have 2,and so on.

Accepted Answer

Access assumes that the first field name is ID and that its Data Type is AutoNumber,meaning that the first record will have an ID of 1,the second will have an ID of 2,and so on.If this is the format you want for the first field,you can accept it and move to defining the second field.

Question 11

Microsoft Access's application generation subsystem is used to create reports and input forms.

Accepted Answer

Microsoft Access's application generation subsystem is used to create reports and input forms.

Question 12

The two main ways for creating a data dictionary in Microsoft Access are in Report View and Design View.

Accepted Answer

There are two main ways to create the data dictionary for a given relation: in Datasheet View;and in Design View.

Question 13

Before you can enter information into a database system,you must first create the structure of the database by creating its data dictionary and then define the correct structure of the database.

Accepted Answer

You must first define the correct structure of the database,and then create the structure of the database by creating its data dictionary before entering any information.

Question 14

One of Microsoft's Access's biggest advantages is that you can start typing information immediately into a database.

Accepted Answer

You can't simply start typing information into a database as you can when you create a document with Word or a workbook with Excel.

Question 15

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add,modify,or delete existing records?
A)Table
B)Queries
C)Forms
D)Reports

Accepted Answer

You can make field areas longer or shorter,change text colors,add and remove fields and labels,and so on,using forms.

Question 16

The data dictionary includes a description of each relation and each piece of information in each relation.

Accepted Answer

The data dictionary includes a description of each relation (also called a table or file)and each piece of information in each relation.

Question 17

In a database management system,the word relation is also called a table or file.

Accepted Answer

In a database management system,the word relation is also called a table or file.

Question 18

The data mart contains the logical structure for the information in a database.

Accepted Answer

The data dictionary contains the logical structure for the information in a database.

Question 19

If you needed to create a statement of accounts that would be printed at the end of each month,what Access tool would you use?
A)QBE tools
B)Reports
C)Word processor
D)Editing tools

Accepted Answer

A report is designed for human consumption;that is,it has the information arranged so that it looks nice and is easy to read.

Question 20

If you needed a title to print on the first page of a multi-page report,where would you place this title in the report design?
A)Report header
B)Page header
C)Detail
D)Legend

Accepted Answer

Report header allows us to enter a title for the report.

Quiz 19: Implementing a Database With Microsoft Access

There are a specific set of tasks that need to be completed when building a business report.Which of these is not a part of the first three tasks?

The default length for a text field is 225 characters.

If you needed to print the date in the report footer,what function would you use?

When generating a new report,within which screen is the Summary Option button located?

Microsoft Access's data manipulation subsystem is used to enter and change information and build queries.

If you needed a title to print on the top of each page of a multi-page report,where would you place this title in the report design?

Microsoft Excel is the most popular database management system software.

How can you change the structure of the form?

Individuals seeking employment today have a competitive advantage if they have knowledge of database management system software.

Access assumes that the first field name is ID and that its Data Type is AutoNumber,meaning that the first record will have an ID of 1,the second will have 2,and so on.

Microsoft Access's application generation subsystem is used to create reports and input forms.

The two main ways for creating a data dictionary in Microsoft Access are in Report View and Design View.

Before you can enter information into a database system,you must first create the structure of the database by creating its data dictionary and then define the correct structure of the database.

One of Microsoft's Access's biggest advantages is that you can start typing information immediately into a database.

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add,modify,or delete existing records?

The data dictionary includes a description of each relation and each piece of information in each relation.

In a database management system,the word relation is also called a table or file.

The data mart contains the logical structure for the information in a database.

If you needed to create a statement of accounts that would be printed at the end of each month,what Access tool would you use?

If you needed a title to print on the first page of a multi-page report,where would you place this title in the report design?