All posts by : chebby

Exp19_Access_Ch09_Cap – Trading Cards 1.0

Exp19 Access Ch09 Cap Trading Cards 1.0

Access Chapter 9 Capstone – Trading Cards

EX19_AC_CH09_GRADER_CAP

Project Description:

You and your partner Stann Dupp have a small business selling baseball cards online through eBay. As the more computer-savvy partner; you created an Access database with records of the cards you have in stock. As it turns out, Stann was attempting to manage the card inventory and ended up modifying crucial aspects of the database that impact the general operation of the database. You will reverse those changes and create other safeguards to protect from this happening again in the future. The database tables may already be normalized; however, you will examine the tables to verify.

Start   Access. Open the downloaded Access database named Exp19_Access_Ch09_Cap_Trading_Cards.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 first establish relationships between the Cards, Brands, and Rarity   tables based on the common fields that they share.
 

  Open the Relationships window. Add the Cards,   Brands, and Rarity tables to the layout.

After   creating a relationship between two tables, you will enforce referential   integrity, which ensures that the relationship will remain intact if/when   data is updated in either table. Furthermore, you will ensure that all   changes to the primary key in your Cards table will be reflected in the foreign   keys that exist in the Rarity table by selecting the Cascade Update Related   Fields option.
 

  Create a relationship between the Cards   and Rarity tables tables, ensuring   you check the Enforce Referential   Integrity and Cascade Update   Related Fields options for the relationship.

After   also establishing the relationship between the Cards and Brands tables, in   the same manner, you will analyze the database to identify any flaws in the   design as well as suggested low-risk improvements that can be made to your   database.
 

  Create a relationship between the Cards   and Brands tables, ensuring you   check the Enforce Referential   Integrity and Cascade Update   Related Fields options for the relationship. Save, and close the   Relationships window. Open the Performance   Analyzer dialog box, under All Object Types, click Select All, and then click OK.   Note the idea to relate the Cards table to the others in the database. Close   the Performance Analyzer.

You   will now provide your users with a simple and intuitive way to add and edit   cards by creating a form.
 

  Create a new form based on the Cards   table using the Form tool. Save   the form as Add or Edit Cards.   Close the form.

Now   that you have the Add or Edit Cards form created, you can add that and the   remaining forms to a Horizontal Tab navigation form. By doing this, you will   create a one-stop-shop for your users to view and edit the trading cards in   the database.
 

  Create a navigation form based on the Horizontal   Tabs template. Drag the Add or   Edit Cards form to the first tab position.

Drag   the All Player Cards report to the   second tab position.

Drag   the Bowman Cards report to the   third tab position.

Drag   the Donruss Cards report to the   fourth tab position.

Drag   the Fleer Cards report to the   fifth tab position.

Drag   the Topps Cards report to the   sixth tab position.

Switch   to Form view and test the navigation form. Save the navigation form with the   default name and close it.

You   will finalize the interface for your users by hiding the Navigation Pane so   that it is out of their way, and setting the navigation form you created to   open automatically when the database opens. This ensures that the user’s   experience is seamless and straightforward.
 

  Set the database to hide the Navigation Pane and open the navigation form   when the database opens. Close the database and reopen it observe that the   form opens automatically.

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

This lab assignment requires you to compare the performance of two distinct sorting algorithms to obtain some appreciation for the parameters to be considered in selecting an appropriate sort. Write a HeapSort and a Shell Sort. They should both be recursive or both be iterative, so that the overhead of recursion will not be a factor in your comparisons. In this case, iteration is recommended. Be sure to justify your choice. Also, consider how your code would have differed if you had made the other choice.

Photo of assignment attached below. If any questions: Feel free to reach out.

 Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.

1. Should society help workers dislocated when technology, like the Internet, elimlnates their jobs in a process called ‘Creative Destruction‘?

2. are we working more and earning less?

3. Would you want a telecommuting job? Why or why not? 

4. Does the gig economy appeal to you? Why or why not?

5. How is an employee differentiated from a contracter under US law? 

