77.
When you drag and drop a foreign key onto a primary key, Microsoft Access
assumes that the relationship is a many-to-one (M:1).
78.
When you establish relationships between the primary and foreign key,
Access can enforce integrity constraints and disallow inconsistent
information being entered.
79.
To populate an Access table, you simply double-click on the table name in
the list of tables on the far left side the screen.
80.
After entering information into each field of an Access table, you use the
Shift key to get into the next field or row.
81.
After entering information into a table, and closing the tab for that table, the
information is automatically saved by Access.
82.
To change the structure of the database, you must be in the datasheet
view.
83.
The easiest way to create a query is to use a query-by-example tool.
84.
A query-by-example tool helps you graphically design the answer to a
question.
85.
When creating a query in Query Design, you can drag and drop the fields
that you want in the query results into the QBE grid.
86.
Once a query has been constructed, you click on the lightning bolt icon in
87.
When entering text into the Criteria box, you must be careful that you have
the right letters (and digits and spaces, if applicable) in the right places.
88.
One of the downfalls of Microsoft Access as a database management
system is that it does not enable you to query information that resides in
two or more tables.
89.
When creating an advanced query using more than one relation, you must
ensure that the tables that need to reference each other have relationships
already defined.
90.
The fundamental difference between tables (or queries) and reports is that
a report is designed for human consumption.
91.
In Access, a report can be created using either Design View or with the
Report Wizard.
92.
When generating a report, Further Grouping allows you to choose the top
level ordering of your information for presentation.
93.
When viewing a report where information in a field has been cut off, it is
said to be truncated.
94.
If you want to place the date at the bottom of each page (Page Footer) of a
report, the command “=TODAY(0)” is used.
95.
Data input forms are designed to simplify the task of entering new
information.
Fill in the Blank Questions
96.
The competitive advantage for many people seeking employment is
knowledge of _____ software, of which Microsoft Access is the most
popular.
97.
_____ is the most popular database management system software.
98.
Microsoft Access’s data _____ subsystem is used to enter and change
information and build queries.
99.
Microsoft Access’s application _____ subsystem is used to create reports
and input forms.
100.
The data dictionary contains the _____ structure for the information in a
database.
101.
The _____ includes a description of each relation and each piece of
information in each relation.
102.
In a database management system, the word relation is also called a(n)
_____ or file.
103.
There are two main ways to create the data dictionary for e relation: in
______; and in ____.