1: Perform the affinity analysis using the Principle of Best Guess on the STA case study. Name the Business Area Analysis. Use the attached STA Process-Entity Type CRUD matrix.

 GO16_AC_CH08_GRADER_8G_AS – Inventory Management

Project Description:

In this project, you will manage a database for the local gift shop. To complete the project, you will create macros to automate the process.

Start Access. Download, save, and   open the database named go_a08_grader_a3.accdb.

Open   the Intro Screen form in Design view. Change the Pop Up and Modal properties   to Yes. Save and Close the form

Create   a macro to open the Intro Screen form with the comment Opens the Intro Screen form immediately following the action. In   the Show/Hide group, be sure the Show All Actions button is active. Save the   macro as autoexec.

Add   the action OpenForm to open the Inventory Data form with the comment Opens the Inventory Data form   immediately following the action.

Add   the action DisplayHourglassPointer with the Comment Displays the busy icon immediately following the action.

Add   the Echo action. In the Echo Action Block, change the Echo On box to No.   Click in the Status Bar Text box, and then type Macro is running.   Add the comment Hides the flickering   screen as the macro runs immediately following the action.
 

  Move the first OpenForm action and comment below the Echo macro comment. Save   and close the macro.

Open   the Inventory Data form in Design view. In the Detail Section, add a Button   control at the 2-inch mark on the horizontal ruler and three dots below the   Detail section bar with the caption &Inventory   List.   Embed a macro to Open the Inventory by Vendor report in Print Preview. Save   and Close the macro. Save and close the form.