6. Why have some municipalities put restrictions on innovations in the sharing economy and in on-demand services?

7. What has been the effect on the US economy of outsourcing (or offshoring) technical and professional jobs? 

8. How much monitoring of employee activities at work is appropriate? 

9. Should an employer be able to discipline or terminate an employee for on-line behavior in his/her own time? 

10. What is the relationship betwee BYOD (bring your own device) and shadow IT. 

11. What is cyberloafing?

Research and read how information/content is broadcast on the Internet. Here is a good starting point – Broadcasting (networking). Once you have done with research, it is time for the discussion board.  Post your detailed/substantive reflections and ideas. Remember:  this is a discussion board — bring your thoughts and observations to the forum.

Sub: Operational Excellence 

Resistance to change is a normal everyday aspect in the workplace.  Note what happens to the organizational climate when this resistance occurs and any tactics to reduce negative connotations when dealing with change. 

APA 7 format 

follow the instruction in the attached file.

Discuss how the advent of AI/MI and how it may affect network security. What do you think network security will look like 5 years, 10 years, or 15 years from now. How will the cloud play into this scenario or will there be something bigger than the cloud that could affect network security?

 PART 1: Executive Summary of IT Infrastructure Assessing the current state of the business before starting the full project is a necessity when it comes to working with infrastructure. International Plastics, Inc., a  manufacturing company, hired you as a technology consultant to work with the company to review its resources and develop a plan for its infrastructure needs. Your first step is to become familiar with the company’s current documentation and provide a status update to the executives. Review the ZIP file for International Plastics, Inc. documentation. Write a 1 to 2-page executive summary of International Plastics’ business requirements for an upcoming discussion with the CEO. As a general guideline,  executive summaries are typically1 to 2 pages in length, at 12 pt. font, and single-spaced. Include the following information: • A high-level description of International Plastics’ current IT Infrastructure, including network, information systems, applications, mobile computing, data  management, business intelligence, and security • An overview of International Plastics’ operational environment • An explanation of how a new IT infrastructure will improve business performance • A chart listing at least three examples of technology hardware upgrades and how they will improve business performance PART 2: Identifying Current IT Standards and Protocols and Making Recommendations The International Plastics, Inc. CEO read your executive summary and would like more information. The CEO would like a detailed explanation of the IT standards,  protocols, and communication tools currently in use in the facilities to determine if improvements are needed. Review the existing International Plastics network diagrams located in the International Plastics, Inc. documents ZIP file. Assess the current telecommunications  protocols, standards, and collaboration tools used for International Plastics. Determine if improvements are needed, and if so, list your recommendation with how  the improvement will affect the standard or protocol (you will use this to prepare the required chart).Copyright 2021 by University of Phoenix. All rights reserved. Prepare a chart/table, using Microsoft® Word or Microsoft® Excel®, to document at least 6 current standards or protocols used at each location. Use the  following table headings: • Current Telecommunications Standard, Protocol, or Collaboration Tools • International Plastics Location • Recommendation for Improvement with anticipated effects of Improvement Decide on a recommendation that will have the most beneficial impact to the company. • Write a 1-page explanation on how you made the decision to move forward with this recommendation. What are the advantages and disadvantages of this  recommendation? Submit your PART 1: Executive Summary of IT Infrastructure and your PART 2: Identifying Current IT Standards and Protocols and Making Recommendations. 

Chapter 5, Exercise #6  with Visual Logic.

The Jumpin’ Jive coffee shop charges $2.00 for a cup of coffee and offers the add-ins shown in Table 5-3. 

Product                                              Price ($) 

Whipped cream                                0.89

Cinnamon                                         0.25

Chocolate sauce                              0.59 

Amaretto                                         1.50

Irish whiskey                                   1.75

Table 5-3 

Add-in list for Jumpin’ Jive coffee shop Design the logic for an application that allows a user to enter ordered add-ins continuously until a sentinel value is entered. After each item, display its price or the message: “Sorry, we do not carry that as output” when an invalid item is entered. After all items have been entered, output the total price for the order.