BIS 245 Final Exam

click Filter in the Sort & Filter group and select Clear Filter.
click Remove Filter in the Sort & Filter group.
right click on any number in the Quantity column and select Clear filter from Quantity.
right click on any record in the table and select Clear filter from Quantity.

Criteria
Form
Query
Table

draw a paper design of the report.
identify all sources of data, fields and groups.
input the data.
select a reporting tool.

filter by selection with an equal condition.
filter by selection with a comparison operator.
filter by selection with an edit operator.
filter by form with a comparison operator.

print more detailed information on one record only.
provide additional field information on a record.
repeat data for each record in the record source.
All of the above

Hierarchical
Network
Relational
SQL

box.
diamond.
line.
triangle.

caption.
default value.
input mask.
rule.

design.
PivotTable.
report.
table.

An example of a setting is Yes (No Duplicates).
Indexing a table speeds the retrieval time.
Primary keys must be indexed.
Setting the index requires each record to be scanned sequentially.

form wizard.
expression builder.
report builder.
table wizard.

datasheet view.
design view.
layout view.
layout view or design view.

blank form.
form design.
form layout.
form wizard.

Changing data values in a query will not change data values in a table.
Data is not saved within a query.
Instructions on which data to display are saved within a query.
Instructions on the format to display data are saved within a query.

Datasheet
Design
Query
Result

Bar
Line
Pie
Scatter Plot

are measured in integer values.
cannot be subdivided into meaningful information.
could be subdivided into smaller and smaller units.
describe classifications or categories.

by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.

a combination of five letters.
a combination of six to eight letters in uppercase and lowercase, numbers, and symbols.
a word or name that is easy to remember by the user, such as the name of your children.
part of your account name.

a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database.
a certification authority is a commercial company that is highly regulated in most countries.
a fee is charged for the service of issuing and validating identities using a digital signature.
certification authority companies establish their own rules and regulations that users must follow.

migrate the database out of Access and into a larger DBMS.
move the database to its own dedicated server.
redesign your database applying 3NF principles.
use the Performance Analyzer and Table Analyzer to optimize the performance of the database.

It is the least used type of relationship.
OrderID is a unique identification number that would be used in the Orders table and Order Details table.
Each record in the Orders table may match one, more than one, or no records in the Order Details table.
Each record in a Orders table matches only one record in the Customers table.