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…
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
Click Here: 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.
- Please identify the attributes and primary keys needed for each of the entities.
- Identify the data types you would use for each of the attributes.
- 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.
- Create an ER diagram using Visio based on your analysis.
- Identify all foreign keys needed in the database design.
- Create the database in Access and populate the tables.
- 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
- Due Week 3: Submit your draft database design using MS Visio using a Conceptual Visio Drawing
- Due at the end of Week 5:
- Upload completed Visio Conceptual Design.
- A 3-5 page APA paper discussing the following topics:
- Discuss Database impact on the workplace,
- Discuss database benefits when businesses use queries,
- Forms, and reports.
- 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
Click Here: BIS245 iLab Week 1-7
iLab Week 1
Click Here: 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
Click Here: BIS245 iLab Week 2
- Lab # : BSBA BIS245A-2
- Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database
- Lab Overview—Scenario / Summary
COs:
- 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.
- Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.
- Given an existing relational database schema, evaluate and alter the database design for efficiency.
- 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
- Relying on detailed instructions, add two entities to the existing conceptual model (ERD), including attribute data types and required field lengths;
- Create a new MS Access database file;
- Using the model from Part A of the lab and relying on detailed instructions; create the first two tables in the database;
- Use the experience gained in creating the first two tables to add the remaining tables;
- 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
- Use the experience gained in creating the first relationship to create the remaining relationships between the tables.
- Deliverables
Section | Deliverable | Points |
Part A | YourNameLab2.vsdx (Visio Diagram) | |
Part B | YourNameLab2.accdb (Access Database) |
- Lab Steps
Preparation
- Get the Visio diagram
- Download Lab2_StarterFile.vsdx file from your course Lab page, and save the file to your local drive.
- Using Citrix for MS Visio and/or MS Access
- If you are using the Citrix remote lab, follow the login instructions located in the Lab area in the Introduction and Resources area.
- 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
Click Here: 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
- Modify an existing MS Visio ERD to include new entities and relationships;
- Modify an existing MS Access database to include new entities and relationships;
- Enter data into tables in a MS Access database using datasheet view; and
- Create and run simple queries in MS Access.
Deliverables
Part A: YourNameLab3.vsdx (Visio diagram)
Part B: YourNameLab3.accdb (Access database)
Lab Week 4
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: BIS245 Quiz Week 1-6
Quiz Week 1
Click Here: 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
Click Here: 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
Click Here: BIS245 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
Click Here: BIS245 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
Click Here: BIS245 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
Click Here: BIS245 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
Click Here: BIS245 Course Discussions Week 1-7
Gathering Requirements and Choosing Database Solution
Week 1 All Students Posts – 61 Pages
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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
Click Here: 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