IllustratedAccess 2016| Module 1: SAM Project 1a
Volunteer Service Hours Database
CREATING A TABLE AND BUILDING A RELATIONSHIP
- Open the file IL_AC16_1a_FirstLastNameaccdb,available for download from the SAM website.
- Save the file as IL_AC16_1a_FirstLastNameaccdbby changing the “1” to a “2”.
o Hint: If you do not see the .accdb file extension in the Save As file dialog box, do not type it. Access will add the file extension for you automatically.
- Open the _GradingInfoTabletable and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
- Create a new table in Design View as follows:
- Add a field with the name InvolvementID and the AutoNumber data type.
- Set the InvolvementID field as the table’s primary key.
Save the table with the name Involvement, but do not close it.
- With the Involvement table still open in Design View, add a second field to the table using the field name MemberNo and the Number data type.
- In Design View, add a third field to the Involvement table using the field name EventName and the Short Text data type.
- In Design View, add a fourth field to the Involvement table using the field name EventDate and the Date/Time data type.
- In Design View, add a fifth field to the Involvement table using the field name HoursDonated and the Number data type. Save the Involvement table and switch to Datasheet View.
- In Datasheet View, enter the two records shown in Table 1 below into the Involvement Close the Involvement table and saveit, if necessary.
Table 1: New Records for Involvement Table
- Open the Members table in Design View. Change the name of the field named First to MemberFirst, then change the name of the field named Last to MemberLast.
- With the Members table still open in Design View, change the data type property of the Biofield to Long Text.
- In Design View, add a new field to the Members table after the Bio The field should be named CellPhoneand have the Short Text data type. Save and close the Members table.
- Create a new relationship in the database as described below:
- Open the Relationships window, then add theInvolvement table to it. Close the Show Table dialog box.
- Create a one-to-many relationship between the Members and Involvementtables using the common MemberNo
- Enforce referential integrity on the relationship.
Save and close the Relationships window.
- Open the Members table in Datasheet View. Find, select, and delete the record with the MemberNo field value 32 (and the MemberFirst andMemberLast field values Taney Wilson) from the Members
- With the Members table still open in Datasheet View, navigate to the record with the MemberNo field value 10 (and the MemberFirst andMemberLast field values Allie Pitt), then change the MemberLast field value to Espinoza.
- With the Members table still open in Datasheet View, navigate to the record with the MemberNo field value 35 (and the MemberFirst andMemberLast field values Joshua Parton), then change the Street field value to 202 Adams St.(Hint: be sure to include the period.) Close the Members table and save it, if necessary.
- Open the Members table in Datasheet View, then expand the subdatasheet for MemberNo 2. (Hint: You should see one related record from the Involvement) In the subdatasheet, change the value of the EventName field to Boy Scout Camp. Close the Members table.
Save and close any open objects in your database. Compact and repair your database using the Compact and Repair Database button on the Database Tools tab of the Ribbon, close it, thenexit Access. Follow the directions on the SAM website to submit your completed project.
“A picture is worth a thousand words” may be a lovely cliché, but it’s exactly the wrong way to view visualization. For this week’s discussion question, please view the Periodic Table of Visualization at the following link (http://www.visual-literacy.org/periodic_table/periodic_table.html). Choose one Data Visualization and one Compound Visualization by placing your mouse cursor over each option. Provide your classmates with a brief description of your choices and explain why you made your choices. Please describe what advantage your choices have over the others.
Imagine that you have the educational background, skills, and abilities to be a database administrator. The XYZ company recently announced a vacancy for a database administrator position, and you are very interested because XYZ is known as a high-paying employer that is enjoyable to work for. Because a security breach at XYZ recently made the news, XYZ’s job posting has requested all applicants to include in their cover letter a brief description of how he or she would approach data security if awarded the position.
Research the qualifications necessary to obtain a database administrator position.
Read “Cover Letter Workshop – Formatting and Organization” from Purdue Online Writing Lab.
Write a 1- to 2-page cover letter briefly describing your (fictional) database administrator-related qualifications and outlining the reasons you believe you are the best candidate for the job. Your cover letter must include:
A description of your education and database-related work experience
Note: this description will likely not match your own actual education and experience. You will need to research and include the education and work experience appropriate to a successful candidate for a database administrator position unless your own personal background qualifies you for a database administrator position
Your philosophy and approach to backing up relational data
Your philosophy and several approaches to securing relational data and a rationale for each approach
Address your cover letter to Mr. Ben Smith, Director of Human Resources.
An Executive Summary provides a high-level overview of the project-to-date including; results, conclusions, and recommendations. These summaries are written for executives who do not have time to read a detailed report, but need to cover the major points of a project in order to understand the substance.
This week you are to create a final report that includes an Executive Summary.
Choose one of the following ways to complete the summary:
A Microsoft® Word document including:
A 1-page Executive Summary (described below)
Combined and well-formatted content from prior assignments
An 8- to 10-slide Microsoft® PowerPoint® presentation with speaker notes
Your final project is to include the following:
A Comprehensive Task List showing a high-level overview of the project and project-to-date results to provide an introduction for Executives
The Week Two Assignment Deliverable: The abstract data type algorithm headers for the inventory system, including: name, parameters, purpose, preconditions, post conditions, return value types, and the pseudocode definitions for a textbook data structure and a student data structure
The Week Three Assignment Deliverable: The recursive pseudocode algorithm which looks for specific text within all textbooks located in a library
The Week Four Assignment Deliverable: The document explaining sort priorities, including: the list of character sort strings, numerical data searches, arrays, subarrays, normalization database link revisions, and Pivindex
The conclusion and recommendations going forward with the project
Create a short paper that includesthe following critical elements in this assignment: 1) A description of the business-related challenges faced by the organization 2) One example of a case study that discussessimilar challenges faced by organizations with constraints related to the lack of features listed in Table 1, or 3) If you work in the information technology field, describe any similar operating-system-related challenges faced by your organization, or 4) A description of how any of the features listed in Table 1 or a lack thereof would play a role in your productivity at work or school.
One of the items that businesses would like to be able to test is whether or not a change they make to their procedures is effective. Remember that when you create a hypothesis and then test it, you have to take into consideration that some variance between what you expect and what you collect as actual data is because of random chance. However, if the difference between what you expect and what you collect is large enough, you can more readily say that the variance is at least in part because of some other thing that you have done, such as a change in procedure.
For this submission, you will watch a video about the Chi-square test. This test looks for variations between expected and actual data and applies a relatively simple mathematical calculation to determine whether you are looking at random chance or if the variance can be attributed to a variable that you are testing for.
Imagine that a company wants to test whether it is a better idea to assign each sales representative to a defined territory or allow him or her to work without a defined territory. The company expects their sales reps to sell the same number of widgets each month, no matter where they work. The company creates a null and alternate hypothesis to test sales from defined territory sales versus open sales.
One of the best ways to test a hypothesis is through a Chi-square test of a null hypothesis. A null hypothesis looks for there to be no relationship between two items. Therefore, the company creates the following null hypothesis to test: There is no relationship between the amount of sales that a representative makes and the type of territory (defined or open) that a representative works in. The alternate hypothesis would be the following: There is a relationship between the kind of sales territory a sale representative has (defined or open) and the amount of sales he or she makes during a month
Complete the following steps to access the MyMathLab® Study Plan for Week 1:
Access the Practice/Simulation/Homework/Game tab.
Select External Content Launch to open MyMathLab®.
Select Homework and Tests in MyMathLab® on the top-left corner of the screen.
Select Study Plan for Week 1.
Select the green Practice button next to the first unmastered objective.
Complete the practice problems until you feel ready to take a quiz.
Select the Close button. Return to the Study Plan for Week 1.
Select the Quiz Me button.
Correctly answer the questions to earn the Mastery Point (MP). There may be two questions per Quiz Me.
Note: If you do not correctly answer the questions in the Quiz Me, you must select Practice and successfully complete at least one practice problem before you can retake the Quiz Me. You can follow this process and attempt each Quiz Me as often as necessary.
In order to receive the Mastery Point, you must answer both Quiz Me questions correctly at the same time and receive a minimum score of 80%.
Select one of the below U.S. Federal Pay Regulations
· 1938 Fair Labor Standards Act
· 1963 Equal Pay Act
· 1964 Title VII of Civil Rights Act of 1964
· 1965 Executive Order 11246
· 1967 Age Discrimination in Employment Act
· 1978 Pregnancy Discrimination Act
· 1990 Americans with Disabilities Act
· 1991 Civil Rights Act of 1991
· 1993 Family and Medical Leave Act
Using an Online Library, conduct additional research on one of the regulations. Your research project should be a minimum of four pages and should include a literature review. Page count does not include the title page or reference page. Include in your research:
· History of the Act
· Why was it created
· How it influenced the area of human resources and compensation
· What the future holds for the act
· How it affected the employer and the employee
· Do you agree with this act? Why or why not?
Your paper should follow APA Guidelines and all references should be cited.
Characterizing Network Traffic.” Please respond to the following:
From your research on cloud computing, explain how cloud computing fits the types of traffic flow discussed in the textbook (terminal/host, client/server, peer to peer, server/server, and distributed computing) or explain whether it is a new type of traffic flow. Defend your answer
Discuss, comment, and reply. Original posts and participation graded.
Overall, how effective is the partnership between IT and the business at Hefty Hardware? Identify the shortcomings of both IT and the business.
Create a plan for how IT and the business can work collaboratively to deliver the Savvy Store program successfully.