43.
When generating a new report, within which screen is the Summary Option
button located?
44.
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?
45.
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?
46.
If you needed to print the date in the report footer, what function would you
use?
47.
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?
48.
How can you change the structure of the form?
True / False Questions
49.
Individuals seeking employment today have a competitive advantage if they
have knowledge of database management system software.
50.
Microsoft Excel is the most popular database management system
software.
51.
Microsoft Access’s data manipulation subsystem is used to enter and
change information and build queries.
52.
Microsoft Access’s application generation subsystem is used to create
reports and input forms.
53.
One of Microsoft’s Access’s biggest advantages is that you can start typing
information immediately into a database.
54.
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.
55.
The data mart contains the logical structure for the information in a
database.
56.
The data dictionary includes a description of each relation and each piece
of information in each relation.
57.
In a database management system, the word relation is also called a table
or file.
58.
The two main ways for creating a data dictionary in Microsoft Access are in
Report View and Design View.
59.
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.
60.
The default length for a text field is 225 characters.
61.
Integrity constraints are the rules that help ensure the quality of
information.
62.
Restricting new orders to customers with an ID already in the database is
an example of integrity constraints.
63.
When creating the structure of a relation, the result of changing the Allow
Zero Length to No, means that something must be entered into this field
when a new record is added.
64.
Access defaults to identifying the first field in a relation as the foreign key.
65.
A primary key is a field that uniquely identifies a record within a relation or
table.
66.
When a primary key field is established, the ampersand icon is shown to the
left of the field name.
67.
In MS Access, to show that a field is a foreign key, Access will place an
image of a key to the left of the field name.
68.
To save the structure, you must click on the disk icon in the upper left
corner of the screen.
69.
A composite primary key consists of the primary key fields from two
intersection relations.
70.
An intersection relation is also known as a composite relation.
71.
An intersection relation is a relation you create to eliminate a one-to–many
relationship.
72.
Microsoft Access allows you to create relations among the various tables by
identifying primary keys.
73.
A foreign key is a primary key of one file that appears in another file.
74.
Before you can create relationships between the primary and foreign keys in
different tables, you must ensure that all the tables are closed.
75.
When you drag and drop a primary key onto a foreign key, Microsoft Access
assumes that the relationship is a many-to-many.
76.
In a one-to-many relationship (1:M), a primary key may appear many times
as a foreign key, and a foreign key must appear once and only once as a
primary key.