BIS245 Database Essentials Business Lab

$74.00

BIS245 Database Essentials Business Lab
A small surgery center needs your help to create a database. The office manager…

 

 

SKU: BIS 245 Database Essentials for Business with Lab  Categories: , , , Tags: , , , , , , ,

Description

BIS245 Database Essentials Business Lab

BIS245 Database Essentials Business Lab

A+ Entire Course: A Small Surgery Center Case Study |iLab Week 1-7|Quiz Week 1-6|Discussions Week 1-7, 2 Sets| Final Exam

Recently Updated

A Small Surgery Center Case Study

https://www.hiqualitytutorials.com/product/bis245-small-surgery-center-case-study/

Scenario

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.

  1. Please identify the attributes and primary keys needed for each of the entities.
  2. Identify the data types you would use for each of the attributes.
  3. Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
    • Use the ER matrix to determine the relationships.
  4. Create an ER diagram using Visio based on your analysis.
  5. Identify all foreign keys needed in the database design.
  6. Create the database in Access and populate the tables.
  7. To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Activities

  1. Due Week 3: Submit your draft database design using MS Visio using a Conceptual Visio Drawing
  2. Due at the end of Week 5:
    1. Upload completed Visio Conceptual Design.
    2. A 3-5 page APA paper discussing the following topics:
      1. Discuss Database impact on the workplace,
      2. Discuss database benefits when businesses use queries,
      3. Forms, and reports.
      4. Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.

Preview Week 3:

Database & MS Visio Included

Preview Week 5:

The use of database systems cam impact various areas of business operations. These include customer management, inventory tracking, personnel…

BIS245 Database Essentials Business Lab

iLab Week 1-7 

https://www.hiqualitytutorials.com/product/bis245-ilab-week-1-7/

iLab Week 1 

https://www.hiqualitytutorials.com/product/bis245-ilab-week-1/

Scenario/Summary

You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models.

You will then open an existing Access database to explore database objects, and to experiment with simple data manipulation using filters and sorts, and to begin elementary work with relationships.

Upon completing this lab, you will be able to do the following.

Relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio.

Use experience gained in creating the first model to construct a similar conceptual model without the instructions.

Download an existing Microsoft Access database file. Open the database, find and identify different database objects in this database.

Part A: Step 4: YourName_Lab1.vsd (Visio Diagram)

Part B: Step 8: YourName_Lab1C_Questions.docx

Lab Week 2

https://www.hiqualitytutorials.com/product/bis245-ilab-week-2/

  1. Lab # : BSBA BIS245A-2
  2. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database
  3. Lab Overview—Scenario / Summary

COs:

  1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.
  2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.
  3. Given an existing relational database schema, evaluate and alter the database design for efficiency.
  4. Given an existing database structure demonstrating efficiency and integrity, design the physical tables.

Scenario:

You have been asked to create a conceptual database model using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain experience with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will then modify the model for implementation as a MS Access database. You will create and modify one conceptual model.

You will then create a MS Access database based on the model developed in Visio, creating the necessary tables and relationships.

Upon completing this lab, you will be able to

  1. Relying on detailed instructions, add two entities to the existing conceptual model (ERD), including attribute data types and required field lengths;
  2. Create a new MS Access database file;
  3. Using the model from Part A of the lab and relying on detailed instructions; create the first two tables in the database;
  4. Use the experience gained in creating the first two tables to add the remaining tables;
  5. Using the model from Part A of the lab and relying on detailed instructions; create the relationship between the first two tables in the database; and
  6. Use the experience gained in creating the first relationship to create the remaining relationships between the tables.
  7. Deliverables
SectionDeliverablePoints
Part AYourNameLab2.vsdx (Visio Diagram)
Part BYourNameLab2.accdb (Access Database)
  1. Lab Steps

Preparation

  1. Get the Visio diagram
    1. Download Lab2_StarterFile.vsdx file from your course Lab page, and save the file to your local drive.
  2. Using Citrix for MS Visio and/or MS Access
    1. If you are using the Citrix remote lab, follow the login instructions located in the Lab area in the Introduction and Resources area.
    2. You will have to upload the Lab2.vsdx file to your Citrix drive, or allow Citrix access to your system. Follow the instructions for uploading files to Citrix, located in the Lab area in the Introduction and Resources area.

BIS245 Database Essentials Business Lab

Lab Week 3

https://www.hiqualitytutorials.com/product/bis245-ilab-week-3/

Lab Overview

You have been asked to extend the database you developed in Lab 2 to also include customer data, to populate the tables in the database with sample data, and to create some queries using this data to illustrate how the database can supply information that is useful to management. The purpose of this lab is to provide experience with modifying a database, entering data into tables, and creating simple queries.

Using MS Visio, you will add a customers entity to the ERD you created in Lab 2. Based on the modified ERD, you will add the corresponding customers table to the MS Access database from Lab 2. You will then enter sample data into the tables in this database and create some basic queries to illustrate how data from the tables can be presented to satisfy managers’ information needs.

Upon completing this lab, you will be able to

  1. Modify an existing MS Visio ERD to include new entities and relationships;
  2. Modify an existing MS Access database to include new entities and relationships;
  3. Enter data into tables in a MS Access database using datasheet view; and
  4. Create and run simple queries in MS Access.

Deliverables

Part A: YourNameLab3.vsdx (Visio diagram)

Part B: YourNameLab3.accdb (Access database)

Lab Week 4

https://www.hiqualitytutorials.com/product/bis245-ilab-week-4/

Scenario/Summary

We can collect all the data in the world, however, if we can’t access it and use it, it is probably useless. Gaining knowledge from stored data can be very beneficial when it comes to making important business decisions. This lab will give the student practice in querying or questioning data. The lab begins with a simple example of query development using Access, then evolves to more complex queries, which the student should perform after completing the first exercise. The student can create a query with the wizard, or with query design view.

Upon completing this lab, you should be able to:

  • create a query by following lab instruction;
  • create a query by using either Query Designer or Query Wizard; and
  • interpret the results of queries.

Deliverables

Parts A & B: Submit the MS Access Database file YourName_Lab4.accdb that contains the queries created in this lab.

BIS245 Database Essentials Business Lab

Lab Week 5

https://www.hiqualitytutorials.com/product/bis245-ilab-week-5/

