EX19_AC_CH10_GRADER_CAP_HW – Specialty Foods 1.1

EX19_AC_CH10_GRADER_CAP_HW – Specialty Foods 1.1

Project Description:

You are employed at Specialty Foods, Ltd., a small international gourmet foods distributor. The company has asked you to modify the database and improve the reliability of the data entry process. You decide to create a few macros and add a menu for the common forms and reports. You will also modify the record source of one of the reports.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch10_Cap_Specialty.accdb. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

You   will create an event-driven data macro that will populate a new field   automatically each time a record is added to the table.
 

  Open the Orders table   in Datasheet view, observe the data, and then switch to Design view. Add a   new field, ExpectedShipDate   with the data type Date/Time   below the OrderDate field. Save the table.

Create   a data macro attached to the Before Change event. Use the SetField Action to populate the ExpectedShipDate in   the table. The ExpectedShipDate will always be five days after the OrderDate.   Save the macro. Close the macro. Save the table.

You   will change a value in the first record, and then move to the second record   to trigger the macro.
 

  Switch to Datasheet view of the Orders table. Retype the OrderDate in the   first record (OrderID 10248) and press DOWN ARROW.   The macro will be triggered and automatically fill in the ExpectedShipDate   with a date five days after the OrderDate.

Repeat   the test on the second and third records (10249 and 10250). Close the table.

Open   the Main Menu form in Design view. Add three buttons   below the Forms label that will open the three forms in the database: Enter Customers, Enter Orders,   and Enter Suppliers (in that order and to show all records).   Set the first one at the 2″   mark on the vertical ruler and the 1″ mark   on the horizontal ruler. Set the height of the button to 0.5” and the width to 1“. The first button should have   the caption Enter Customers   with the button named as cmdEnterCustomers.

Repeat   the same procedure for Enter Orders   and Enter Suppliers, setting each button immediately below   the one before it. For   example, set Enter Orders so that its top border is set approximately at the   2.6-inch mark, and Enter Suppliers is set approximately at the 3.1-inch mark.

Add   three buttons below the Reports label that will print preview the three   reports in the database: Employees,   Orders, and Products   (in that order). Set the first one at the 2″   mark on the vertical ruler and the 4″   mark on the horizontal ruler. Set the height of the button to 0.5” and the width to 1“. The first button should have   the caption Employees   with the button named as cmdEmployees.

Repeat   the same procedure for Orders   and Products, setting each button immediately below   the one before it. Save the form, switch to Form view, and then test the   buttons. Close all objects except the Main Menu form. For example, set Orders   so that its top border is set approximately at the 2.6-inch mark, and   Products is set approximately at the 3.1-inch mark.

Switch   to Design view, add a Close Database   button that exits Access to the top-right corner of the form, at the 0″ mark on the vertical ruler and the 5″ mark on the horizontal ruler, with a   height of 0.5”   and a width of 1“.   Name the button cmdExit.

Modify   the embedded macro in the On Click property   of the cmdExit button. Add a MessageBox action   to the macro to display the message Please check all   updates before exiting! and set the Type to Information. Move the action up to before the   QuitAccess action. Change the option under QuitAccess from Prompt to Exit.   Save and close the macro.

Save   the form, switch to Form view, and then set the Main Menu   form to display when the database opens. Test the Close Database   button.   Reopen the database.

You   want to modify the records displayed in the Employees report. You will use an   SQL statement to modify the record source so that only employees who live in   London display in the report.
 

  Open the Employees report in Design view. Open the Property Sheet and click   in the Record Source property box. Type an SQL statement into the Record   Source property of the report. The statement should select all fields (*) for employees where the City equals   (=) London. Save the report. Test the report in   Print Preview and close the report.

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

I have provided the template needed for this project. I need questions 4,5, and 7 answered. 

From a development team of one to two people to an enterprise-level team with multiple divisions, the topic of mobile development will eventually come up. 

• Compare & Contrast mobile applications vs websites.
• Research and discuss the importance of developing a mobile strategy.
• Discuss different system mobile functionalities.
• Explain the social aspect of mobile interfaces.
• Discuss two – three mobile application development myths.
• Argue the need for adaptive vs dedicated mobile websites.

– apa

– 7 pages

Entity Relationship Diagrams are used to help show how information in a system is organized. This assignment will have you analyze data from a business situation, construct an ERD, and explain process of normalization and reasons when denormalization may be important.

Assignment Instructions and Requirements

Avery’s gym has partnered with a partner physical therapy business to provide treatment for some of its gym members. Gym members have the option to participate in special physical therapy sessions.

The main feature of this partnership provides gym members with the options to participate in physical therapy sessions. Each Physical Therapy Session must include a gym member, a trainer, and a therapist. Each session generates a unique Claim. Sessions also need to record the date, time and purpose of the sessions. Physical therapy sessions are billed back to insurance and claims must be filed with each physical therapy session.

You have been tasked with developing an Entity Relationship Diagram to help show this part of the larger gym system. You have also been asked to explain the importance of both normalization and denormalization of data structures.

You have been given a report as an example of some of the information generated by the system, and the file contains the following fields. Hint: unique IDs may need to be created to correctly generate the data model.

1. Physical Therapy Session
2. Session Date
3. Session Time
4. Session Details/Purpose
5. Member Name
6. Member Address
7. Member Phone
8. Member Age
9. Member Email
10. Insurance Number
11. Insurance Name
12. Insurance Address
13. Insurance Plan details
14. Trainer Name
15. Trainer Phone
16. Trainer Email
17. Trainer Specialty
18. Therapist Name
19. Therapist Phone
20. Therapist Email
21. Therapist Specialty
22. Insurance Claim Number
23. Claim Cost

