Deck 19: Implementing a Database With Microsoft Access

Question 1

A(n)_____ is a relation you create to eliminate a many-to-many relationship.

A)complex relation
B)intersection relation
C)query-by-example
D)integrity constraint

Answer 1

B
Explanation: An intersection relation is a relation you create to eliminate a many-to-many relationship.

Question 2

Once the structure of the database has been created,what is the next step?

A)Create the data dictionary
B)Determine what reports will be needed
C)Determine how the database can be queried
D)Determine integrity constraints

Answer 2

A
Explanation: 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 3

Which personal database management system software is the most popular?

A)Microsoft Access
B)Lotus Approach
C)Corel Paradox
D)dBase

Answer 3

A
Explanation: Today,the competitive advantage for many people seeking employment is knowledge of database management system software,of which Microsoft Access is the most popular.

Question 4

An intersection relation is sometimes called a(n)____.

A)composite relation
B)query-by-example
C)primary key
D)integrity constraint

Question 5

Using both Order Number and Product Code together as a primary key for an order entry system,eliminates what type of relationship?

A)1:1
B)1-to-many
C)Many-to-many
D)Many-to-1

Question 6

The competitive advantage for many people seeking employment is knowledge in which of the following software packages?

A)Word processing
B)Spreadsheets
C)Presentations
D)Database Management Systems

Question 7

Where does the information about field format and file sizes get stored in Microsoft Access?

A)Data dictionary
B)Field view
C)Field properties
D)Table view

Question 8

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

A)physical
B)logical
C)reporting
D)querying

Question 9

Which of the following is a one-step method for saving the changes you make to a table,query,form,or report in Microsoft Access?

A)Click on the File Menu
B)Click on the "Save as…" option
C)Click on the disk icon on the toolbar
D)Click on the folder icon on the toolbar

Question 10

Before information can be entered into a database,what is the first step you need to do?

A)Determine the many-to-many relationships
B)Determine who will have access to the information
C)Define the correct structure of the database
D)Establish user responsibility

Question 11

What is the name of Microsoft's database management system software?

A)Approach
B)Paradox
C)dBase
D)Access

Question 12

When developing a database structure in Microsoft Access,what icon is shown to the left of the field name to indicate that the field is a primary field?

A)Bullet
B)Format
C)Arrow
D)Key

Question 13

Which of the following is a key that consists of the primary key fields from two intersecting relations (files)?

A)Simple primary key
B)Metakey
C)Composite primary key
D)Integrity key

Question 14

Where does the information about a field (e.g. ,size,type,decimals)get stored in Microsoft Access?

A)Data dictionary
B)Field view
C)Field properties
D)Table view

Question 15

What are rules that help ensure the quality of information?

A)Information assurance
B)Composite constraints
C)Integrity constraints
D)Quality control

Question 16

For text fields,which of the following is the default field size?

A)25 characters
B)50 characters
C)100 characters
D)255 characters

Question 17

What is the name of a field that uniquely describes each record in a database?

A)Composite key
B)Foreign key
C)Primary key
D)Integrity key

Question 18

What key is a primary key of one file that appears in another file?

A)Composite key
B)Foreign key
C)Secondary key
D)Intersecting key

Question 19

Which of the following could you use to create a data dictionary in Microsoft Access?

A)Field view
B)Information view
C)Query view
D)Design view

Question 20

When defining a database structure,what does Access default to when identifying the first field?

A)Primary key
B)Composite key
C)Integrity key
D)Foreign key

Question 21

When you drag and drop a primary key onto a foreign key,what relationship does Microsoft Access assume it to be?

A)1:1
B)M:M
C)1:M
D)M:N

Question 22

What happens when you attempt to input incorrect information into a field that has an Enforce Referential Integrity option in effect?

A)Access automatically gives you a choice of file menus to correct the problem.
B)Access will automatically shut down.
C)Access will display a dialog box informing you of the problem.
D)Access will accept the information but warn you that there might be a problem.

Question 23

If you needed to identify inventory items whose stock was running low,which Access tool could help you find the answer?

A)Table Properties
B)Query-by-example
C)Referential Integrity
D)Forms

Question 24

What type of query seeks results based on some specification?

A)Requirement query
B)Conditional query
C)Situation query
D)Provisional query

Question 25

What is the fundamental difference between tables (or queries)and reports?

A)A table is designed for human consumption.
B)A report is designed for human consumption.
C)A report has rows and columns.
D)A table provides better readability.

Question 26