Scenario Summary

You have been asked to create a database model using the MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience normalizing the database to third normal form based on limited instructions, data requirements, and associated business rules.

The lab begins with creating a form in Access using the Form Wizard. After the form is created, the user can use themes to change the appearance of the form. The second part of the lab uses form design to create a form. Finally, the form will be customized.

Upon completing this lab, you will be able to

  • create a new Visio file for database design; and
  • using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.
  • create a form using form design; and
  • create a form using the form wizard.

Deliverables

  • Step 1:docx
  • Step 3:vsdx (Visio Diagram)
  • Step 5:accdb (Access Database)

Lab Week 6

https://www.hiqualitytutorials.com/product/bis245-ilab-week-6/

Lab Overview

Scenario/Summary

The purpose of this lab is to create Access reports. After a report is created, the student will sort the fields in different ways. The student can also delete fields in layout view and modify the appearance of the report by applying themes. In addition to the report generated by Access, the lab also uses report design to allow users to design their own reports.

Upon completing this lab, you should be able to

  • create a report and apply a theme for professional appearance of the report; and
  • use report design to generate your own report.

Deliverables

Submit your YourName_Lab6.accdb database, which will include the following reports created in the lab.

  • Part A: Step 1: Create a Simple Report—Lab6_Report1
  • Part A: Step 2:Create a Report Using Report Design—Lab6_Report2
  • Part A: Step 3:Creating Multitable Reports—Lab6_Report3
  • Part A: Step 4:Adding a Subreport—Lab6_Report4
  • Part A: Step 5:Create Mailing Labels—Lab6_Report5
  • Part B: Step 1:Create a Report—Lab6_Report6
  • Part B: Step 2:Create a Multitable Report—Lab6_Report7

BIS245 Database Essentials Business Lab

Lab Week 7

https://www.hiqualitytutorials.com/product/bis245-ilab-week-7/

Lab Overview

The purpose of this lab is to show the student how to create navigation systems for an Access application. Students will create a main navigation form, which links to additional navigation forms called enter data and view reports. Additionally, students will create forms to automate printing reports and closing or exiting the database. The enter data form allows you to open customer and city forms automatically. The view reports form allows the user to automatically open the customer list and customers by city reports. The print reports form will allow users to automatically print the reports. The exit database form allows users to close the database and exit the application entirely.

The navigation forms can provide some measure of security to the database as they may prevent users unfamiliar with Access from entering database objects directly. They make using Access more intuitive to use and can prevent new users from inadvertently damaging your database objects.

Deliverables

Submit the modified Lab7_Start.accdb file that you saved as YourName_Lab7.accdb to the Week 7 Lab for grading.

Part A: Develop the enter data, view reports, print reports, and customer database navigation forms.

Part B: Create the close database form and add it to the main database navigation form. Set the database options.

BIS245 Database Essentials Business Lab

Quiz Week 1-6 

https://www.hiqualitytutorials.com/product/bis245-quiz-week-1-6/

Quiz Week 1 

https://www.hiqualitytutorials.com/product/bis245-quiz-week-1/

(CO 1) A database that organizes data in a set of overlapping tables is which of the following?

Flat-file

Hierarchical

Object-oriented

Relational

(CO 1) To create a filtered list on a particular field in a record

Click on the home tab, advanced filter, and then filter by form.

Click on the home tab, filter, and then the find option.

Click on the home tab, filter, selection, and then pick your criteria.

Right click on an item in your field column and then click sort.

(CO 1) Which view best describes the image below?

Datasheet

Design

Form

Report

(CO 2) To add, delete, and edit fields in a table, use which of the following?

Datasheet view of a table

Design view of a table

Design view of a query

Report view

(CO 2) Types of relationships between tables do NOT include

one-to-one.

many-to-many.

primary-to-foreign.

many-to-one.

(CO 1) To display a subset of records based on certain criteria, use which of the following?

Filter

Form

Report

Table

(CO 1) A database management system (DBMS) is a collection of programs that

Store data.

Manage data.

Use collections of data.

All of the above

(CO 1) A filter is best described as

A subset of records from an object based on specified criteria.

A sorted list of records in an object.

A record list from a table.

Another name for a query.

(CO 1) To locate the tool to compact an Access database, click on the

File tab, options, current database, and select compact and repair database tools.

Home tab, advanced, and select compact and repair database tools.

Database tools tab, and select compact and repair database tools.

External data tab, and select compact and repair database tools.

(CO 2) To add, delete, and edit a record, use

Datasheet view of a table.

Design view of a table.

Design view of a query.

Report view.

(CO 1) Excel should be used instead of Access when

You have a small amount of data.

Your data needs to be regrouped in various views.

Your data needs connectivity to external databases.

Your data requires a relational database.

(TCO 1) A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a_____.

Field

Record

Table

Database

(TCO 1) Which database object would you use to find customers who are located in the same state?

Criteria

Form

Query

Report

(TCO 1) Examining the image below, which statement best describes what we see?

Six records have been filtered from a query called Employees.

Six records have been filtered on the Title field containing Sales Representative from the Employees table.

A table called Employees has been created from six filtered records.

A query called Employees has been created from a filtered table.

(TCO 1) The view in Access which looks similar to an Excel spreadsheet is:

Datasheet

Design

Form

Report

(TCO 1) On which tab is the Sort and Filter group found?

File

Home

Create

External Data

(TCO 2)  In using a web search engine, typing the website address in the proper place in the brower and then hitting enter is called:

Server setup

Presentation task

Client browsing

Systems application

(TCO 2) How many data types does Access recognize?

5

7

9

10

(TCO 1) You should use Excel over Access when:

You have a large amount of data

You need to group, sort, and total data based on various parameters

You need multiple related tables to store data

You require a series of What-if scenarios on your data

BIS245 Database Essentials Business Lab

Quiz Week 2

https://www.hiqualitytutorials.com/product/bis245-quiz-week-2/

(CO 2) Which of the following is not an Access table property?

Allow Zero Length

Format

Hyperlink

Unicode Compression

(CO 2) All of the following describe a large database system except

Different users may have different levels of access to data in the database.

Simultaneous logging into a database is not recommended.

Multiple users in the database are common.

The database could be split into a front and back end.

(CO 2) Primary keys can be created