Complete the following two tasks:

1. Normalize the data. Organize the information into data fields appropriate for a relational database. Analyze the information provided and normalize the data to create a database model.
2. Based on that information construct an ERD. Use Visio. Identify primary and foreign keys. For each entity, develop appropriate and thorough attributes. Use crow’s feet to show relations between entities.
3. Explain the importance of normalization: provide a summary of the steps necessary for each 1NF, 2NF, 3NF and importance. A minimum of 120 words is expected.
4. Explain denormalization and explain the main reasons for it. A minimum of 60 words is expected.

1. Describe how you would fix the home network of your noisy neighbors.

Parameters: In 10 to 12 complete sentences, identify the CPU architecture, memory, and storage, and state why each item was selected. Please include a table indicating the cost of the items and their specifications.

Your next-door neighbors and their four kids play music at all hours of the night. When you knock on their door to complain, the mom explains that her kids play music when doing homework, but their network is so slow, the kids never finish. Knowing you’re taking classes in CIS, they ask you to help them get some sleep by speeding up their computers and network. Based on the following description, make a list of recommended upgrades you would perform. Make sure to recommend specific devices and describe how they will resolve the problem. Assume they do not trust wireless technology, so please do not base your recommendations on a wireless infrastructure.

The family has the following devices:

• ZyXEL cable modem DOCSIS 3.0 (CDA30360)
• TP-Link AC1750 smart WIFI router
• 3 x D-Link 8 port 10/100 unmanaged metal desktop switch (DES-108)
• 1 x Xbox one slim
• 6 x Roku magically wired to the network
• QNAP for movies and music videos
• Vonage home phone service HT802-VD VoIP device
• 4 x Echo Mini
• All devices are connected using CAT3 cable
• 5 Mac Mini (2018) with SSDs and 8 GB of memory

Parameters: Given a $500 budget, generate a quote of recommended upgrades for their network. Each item should be accompanied by a three-to-four-sentence description of why it needs to be upgraded.

The latest generation of mobile devices are portable enough to carry at all times, connected to voice and data networks, and contextually aware by using sensors and networks to preemptively complete tasks.  Many of today’s mobile applications are personalized, and are not useful if they can only access the data on the phone.  For a user to get, for example, sports scores, retrieve stock quotes, or perform accounting work, the mobile device needs to communicate with one or more servers, starting with the Window servers.

• Discuss effective use of screen real estate
• How does mobile user interface designs & websites reduce end-user self-efficacy?
• What are the challenges of integrating mobile applications with multiple databases? 

– 2 pages

– apa

– plagiarism free

Read Part 4, Part 5, and Part 6 of the Azure Certification Documentation below 

Part 4: Describe general security and network security features 

(https://docs.microsoft.com/en-us/training/paths/az-900-describe-general-security-network-security-features/ ), 

Part 5: Describe identity, governance, privacy, and compliance features (https://docs.microsoft.com/en-us/training/paths/az-900-describe-identity-governance-privacy-compliance-features/ ),

Part 6: Describe Microsoft Cost Management and service level agreements

(https://docs.microsoft.com/en-us/training/paths/az-900-describe-azure-cost-management-service-level-agreements/ ) 

Prepare a report using the following format 

Sections

1. Executive Summary 

2. Table of Contents 

3. Introduction 

4. Azure security solution for University 

5. Azure governance solution for University 

6. Azure cost management for University 

7. Conclusion

Note:  3 to 4 pages report required with a table of contents and references excluded with the page count.

Discussion 3.1

Discuss advantages of the 3D analysis

Discussion 3.2

Discuss disadvantages of the 3D Modeling

Discussion 4.1

Identify a key concept or foundational theory from the first four weeks of class and in half a page discuss how it applies to your current work environment or a recent social, political or business event. Include the chapter and sub topic from your textbook.

Week 5 Topic –After the Interview—The “Thank You” LetterWeek 5 Learning objectivesUpon completion of week 5 assignments and discussion forum responses students should be able to:

• Articulate the rules of interview and post-interview etiquette
• Explain the benenfits of sending a “thank you” letter to potential employers.
• Week 5 Assignment—Write and submit a proposed “Thank You” Letter/email; include reference the job and the industry in your letter for context. For this assignment you will be creating a sample thank you letter. After any interview it is necessary to send the employer a thank you letter. Some people would suggest this be a typed letter that is printed, signed and mailed to the interviewer while others would use only an email thank you. Either way it is extremely important.  Download the attached document to help you with writing your thank you letter. Here is a video on writing an effective “Thank You” Letter https://www.youtube.com/watch?v=qxHxyMJZxR0 [Title: Job Interview Tips (Part 7): Write a Great Thank You Note]   Week 2 Discussion Forum –The post -pandemic workplace After watching the videos, write a one to two paragraph reflection of what you learned from this video about navigating the workplace post COVID-19. Video Link #1: https://news.vanderbilt.edu/2022/02/25/ask-an-expert-how-has-covid-19-changed-the-workforce/ Week 2 Assignment #2 : https://www.gartner.com/smarterwithgartner/9-future-of-work-trends-post-covid-19 (Video title: The Future of Hybrid Working)

 Describe some ways that an administrator can harden a system on a network.