After typing in the appropriate information into each field,what key can be used to get to the next field?

A)Ctrl
B)Enter
C)Tab
D)Shift

Question 27

Which Access Wizard would you use if you want to generate a simple report?

A)Report Wizard
B)Report Generator
C)Report View
D)Report Bar

Question 28

Which of the following tasks do you need to be careful of,when making changes to the information in any of the relations (tables or files)of the database structure?

A)Deleting fields which establish relationships to other tables
B)Adding additional information in the tables
C)Deleting records in a relation
D)Changing records in a relation

Question 29

To change the structure of a relation (table or file),what needs to be open in Microsoft Access?

A)Datasheet View
B)Pivot Table View
C)Design View
D)Field View

Question 30

Once a QBE has been designed what do you click on,to actually get it to run?

A)Infinity symbol
B)Ampersand Mark
C)Exclamation point
D)Lightening Bolt

Question 31

What does the query-by-example tool in Access allow you to do?

A)Graphically design the answer to a question
B)Quickly change data found in a table
C)Create business reports
D)Learn how to use the features available to you in Access

Question 32

Where do you turn on the "Enforce Referential Integrity" option in Access?

A)Field Properties
B)Table Properties
C)Edit Relationships
D)Constraints

Question 33

Once you have entered all the information into a given table and closed the tab for that table,what happens to the information?

A)Access automatically gives you a choice of file menus.
B)Access automatically closes the table.
C)Access automatically saves the information.
D)Access automatically opens an empty table.

Question 34

When creating a simple query with one relation,you first open the file.Following this step,what area would you drag and drop the field names in order to run the query?

A)Table Grid
B)QBE Grid
C)Report Grid
D)Form Grid

Question 35

Which of the following options would be the correct way to construct a conditional query in one relation whereby to pass this course,you must have at passing grade of 75 or more?

A)Enter =75 in the Criteria parameter and then >75 right below
B)Enter =75 in the Criteria parameter and nothing anywhere else
C)Enter >75 in the Criteria parameter only
D)Enter >75 in the Criteria parameter and then <100 right below

Question 36

If you wanted to limit the output of data to transactions occurring after April 1,2009,what tab or object would you select?

A)Table
B)Queries
C)Forms
D)Reports

Question 37

What relationship exists when 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?

A)1:1
B)1:M
C)M:M
D)M:1

Question 38

When you're creating relationships,what Access option allows you to protect your database from inconsistent data?

A)Create Integrity Constraint
B)Enforce Referential Integrity
C)Cascading Rules
D)Link Keys

Question 39

When you drag and drop a foreign key onto a primary key,what does Microsoft Access assumes the relationship is?

A)1:1
B)M:M
C)1:M
D)M:1

Question 40

Which of the following phrases would indicate that you are entering information into a database table?

A)Appending the table
B)Populating the table
C)Colonizing the table
D)Inhibiting the table

Question 41

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

Question 42

The default length for a text field is 225 characters.

Question 43

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()

Question 44

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

Question 45

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

Question 46

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

Question 47

Microsoft Excel is the most popular database management system software.

Question 48

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.

Question 49

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

Question 50

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.

Question 51

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

Question 52

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

Question 53

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.

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

Access defaults to identifying the first field in a relation as the foreign key.

Question 62

Integrity constraints are the rules that help ensure the quality of information.

Question 63

When a primary key field is established,the ampersand icon is shown to the left of the field name.

Question 64

An intersection relation is also known as a composite relation.

Question 65

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is a many-to-many.

Question 66

Microsoft Access allows you to create relations among the various tables by identifying primary keys.

Question 67

A foreign key is a primary key of one file that appears in another file.

Question 68

Before you can create relationships between the primary and foreign keys in different tables,you must ensure that all the tables are closed.

Question 69

When you establish relationships between the primary and foreign key,Access can enforce integrity constraints and disallow inconsistent information being entered.

Question 70

Restricting new orders to customers with an ID already in the database is an example of integrity constraints.

Question 71

An intersection relation is a relation you create to eliminate a one-to-many relationship.

Question 72

To save the structure,you must click on the disk icon in the upper left corner of the screen.

Question 73

After entering information into each field of an Access table,you use the Shift key to get into the next field or row.

Question 74

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.

Question 75

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.

Question 76

A composite primary key consists of the primary key fields from two intersection relations.

Question 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).

Question 78

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.

Question 79

A primary key is a field that uniquely identifies a record within a relation or table.

Question 80

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.