As computer-generated fields.

From an existing single field.

From several existing fields.

All of the above

(CO 3) A relational table includes the following conditions except

Column entries and attributes must be the same data type.

Rows must be in order.

Cells contain a single data value.

Columns or attributes have a well defined range of values.

(CO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?

11/12/2011

12/11/2011

#12/11/2011#

Between #10/01/2011# And #11/12/2011#

(CO 4) Which of the following is NOT true of a hire date field?

A hire date is considered a constant.

A hire date would be defined as a date/time field.

Date arithmetic can be applied to a hire date field.

The years of service field, which shows how long an employee has been with the company.

(CO 4) Which of the following is NOT an Access data type?

Text

Currency

Name

Date/Time

(CO 2) Which of the following is NOT a data type in Access?

AutoNumber

Date/Time

Number

String

(CO 2) Which of the following is used as a symbol for an entity?

Box

Diamond

Line

Triangle

(CO 3) Which data type will increment automatically each time a new record is entered into a table?

AutoNumber

Currency

Date/Time

Number

(CO 3) All of the following are true about a property except

A datasheet view is used to display properties.

Referenced as an attribute.

Changes can be made with a property sheet.

Tables, forms, queries, and reports can have properties.

(CO 4) Storage space for a field is reserved with the

PNPI.

Field size property.

Indexed property.

Validation rule property.

(CO 2) What is the special character called to represent one or more characters in the criteria area of a query?

Delimiter

Operand

Wildcard

Operator

(TCO 2) To create a relationship between two tables, you need at least a

Data type

Query

Hyperlink

Primary key

(TCO 2) In an ER diagram, a crow’s foot is used

As a symbol for an entity.

To establish tuples.

To model attributes.

To point toward a child table.

(TCO 2) SQL is

Nonprocedural and record oriented.

Nonprocedural and table oriented.

Procedural and object oriented.

Procedural and record oriented.

(TCO 3) An associative table is which of the following?

A child of two parent tables that are in a many-to-many relationship

A child of a parent table that is in a one-to-many relationship

A child of a parent table that is in a one-to-one relationship

None of the above

(TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access?

Date/Time data types need no delimiters.

Date/Time data types need to be enclosed in single quotes.

Number data types require no delimiters.

Text data types require pound signs.

(TCO 3) A Text data type has a maximum character size of

50.

200.

255.

Limited only by memory

(TCO 3) The following describes characteristics of the caption property EXCEPT

Allows for spaces between words.

Appears in Datasheet, Report and Form views.

Can be used in place of a field name in an expression.

Can substitute a field name in Datasheet View.

(TCO 4) Which of the following is NOT an example of a primary key?

ISBN number for a textbook

Last name

Social Security Number

Student ID

(TCO 4) To ensure that a value of 15 or greater was entered into a field, you would use a

Field size

Field type

Sarbanes-Oxley Act

Validation rule

(TCO 2) In Access, which item below is NOT considered a logical operator?

Equal

And

Not

Or

BIS245 Database Essentials Business Lab

Quiz Week 3 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-3/

(CO 2) Physical design refers to

Developing a database model that will support company operations.

Purchasing your hardware components.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
(CO 2) A domain is a

Group of data types that describe what kind of information that may be stored in a field.

Model of the database.

Set of values.

The set of primary and foreign keys in a database.

(CO 2) A one-to-many relationship is

A relationship that guarantees that a record is unique.

An association between a record and its fields.

Used to describe attributes.

When a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

(CO 2) An associative table is

used to identify primary keys between tables.

a child of two parent tables that are in a many-to-many relationship.

an integrity element within a table relationship.

a tool that allows you to locate an excel file.

(CO 3) What does not define a composite key?

Using two or more fields as a primary key

Using three fields as a primary key

Using two fields as a primary key

Using one field as a primary key

(CO 4) All of the following are examples of primary keys except

employee ID.

social security number.

ISBN number on a textbook.

last name.
(CO 2) Which of the following is an example of an entity in a business?

Company

Business owner

CEO

Employees

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 3) Database design refers to

Developing a database model that will support company operations.

Focusing on understanding the business and its functional areas or business processes.

Selecting the specific hardware characteristics based on data storage and data access requirements.

The process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.

(CO 2) Which of the following is NOT a step in the database life cycle?

Database design

Maintenance and redevelopment

Performance

Testing

(CO 2) The term cardinality refers to

A count of the total records in a table.

A field which is a candidate for a primary key.

The number of records in a relationship.

The most important field in a table.

(CO 4) Which statement below is NOT true of one-to-many relationships?

It is the least-used type of relationship.

The table with the primary key must only have one occurrence of each value for the primary key.

The foreign key in the related table may have repeating values for the foreign key.

An example is that one employee may take multiple orders.

(CO 4) Which is NOT true of validation rules?

They enforce a size limit.

They check authenticity of data entered in a field.

An error message will appear if a rule is violated.

They protect from fraudulent practices.

(TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT:

Can you envision more than one instance of the entity?

Is there a variation over time?

Is the item to be modeled a person, place, thing, or an event?

Is the item to be modeled an attribute?

(TCO 2) Logical design refers to

Developing a database model that will support company operations.

Developing a thorough understanding of what needs to be done in developing a database.

Translating the conceptual design into the selected model for use in a database system.

Understanding the business and its functional areas or business processes.

(TCO 3) When troubleshooting a relationship, all of the following should be done EXCEPT

Creating a relationship between like data types.

Checking the size of fields to be used in the relationship.

Checking that the correct type of relationship is established.

Deleting the relationship and field, and then rebuilding.

(TCO 2) All of the following should be considered in designing a relational database EXCEPT

Compliance with PNPI regulations.

Design for safety with redundant data.

Design your database for 100-year usage.

Store data in its smallest parts.

(TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

A junction (associative) table is used.

Many matching records are found in each direction between tables.

May be used to connect to Oracle and other databases.

There must be at least two tables.

BIS245 Database Essentials Business Lab

(TCO 2) A primary key

Can be computer generated.

Consists of one field only that uniquely identifies each record in a table.

Is a relationship between two or more tables.

All of the above

(TCO 3) Which of the following does NOT describe data redundancy?

The same data exists in multiple tables.

The data is always in linked tables.

Data updating must be done in multiple table locations.

Data redundancy can result in data anomalies.

(TCO 4) To which of the following does the term cascading refer?

Data changes travel from one table to another.

Data is put in sequential order.

Queries can retrieve data at a faster rate.

Records are arranged in order.

(TCO 4) Which is NOT true of a calculated field?

It cannot be added to queries or reports.

The value of a calculated field is produced from an expression.

A calculated field references other fields.

The result is useful at the moment the calculation is made.

(TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire?

Date arithmetic

Constant

Date/time field

Calculated field

BIS245 Database Essentials Business Lab

Quiz Week 4 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-4/

(CO 1) When running a query, it is important to

Remember that the information can not be used for decision making.

Remember that the information can not be used in a report.

Evaluate the results for accuracy.

Return multiple text messages.

(CO 2) When constructing criteria for a query, you should use

No delimiters for number data types.

Quotes to enclose date/time data types.

Single quotes for number data types.

The pound sign to enclose text data.

(CO 2) Which of the following is NOT true of a single-table query?

It can be created using the simple query wizard.

Queries can be created using the query design tool.

You can overwrite table data using the datasheet view of a query.

The top portion of the query design view displays the fields and criteria for two tables.

(CO 2) Which of the following is a naming convention for field names?

Autonumber

Camelcase

Primary key

PPNI

(CO 2) A calculated field may contain the following elements except

An arithmetic operator.

A hyperlink.

A built in function with built in calculations.

A constant or value that doesn’t change.

(CO 2) Which of the following is NOT true of a birth date field?

A birth date is considered a constant.

A birth date would be defined as a date/time field.

A birth date should not be considered a calculated field.

Date arithmetic can be applied to a process date field.

(CO 6) An expression can be built to

Locate a record.

Complete a calculation or function.

Summarize a data source, such as a table or query.

Build only calculations.

(CO 6) Which of the following is true about a crosstab query?

It is an action query.

It is used to retrieve parameter data.

It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.

It summarizes unmatched records from a data source.

(CO 1) Which object, by definition, allows you to ask questions about the data stored in a database, such as which customers live in New Orleans and Seattle?

Criteria

Form

Query

Table

(CO 2) To locate a blank field, your criterion in a query would be

Blank

Empty

Null

Void

(CO 2) Which of the following is not a recommended practice for designing multitable queries?

Include only related tables in your query.

Remove join lines in query design to speed up query processing.

Related tables should be established before you design a multitable query.

Print a relationship report to guide you in selecting related tables.

(CO 2) Which of the following statements is true about queries?

Forms and queries are actually the same thing.

Queries can only be based on one table.

Queries can be based on one or more related tables.

The instructions to create a query are not stored in the database.

(CO 2) Which Access data type would you use to store $23.58?

Calculated

Currency

Money

Number

(CO 2) In Access, the bottom portion of query design view that displays the fields and criteria is known as the

Query design grid.

Show tables dialog.

Simple query wizard.

Query datasheet.

(CO 6) A parameter query is

A select query where the user provides the criterion at run time.

An action query used to modify data.

An aggregate query used to summarize field data.

Used to backup databases.

(CO 6) All of the following are true about a delete query except

A delete query is an action query.

Access will display a warning message before running the delete query.

It can be created by clicking the create tab, query wizard, and then select delete query.

It selects records from a table and then removes them from the table.

(TCO 1) Entity attributes are represented as

Fields

Files

Records

Tables

(TCO 2) All of the following are Access data types EXCEPT

Autonumber

Date/time

Number

String

(TCO 2) In Access, query results are displayed in which view?

Datasheet

Form

Recordset

Report

(TCO 2) Access has _____ data types

Six

Eight

10

12

(TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT

A junction table is used

Many matching records are found in each direction between tables

May be used to connect to Oracle and other databases

There must be at least four tables

(TCO 2) Another term for an expression is

Formula

Function

Parameter

Query

(TCO 2) Validation text

Changes the way text data is formatted

Determines the maximum length of a text field

Requires text data to be inputted correctly

Specifies the error message when a rule is violated

(TCO 2) In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the

Query design grid

Show Tables dialog

Simple Query Wizard

Query datasheet

(TCO 6) Which of the following does NOT describe data redundancy?

The same data exists in multiple tables

The data is always in linked tables

Data updating must be done in multiple table locations

Data redundancy can result in data anomalies

(TCO 6) Which of the following is NOT an action query?

Append

Delete

Make Table

Summarize

BIS245 Database Essentials Business Lab

Quiz Week 5 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-5/

(CO 2) A validation rule

Can prohibit values from being entered that may not meet a criterion.

Compares a field to a table.

Is an error message that appears when a value is incorrectly entered into a field.

Makes a value entered into a field appear in a particular format.

(CO 2) A field can be added to a report to

Values for two or more fields.

Show a default value.

Appear in a predefined dropdown list.

Add a picture or logo.

(CO 2) Using an input mask is complex, however, MS Access provides common input masks, such as

Phone number or social security number.

Social security number and date and time.

Phone number and address.

Social security number and last name.

(CO 2) A label wizard enables you to create

Reports.

A table.

Mailing labels.

A new window.

(CO 2) An input mask placed on a form will apply to

All forms based on that table.

All forms in the database.

All forms based on that table and the table itself.

That specific form only.

(CO 5) To edit a form, use the

design view.

datasheet view.

layout view.

layout view or design view.

(CO 5) A multiple items form displays

multiple records in a tabular layout similar to a datasheet.

a formula that displays the result.

information from only a query.

a macro to process field information.

(CO 2) A default value is

A predefined list of values that can be selected by the user.

A value that cannot be lower or higher than the selected limit.

A specific value that automatically appears in a field and has edit capabilities.

A specific value that automatically appears in a field that cannot be changed by the user.

(CO 2) Validation text is

An error message that provides instruction on what to fix when an incorrect value is entered into a field.

A list of predefined values that can be entered in a field.

A comparison of values entered in two fields.

A field that requires a value of characters or text only.

(CO 2) An input mask

Allows one record to have more than two field values.

Allows the user to type a social security number as 111223333 and it would display as 111-22-3333.

Confirms that a value greater than 100 is a valid value.

Is a list of values that are previously defined from which the user can select one item.

(CO 2) Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables?

Design view

Fields group

Lookup group

Lookup wizard

(CO 2) An input mask that will NOT accept a letter (A to Z) in a field value is

?

A

L

#

(CO 5) All of the following are performed in the design view of a form except

Adding pictures, lines, calculations, and controls.

Changing the size of the form sections.

Entering a data value.

Modifying the properties of a form.

(CO 5) A form type that displays records in a tabular format, but has more editing options is a(n)

Datasheet form.

Multiple items form.

Split form.

subform.

(CO 5) If you click on the form tool, you will open a(n)

Existing form.

New form in design view.

New form in layout view.

Wizard to design a form.

(CO 5) A split form is best defined as

Most effective when run again on one table.

A form that combines two views of the same record source. Sections may be displayed differently depending on the view.

Can perform complex What-if analyses.

Require a macro in order to be effective.

(CO 5) A form is altered in what view?

Layout view or design view

Database view

Datasheet view

Table view

(TCO 2) A required field that is used in entering data is a field that

Appears with a specific value

Can be left blank

Cannot be left blank

Is selected from a list of values

(TCO 2) An example of a lookup is

one to a million

2010

AL, CA, NC, NY, TX

SSN, Date, 111-22-3333, AZ

(TCO 2) Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is

>

<>

(TCO 2) Which of the following below will provide the current computer data as a default?

–/–/–

CurrentDate()

Date

Date()

(TCO 2) Which of the following is NOT an example of a table event?

Add

Delete

Edit

View

(TCO 5) All of the following are performed in the design view of a form EXCEPT

Adding pictures, lines, calculations, and controls

Changing the size of the form sections

Entering a data value

Modifying the properties of a form

(TCO 5) A bound control

Is a textbox that is connected to a field in a query or a table

Contains a formula that displays the result

Is used to display aggregate information

Uses a macro to process field information

(TCO 5) All of the following are form creation tools EXCEPT

Blank form

Form design

Form layout

Form wizard

(TCO 5) In the design view of a form, which of the following would NOT be performed?

Add calculations, controls, pictures, and lines

Change the size of a form section

Enter a data value

Modify the properties of the form

(TCO 5) Use the Arrange Form Layout Tool to

Change the form layout

Move fields

Insert space

All of the above

BIS245 Database Essentials Business Lab

Quiz Week 6 

https://www.hiqualitytutorials.com/product/bis-245-quiz-week-6/

(CO 1) Summary options are found

In the print layout view.

In the report wizard with sorting options.

All of the above

in the options toolbar.

(CO 1) A report can be created from

Queries and tables.

A database

A spreadsheet.

Forms.

(CO 1) When designing a report, make sure that your report

Uses all report sections.

Has grouped data.

Has a date and time.

Is easy to understand.

(CO 1) The easiest way to create a report is to use the following report tool.

Blank report

Report wizard

Report layout

Report design

(CO 1) Which of the following is NOT a report wizard layout type?

Summary

Outline

Block

Stepped

(CO 1) When creating a report, which view works best?

Design view of a query

Datasheet view

Layout view of the report

Design view

(CO 1) To preview the report, which view(s) work best?

Report view or design view.

Layout view or print view.

Design view.

Print view.

(CO 1) Grouping data in a report will

Let you organize and summarize your data.

Provide grand totals for your report.

Make a report more attractive.

Allow you to edit data in a record.

(CO 1) The expression “= [Price] * [Quantity]” would most likely be found in

A calculated control.

An unbound control.

A label control.

A bound control.

(TCO 1) When creating a report, you should consider all of the following EXCEPT

Who will use the report

The purpose of the report

Data that should be considered confidential

Number of records input into the report

(TCO 1) All of the following are report sections EXCEPT

Detail

Group footer

Page footer

Summary

(TCO 1) Which report section would be used to summarize grouped field data?

Detail

Group Header

Group Footer

Report Footer

(TCO 1) The following steps will create a report

Set focus on a table or query object, click on the Create tab, then click the Report button in the Reports group.

Set focus on a table or query object, click on the Design tab, open the table or query object, then click Design Report.

Click on the Create tab, select the Report Wizard, select your tables or queries, and then your fields.

Click on the Table tab, select your fields, and then click the Finish button.

(TCO 1) A tool that creates a report through a series of dialog boxes on the Create tab is the

Blank Report.

Label Wizard.

Report.

Report Wizard.

(TCO 1) Column headings in a report are based on

The captions used in the source table or query.

The text controls you place in a report.

Group labels.

Report labels.

(CO 7) Summary options offer all these calculations except

Minimum

Average

Print preview

Maximum

(TCO 7) A good use of a report is to

Create a telephone directory or a financial statement.

Ask the database a question.

Create a table or query.

Create detailed charts.

(TCO 7) Using Grouping when building a report accomplishes the following.

Grouped data can be sorted.

Grouped data can be summarized.

Summary options allow for Sum, Average, Min and Max.

All of the above.

(TCO 7) Which is not a report view?

Print preview

Datasheet view

Report view

Layout view

(TCO 7) When modifying a report, the arrange option does the following.

To move fields up or down

To insert space above or below your position

To change the layout of the report

All of the above

BIS245 Database Essentials Business Lab

Course Discussions Week 1-7 All Students Posts – 390 Pages

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-1-7/

Gathering Requirements and Choosing Database Solution

Week 1 All Students Posts – 61 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-1/

  • Why are databases important to business? How do databases generate sales and profits? What databases do you interact with, and how do they benefit you?
  • What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating it?
  • Microsoft Access is one of the most popular database platforms on the market. However, there are many competitors. Why do you think that Access is so popular? What are some of the other types of databases available?
  • Do you think that Access can serve as a corporate database solution, or is it strictly a personal database solution? What might be the difference between a personal and corporate database solution?

Databases are important because they efficiently manage data and allow users to perform multiple tasks easier. They also manage and store data in one place. Databases do not…

A database is a collection of data that is organized. This collected data is easily accessed, managed, and updated. Self-describing collection of integrated records means that there is a dictionary of data that contains the information stored in the database and the description of the database. This means that the data and description of data are stored together and creates data independence. Integrated records are records that are grouped together in columns or fields then in turn, are grouped into rows…

BIS245 Database Essentials Business Lab

Applying Design to Entity Relationship (ER) Modeling

Week 2 All Students Posts – 71 Pages

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-2/

  • When designing database tables, the difference between a good design and a bad design can be a few seconds in response time and several minutes. You may think that this is not a huge difference, but imagine waiting several minutes on a web page for your results to load. How long would you wait? A slow database can mean the loss of customers. So let’s begin by discussing some of the common elements of tables and how you would approach the table design. What would you do to ensure that your page loads in a few seconds? Discuss the relationship types and how they affect your design.
  • What role does the entity-relationship (ER) diagram play in the design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?

Data modeling is taking all of the main points in your data and putting them together to explain what you are trying to show.  I believe that data modeling is really like a book, because you are basically telling some kind of story behind your data.  So in other words data modeling really is creating something that makes it easy for people to understand what you are showing.  If this is done right then others can use your information that was gathered to find what they are looking for.  A good example might need to find out what a customer bought and when they bought it…

BIS245 Database Essentials Business Lab

Requirements Analysis and Conceptual Design

Week 3 All Students Posts – 62 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-3/

  • Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.
  • Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?

Physical ERD represents the actual design blueprint of a relational database. It represents how data should be structured and related in a specific DBMS so it is important to consider the convention and restriction of the DBMS you use when you are designing a physical ERD. This means that an accurate use of data type is needed for entity columns and the use of reserved words has to be avoided in naming entities and columns. Besides, database designers may also add primary keys, foreign keys and constraints to the design…

BIS245 Database Essentials Business Lab

Creating Queries From Woodcraft Database

Week 4 All Students Posts – 52 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-4/

  • What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business? Describe what information you might want to select from the database in the form of a query, and list the specific columns and data that the query would produce. Assume that they have hundreds of customers, rather than the short list found in the database file.
  • Suggest additional tables and information that you would like to see in a database like this, the kinds of queries that it would facilitate, and how such queries would help the company improve its business goals of profitability, cost reduction, or other business strategies.
  • Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week’s lab. Post a screenshot of your query design and result set in a Word document.
  • Research one new feature that you haven’t studied as it relates to query generation, and show how you could use that feature to create a useful query. Use the Woodcraft database to showcase this query-generation technique and post it in this discussion.

My opinion is that google is like a query as to how when you type in what you want to search it breaks it down to your criteria. Using query you can tell it what you want to look for like, who, what, when and where of just exactly what you want to find easily by narrowing down your search.  So when you go to google to search for a specific thing you can make it do the exact same thing as a query…

BIS245 Database Essentials Business Lab

Data Normalization and Validation

Week 5 All Students Posts 45 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-5/

  • How do you recognize the difference between good and bad structures? What role does normalization play in good and bad table structures, and why is normalization so important to a good table structure?
  • What is the importance of data validation, and how can user data entry errors be reduced or eliminated?

Normalization would be the way you organize data that is in a database.  This is needed when you need to save any kind of space on any kind of data storage. A good example of a storage area would be possibly a disc or even a thumb drive.  This allows for more area and also increases the speed of the performance…

BIS245 Database Essentials Business Lab

Presenting and Reporting Data

Week 6 All Students Posts – 52 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-6/

  • Database reports provide us with the ability to further analyze our data, and provide it in a format that can be used to make business decisions. Discuss the steps that you would take to ensure that we create an effective report. What questions would you ask of the users?
  • Data presentation should be designed to display correct conclusions. What issues should we think about as we prepare data for presentation? Discuss the different methods that we can use to present data in a report. What role does the audience play in selecting how we present the data?

I would ask if there was any specific thing that they would like to see the characteristics of.  I would also ask if we are looking for total products or total sales totals or just how many of each was sold for the year, for the month.  There are so many variables when it comes to creating a report.  There are also a ton of options in most cases to get what the end user wants. This is why it is so important to put your data in correctly, so that you will be accurate with any reports that need to be generated…

BIS245 Database Essentials Business Lab

Database Navigation and Data Security

Week 7 All Students Posts 47 Pages 

https://www.hiqualitytutorials.com/product/bis245-course-discussions-week-7/

  • Finding information in a database can be difficult unless you know what information you need and how to look for it. Creating a navigation system or menu allows Access to act like a point-and-click system. What are some of the types of navigation that you can create in Access 2016? How should we approach the design of the menu?
  • Why is data security important now more than ever? What are some of the steps that we can take to ensure that our database is protected and secure? How can you use user views to enhance security and restrict access?

Pros

  • Tab based navigation allows you to present more content to the user in a limited space.
  • Probably useful for mobile devices where you do not have much screen real estate.
  • On desktop browsers, as soon as content for active tab is fetched from server, it can be displayed to the user. Rest of the tabs can be loaded on demand using ajax when the user navigates to them or can be pre-fetched in the meantime the user is going through the active tab. This provides a good user experience as data is quickly available to the user.

Cons

  • Content from multiple tabs cannot be viewed at once. Tab navigation should never be used when there is a use case where user may need to view/compare data from multiple tabs.

One limitation I see in using tabbed navigation on mobile devices is that the tab links can take up a large portion of the screen which could have been used otherwise…

BIS245 Database Essentials Business Lab

BIS 245 Final Exam 

https://www.hiqualitytutorials.com/product/bis-245-final-exam/

(CO 1) A primary key is

A field or set of fields that uniquely identifies a record

The key used to uniquely identify a record in a table

A key that uniquely identifies columns in a table

A nonunique value

(CO 1) The navigation pane allows you to

Open tables

Open views

Filter by datatype

Filter by group and navigate to category

(CO 1) A detail line is used to

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

(CO 1) A foreign key is

A field in one table that is also the primary key of another table.

Another name for a candidate key.

A value that can connect two tables simultaneously.

A unique value that identifies each row within a table.

(CO 1) In what situation would Access be a better choice than Excel?

You have an extensive amount of data.

You need to conduct extensive statistical analyses on your data.

You have a limited amount of data.

You require a flat file view of your data.

(CO 1) The number of sections Access creates for a report is

Five

Six.

Three.

Four.

(CO 2) A single crow’s foot at the left-most end of a relationship line would indicate

A many-to-many relationship

A one-to-many relationship

A one-to-one relationship

No relationship

(CO 2) Which of the following is NOT a database system?

Relational

Network

SQL

Hierarchical

(CO 3) All of the following are reasons to save first name and last name as separate fields except

Fewer fields are used

First name could be used in a salutation

Last name could be used in a salutation

You can sort on last name then first name

(CO 3) The following data type would appear as a checkbox in a table

Group of answer choices

Attribute

Number

Text

Yes/No

(CO 3) Which of the following does NOT describe a caption property?

 A label can substitute for a field name in datasheet view

The caption appears in datasheet view, form, and report

The label allows spaces between words

The label can be used in place of a field name in an expression

(CO 3) All of the following describe a caption property except

The caption appears in datasheet, report, and form views.

Can take the place of a field name in datasheet view.

Can be used in place of a field name in an expression.

Allows for placing spaces between words.

(CO 3) Which of the following does NOT apply to the following description of an image?
Image Description:
Three tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or suppliers and an infinity symbol attached to Table 2 or products.

One table is not joined to the other two tables.

A join exists on two primary keys.

A one-to-many relationship is applied.

The display is showing the design view of relationships.

(CO 5) All of the following describe form usage except

a form can show data from only one table.

you can create Access forms to match paper forms.

a form user should have less input errors than a table user.

forms restrict data entry to one record at a time.

(CO 5) Clicking on the form tool will open a(n)

Wizard to design a form.

New form in layout view.

New form in design view.

Existing form.

(CO 6) Which of the following statements is NOT correct about a query?

Instructions on which data to display are saved within a query.

Data is not saved within a query.

Changing data values in a query will not change data values in a table.

Instructions on the format to display data are saved within a query.

(CO 9) All of the following are drawbacks to normalization, except

Input/output resources.

CPU usage.

Memory usage.

Less tables and larger columns.

(CO 8) The _____ interface displays a menu that provides the ability to open the various objects within the database and to move easily from one object to another.

Switchboard form or navigation form

Object

Utility

Form

(CO 9) All of the following describe a digital signature certification authority except

Certification authority companies establish their own rules and regulations that users must follow.

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.

(CO 1) All of the following are Access objects except

Criteria

Table

Query

Form

(CO 1) Which of the following means not equal to 30?

> 30

= 30

>< 30

<> 30

(CO 1) Which of the following is NOT an Access interface element?

Title bar

Navigation pane

Status bar

Criteria

(CO 1) Which of the following is NOT a report section?

Detail

Summary

Group footer

Page footer

(CO 1) A report creation tool that will automatically pull in the fields from a table or query is the

Report design.

Report wizard.

Blank report.

Report tool.

(CO 2) A field that uniquely identifies each record in a table is

Relationship

Primary key

Link

Foreign key

(CO 2) SQL is a fourth-generation language that is

Table oriented and nonprocedural.

Procedural and record oriented.

Flat-file oriented and nonprocedural.

Oriented toward static data.

(CO 3) Which relationship is used most commonly within the database environment?

A one-to-many relationship.

Many-to-many relationship.

One-to-one relationship.

Two-to-one relationship.

(CO 3) Attributes are better defined as

a characteristic of an entity.

a description of an entity.

a column.

All of the above

(CO 3) Which of the following is NOT true of indexed property?

Setting the index requires each record to be scanned sequentially and saves time searching data.

Primary keys must be indexed.

Indexing a table speeds the retrieval time.

An example of a setting is yes (no duplicates).

(CO 4) Which of the following does NOT describe the following description of a one-to-one relationship?

Description:
Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols

The tables must have exactly the same fields

The Employees and NewEmployees tables use the same primary key

More tables can be joined to either table

It may be used for security reasons to protect data availability

(CO 4) In terms of data types and their uses, which one of the following is NOT correct?

The TEXT data type can be used for Last Name.

The Date/Time data type can be used for 10/31/2012.

The Currency data type can be used for Account balance.

The AutoNumber data type can be used for Customer Name.

(CO 5) Which form type displays records in a tabular format similar to a datasheet view but has more editing options, such as adding graphics?

Datasheet form

Split form

Multiple items form

Subform

(CO 5) A calculated control

Is an unbound box that the user will fill in with a numeric value.

Is a text box containing a description.

Is a bound box.

Contains a formula that displays the result.

(CO 6) Which of the following describes a poor design consideration for a form?

Arrange controls closely together or in a sequence that is easy to read by the user with consistent formatting

Each form should have a different theme

Make labels descriptive and clear

Right-align labels followed by a colon and left-align bound controls

(CO 6) After running a query, which view will be shown?

Datasheet

Design

Query

Result

(CO 6) Which of the following is a term used to describe a calculated field?

Identifier

Value

Function

Operator

(CO 6) Data aggregate functions

Cannot be used on a row.

Return multiple values.

Are used to perform calculations on individual records in a table or query.

Perform calculations on entire columns of data.

(CO 8) All of the following describe how a Navigation Form is used except

Click the create tab and then navigation in the forms group to create a navigation form

Is another term for a specific report

Helps users open forms and reports

Has the look and feel of a web form

(CO 9) A digital signature

Helps confirm who created the file, that the file is valid, and that no changes have been made to the file once it is authenticated

Is used with database files exclusively

Is a tracking system of a file activity

Must be obtained from a certification authority, such as VeriSign

(CO 9) An encrypted file is

Created by scrambling the content

Protected by a password

Saved with a specific file extension

Unreadable if it is opened through a tampering tool or another program

(CO 9) Default normalization form 4 takes place

When all candidate keys are identified.

When all tables are related.

When third normal-form includes several candidate keys.

When third normal-form has one and only one candidate key, which is a primary key.

(CO 2) A required field that is used in entering data is a field that

Cannot be left blank.

Can be left blank.

Is selected from a list of values.

Appears with a specific value.

(CO 8) All of the following describe how a Navigation Form is used except

Is another term for a specific report.

Helps users open forms and reports.

Has the look and feel of a web form.

Click the create tab and then navigation in the forms group to create a navigation form.

(CO 9) Of the following security techniques available in Microsoft Access to keep a database application safe, which choice would make the database virtually impossible to break into?

Digitally signing and publishing the database

Creating a menu system

Encrypting and password-protecting the database

Saving the database as an ACCDE file

(CO 9) Database security is a specialty within computer security that protects a database application from unintended use. Unintended use includes

Unauthorized viewing of data.

All of the above

Malicious attacks.

Inadvertent mistakes made by employees.

(CO 10) To examine the efficiency and performance of an Access database, you should

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

 (CO 10) The table analyzer tool does this for your database.

Make suggestions to create another query

Will not improve the database

Make suggestions to create another report

Make suggestions to minimize duplication of data

(CO 4) Which of the following is NOT true of a ship date field?

A ship date would be defined as a date/time field.

A ship date would be defined as a calculated field.

Date arithmetic can be applied to a ship date field.

A ship date is considered a constant.

(CO 1) Describe three-tier architecture. Explain the functions performed by each tier

(CO 1) Explain the benefits an organization gains by using a relational database?

40 Points

(CO 2) Explain entity integrity and referential integrity. Give an example of each.

40 Points

(CO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain how that normal form is often violated by inexperienced database designers and how to correct such a violation of that normal form.

40 Points

(CO 4) Conceptual design begins with a big-picture view and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step

(CO 4) When constructing a database, two rules are followed by the database designer to ensure the integrity of keys. Describe each rule, and discuss common violations.

40 Points

(CO 4) Explain a one-to-many relationship, and provide two examples

(TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5)

Criteria

Form
Query

Table

(TCO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express Box Large in November 2013?” (Points : 5)

Foreign keys

Primary keys

Parameter query

Table connections

(TCO 1) When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. (Points : 5)

Label Tool

Tabular Layout Report

Blank Report Tool

Report Wizard

(TCO 1) A filter in Access (Points : 5)

Creates a new table with matching criteria.

Deletes unique records from the database.

Allows the user to edit specific records.
Displays a subset of records based on specified criteria.

(TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5)

Report tool

Report design

Report wizard

Blank report

(TCO 2) A field that uniquely identifies each record in a table is a (Points : 5)

Link

Relationship

Primary key

Foreign key

(TCO 2) A symbol used in ER diagrams for an entity is a (Points : 5)

Box

Diamond

Line

Triangle

BIS245 Database Essentials Business Lab

(TCO 3) All of the following apply to the relationships image found below EXCEPT

Image Description: Three Tables are pcitured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a Primary key of CategoryID and fields: Categoryname, Description and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. (Points : 5)

A one-to-many relationship is found between the Suppliers table and the Products table.
A relationship exists between the two primary keys of the Suppliers table and the Products table.
One table is not joined to the two other tables.

The primary key for the Categories table is CategoryID.

(TCO 3) All of the following applies to data redundancy EXCEPT (Points : 5)

It requires updating in two locations.

Data is always linked in two tables.
Output could be incorrect if the first and second locations of the same data are not updated.

The same data exists in two tables.

(TCO 3) Which of the following does NOT apply to the following relationship image?
Image Description: Three Tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. (Points : 5)

A one-to-many relationship is applied.

The display is showing the Design view of relationships.

One table is not joined to the other two tables.

A join exists on two primary keys.
(TCO 4) When building a calculated field, formulas can be created using the (Points : 5)

Form Wizard

Expression Builder

Report Builder

Table Wizard

(TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options, such as adding graphics? (Points : 5)

Datasheet Form

Multiple Items Form

Split Form

Subform

BIS245 Database Essentials Business Lab

(TCO 5) A bound control (Points : 5)

Always contains a label.

Contains text and number values entered by the user.

Is unique and contains a data field from another underlying source.
Must contain a formula.

(TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)

Forms

Modules

Tables

Macros

(TCO 6) The benefit of a relationship is to (Points : 5)

Efficiently combine data from related tables.

Facilitate how Access will manage the relationship.
Determine which fields to include in each table.

Minimize data redundancy.

(TCO 9) Default normalization form 4 takes place (Points : 5)

when third normal-form has one and only one candidate key, which is a primary key.

when third normal-form includes several candidate keys.

when all candidate keys are identified.

when all tables are related.
(TCO 2) A validation rule (Points : 5)

Can prohibit values from being entered that may not meet a criterion.

Compares a field to a table.

Is an error message that appears when a value is incorrectly entered into a field.

Makes a value entered into a field appear in a particular format.

(TCO 8) The _____ interface displays a menu that provides the ability to open the various objects within the database, and to move easily from one object to another. (Points : 5)

Form

Utility

Switchboard

Object

BIS245 Database Essentials Business Lab

(TCO 9) Open Exclusive means that (Points : 5)

A password is required to open the Access database.

Only one person has access to the Access database at any time.

Only selected persons can have access to the Access database.

Two or more people cannot open the same Access database at the same time.

(TCO 9) All of the following are true when a user creates his or her own self-signed digital signature EXCEPT (Points : 5)

A time stamp is not required to go through a commercial service or local server for processing.

A time stamp will prove when the file was last used.

It is created through another software application.
It will prove that the creator owns the database.
(TCO 10) After creating an ACCDE file, you (Points : 5)

Can convert it back to its source format.
Will see a “file already in use” message that continues to display to all other users.
Will be able to modify forms and reports but not tables.
Will need to go back to the original file if an underlying object requires a change.

(TCO 4) Which statement below is NOT true of the one-to-many relationships?

Image Description: Three Tables are pictured: Table 1: Order Details with primary keys of OrderID and ProductID and fields: UnitPrice, Quantity, and Discount. Table 2: Orders with an OrderID primary key and fields of CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, and ShipCountry. Table 3: Customer has a primary key of CustomerID, Fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, and Fax. There is a relationship labeled with the infinity symbol attached to the OrderDetails (Table 1) and also attached with a number 1 to the Orders table (Table 2). There is also a relationship with the infinity symbol beginning at Orders table (Table 2) and connected to the Customers table (Table 2) using a 1. (Points : 5)

BIS245 Database Essentials Business Lab

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 an Orders table matches only one record in the Customers table.

(CO 1) What role do databases play in today’s business world and why are they important? Provide two specific examples of how a database might be used by a business. 40 pts

(CO 1) Explain the organization of data in relational databases in terms of tables, records (rows), and fields (columns). Give an example of a table and specify its fields. Which field(s) would you choose as the primary key of that table? (Points : 40)

(CO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. (Points : 40)

(CO 4) Explain the importance of determining relationships before establishing primary keys in the design sequence. (Points : 40)

(CO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40)

BIS245 Database Essentials Business Lab

DeVry