Open   the Employees table in Datasheet view. Add a data macro Before Change. Add   the If Block with the condition [# Hours]>=32.

In   the If Block, add the SetField action to set Status   to “Full time”.

In   the If Block, add an Else block, and then add the SetField action to set Status to “Part   time”.   Close the Macro Designer, saving changes. Save the table.

In   Record 4, update the # Hours to 18,   in Record 5 update the # Hours to 33.   Click in the first field in the first record, and notice the updates to the   Status field. Close the table.

Save   the database. Close the database, and then exit Access. Submit the database   as directed.

• Discuss the differences between intrusive and nonintrusive tests. Is it possible to provide a secure environment with no intrusive tests?

• What suggestions do you have for your classmates on their network cabling? 
• Are there any other suggestions for what they should consider for their equipment setup? 

As someone who just started working from home for the first time ever this year, this is kind of fun to do.

• Where are you moving to for your new work-from-home position? Which  ISPs are available at this location? Which do you pick and why?  
  • I will be moving to Dallas, Texas, where there are a few ISP options  available, such as Fios, Cox and Xfinity. I will be using a trusted  nationwide company, Xfinity. I am using them because I have experience  with their speeds and reliability; if necessary, there are download  speeds up to 1200mbps(megabytes per second) available, which is more  than enough to work from my home (Xfinity). Xfinity also has wonderful  customer support and great deals on their services.
• What equipment do you need for your work-from-home position? What  does your ISP provide? What does your employer provide? What do you need  to provide? 
  • I will need two monitors, a high-quality router, a desktop, a  laptop, desk and chair, wireless headset, HDMI cables, surge protectors,  and a keyboard and mouse. My ISP is providing my router only. My new  job is supplying me with the laptop, monitors, keyboard and mouse and  headset. Everything else, I will purchase myself. 
• What types of network cabling will you be using and with which devices? 
  • I’ll use an ethernet cable for the tower of the desktop and CAT5 for  the router. Everything else will be wireless aside from power cables  and HDMI for the monitors.
• How do you determine the IP addresses on your devices? 
  • The IP address can either be found in settings in the “About Device” section or in the command prompt.
• How will you set up equipment in your office in your new home? Will  you be using wireless or hard wire for your network connection? What  else should be considered? 
  • I’ll have a large L-shaped desk and have the monitors sitting side  by side on one part with the desktop tower and modem on one of the desk  shelves for hardwiring, and the laptop on the other side. The desktop  will be hardwired, but the laptop will be wireless. Both will be  connected to a VPN for added security with two-factor authentication.

Consider an enterprise security organization. It will be a team of mixed skills and capabilities. Also, consider an adversary, such as a foreign government intending to digitally break into the company, and learn their business practices. Describe the teams involved in defending the company against this particular threat and their roles in the defense.

Parameters 

• Posts should be 250 to 300 words in length
• Must include at least one source outside of your textbook, and it should be included in the reference list at the end of the post
• All sources should be used in the content of the post using APA format

3 Assignments – 2-3 pages each.

Exp19_Access_Ch02_ML2 – Prestige Hotel 1.0

EX19_AC_CH02_GRADER_ML2_HW

Project Description:

The Prestige Hotel chain caters to upscale business travelers and provides state-of-the-art conference, meeting, and reception facilities. It prides itself on its international, four-star cuisine. Last year, it began a member reward club to help the marketing department track the purchasing patterns of its most loyal customers. All of the hotel transactions are stored in a database. Your task is to help the managers of the Prestige Hotels in Denver and Chicago identify their customers who stayed in a room last year and who had two persons in their party.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch02_ML2_Hotel. 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.

Import   the location data from the Excel file Location.xlsx   as a new table in the current database. Using the wizard, specify that the   first row contains column headings, set the LocationID field to be indexed   with no duplicates, and set the LocationID field as the primary key. Import   the table with the default name Location   and do not save the import steps.

View   the Location table in Design view and change the field size for the   LocationID field to Long Integer.   Save the table. Click Yes in the   dialog box indicating that some data may be lost. Close the table.

Add   the Location, Orders, Members, and Service tables to the Relationships window to begin establishing   relationships in the database. Close the Show Table dialog box. Create a   one-to-many relationship between the Location table and the Orders table   using the LocationID field. Enforce Referential Integrity. Select the option   to cascade update the related fields.

Create   a relationship between the Members and Orders tables using the MemNumber   field, ensuring that you enforce referential integrity and cascade update   related fields.

Create   a relationship between the Service and Orders tables using the ServiceID   field, ensuring that you enforce referential integrity and cascade update   related fields. Save and close the Relationships window.

Create   a new query in Design view using Location,   Members, Orders, and Service tables.   Add the following fields to the query (in this order): ServiceDate from the Orders table; City from the Location table, NoInParty from Orders table; ServiceName   from the Service table; and FirstName   and LastName from the Members   table. Set the criteria in city field to limit the output to Denver.

Display   only service dates from 7/1/2017   to 6/30/2018 (Hint:   Use the Between   command).

Set   the NoInParty criterion to 2.   Sort the results in ascending order by the ServiceDate. Run and save the   query with the name Denver Rooms 2 Guests.

Use   Design view to change the order of the query fields so that they display as   FirstName, LastName, ServiceDate, City, NoInParty, and ServiceName. Run, save   the changes to the query, and close the query.

Copy   the Denver Rooms 2 Guests query   and paste it in the Navigation pane, renaming the new query Chicago Rooms 2 Guests.

Open   the Chicago Rooms 2 Guests query   in Design view, and change the City criterion from Denver to Chicago.   Run the query and save the changes. Close the query.

Close   the database and exit Access. Submit the database as directed.

How is the regulation of security and trustworthiness on the Internet likely to develop? Will the private sector improve trust online? Will governments have to step in more? Will public confidence in the Internet decline to such a great extent that other infrastructures will become more popular?

Python and the database tool SQLite will develop a functional project of your choice from the Capstone Project List. You will begin with an approach/strategy statement of the project, use the topics covered in class and document your code using comments inline to the code. And most of all, have fun building a project!

175 words: 

• What are the most valuable resources within a team?
• Who do you feel should be responsible for determining how team resources are used?
• How can changes to the availability of resources affect team dynamics?
• What are the most important project management and planning skills needed to keep a team on track toward its goals? How would you rate your level of proficiency with these skills?