Exp19_Access_Ch09_Cap – Trading Cards 1.0

 #Exp19_Access_Ch09_Cap – Trading Cards 1.0

Exp19 Access Ch09 Cap – Trading Cards 1.0

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.

 Target the senior-level executives in your organization. • Provide a paper about one of the three Security Practices in the OWASP SAMM 2.0  Business Function “OPERATIONS”: o Incident Management o Environmental Management o Operational Management • Provide the importance of these items and why SAMM assessment needs to be conducted. Instructions: • Write a summary on the Security Practice that you selected of the three in the  OPERATIONS OWASP SAMM 2.0 Business Function. o Describe in full detail. o Also answer these two questions in full detail, clearly demonstrating  understanding with no detail missing:  The importance of these items, AND  Why SAMM assessment needs to be conducted Requirements: • 2–3 page APA paper excluding title and reference pages  • Provide at least two references and in-text citations in APA format (these will preferably  be in addition to the main text)  • College-level writing  • Should be your own work in your ow 

 What are some things you can do to make your worksheet easier for others to read and understand?

 As an IT analyst for Dominion Online, a company providing voting solutions to a global client base, you are working to convince the organization to move its infrastructure to a public cloud. With the growth the company is experiencing, and the internal data centers maxed out, you want to get the executives on board with moving to a public cloud rather than trying to expand the current infrastructure. Please respond to the following questions for Dominion Online1: Identify the Most Appropriate Guidelines for Managing Risks

2: Identify Potential Privacy Issues and Mitigation Measures

3:Create Risk Management Matrix to assess/analyze that risk and make recommendations for risk mitigation measures. Please use excel format to create Risk Management Matrix.

4: Please add references 

  Exp19_Word_Ch03_HOEAssessment_Radio

Project Description:

You work with the Radio Advertisers Federation to promote the use of radio advertising. In this document, you provide a summary of research related to the weekly reach of various media sources, including tables describing the reach as well as the weekly hours most households spend with those sources. The summary will be distributed to various local advertisers as part of a mail merge process.

Start   Word. Download and open the file named Exp19_Word_Ch03_HOEAssessment_Radio.docx. Grader has automatically added   your last name to the beginning of the filename.

Ensure that Ruler is shown and   that nonprinting characters are displayed. Move to the last page of the   document and type the following, beginning in the first cell of the blank row   at the bottom of the table:
 

24 RA Tablet 78.1

Move to the second blank   paragraph following the table. Draw a table approximately 6 inches wide and 3   1/2 inches tall. Draw one vertical grid line at approximately 3 inches from   the left to create two columns. Draw 5 horizontal grid lines to divide the   table into 6 approximately evenly spaced rows of about 1/2 inch each. Rows do   not have to be precisely spaced as you will distribute them later.

   Erase the vertical gridline in the first row, so that the row includes only   one column. Ensure the insertion point is located in the first row and type Table 2 –   Weekly Hours (Average Watch or Listen Time). (Ensure that a space precedes   and follows the hyphen and do not type the period.) Press TAB and complete   the table as follows (do not press TAB at the end of the last entry):
 

Radio 25.7
TV 21.5
Smartphone 18.3
PC 10.7
Tablet 7.7

Select Table 2 and change the   font size of all text to 12 pt. Apply bold formatting to the first row in   Table 2. Delete the Category column in the first table. Insert a row above   the first row in Table 1 and type Table 1 – Weekly Reach of Media. (Ensure that a space precedes   and follows the hyphen and do not type the period.)

In Table 1, insert a row between   Hub and Insight. Type the following in the new row, ensuring that the new   entry is in Times New Roman, 12 pt.
 

Nielsen Smartphone  142.3

In Table 2, insert a blank row   above row 2. Type Source in the first cell of the new row and type Hours in the second cell. Apply bold   formatting to both cells. Select Table 2, ensure that the Table Tools Layout   tab is selected, and click Distribute Rows.

Select cells in the first column   of Table 1, from row 2 through the end of the table. Ensure that you do not   include text from row 1. Split the cells, making sure to deselect Merge cells before split. Type Source in cell 2 of row 2 in Table 1.   Complete the remaining cells in the second column as follows. (Type only   those shown in column 2 of the list below.)
 

PPM  30
Hub 87
Neilsen 82
Insight 26
RA 12

Insert a row below the last row   in Table 1. In the third column of the new row, type Total. Apply bold formatting to the   word Total and apply Align Center   Right alignment. In the next cell on the same row, enter a formula to sum all   cells in the column above. You do not need to select a number format.

Sort the rows containing media   sources in Table 1 (rows 3-7) by Column 3 in ascending order so that the   media sources are shown in alphabetical order. Do not include the heading   rows or the total row in the sort.

Insert a column to the right of   the last column in Table 1 and type Percentage of Total in the second row of the new   column. In the third row of the last column, type a formula that divides the   Households Reached value in the cell to the left by the Total in the last row   and then multiplies by 100 to convert the result to a percentage. The formula   is =d3/d8*100. Select a number format of   0.00%.

Include a formula in each cell   in the Percentage of Total column except for the last cell (on the Total   row), adjusting cell references in each formula to reflect the current row.   Apply Align Center alignment to all numeric entries in the last two columns.

Merge all cells in the first row   of Table 1 and ensure that the text is centered. Change the number of   households reached by TV to 197.5. Update the field in the last row of that column (the total) and   also update all fields in the last column to reflect that change.

At the first blank paragraph at   the beginning of the second page, insert text from Radio_Statistics.docx. In Table 1, apply a style of Grid Table 4   – Accent 3 (row 4, column 4 under Grid Tables). Deselect First Column in the   Table Style Options group to remove bold formatting from the first column.   Bold all cells in row 2 and apply Align Center alignment.

Center both tables horizontally   on the page. Select Table 2. Select a border style of Double solid lines, ½   pt, Accent 3 (row 3, column 4). Apply the border style to all borders.

Select row 1 of Table 2 and   apply a custom shading color of Red – 137, Green – 121, and Blue – 139.   Change the font color of all text in row 1 to White, Background 1 and ensure   that it is bold. Shade all remaining rows, including those on page 3, in Light   Gray, Background 2. Change the Pen Color to Black, Text 1, and drag the   border dividing row 1 from row 2 in Table 2.

Select the first two rows of   Table 2 and repeat the header rows so that they display at the top of the   table section that is currently shown on page 3. Include a caption below   Table 1 with the text Table 1: Household   Reach of Media Sources. (Do not type the period and ensure that a space follows the   colon.) Include a caption below Table 2 with the text Table 2: Average Weekly Hours. (Do not type the period and   ensure that a space follows the colon.) Modify the Caption style to include   center alignment with bold, italicized text.

Move to the end of the document   and press ENTER. Insert text from Ratings_Sources.docx.   Select all text from Ratings Source   to http://www.rainc.com. Whether   you select the paragraph mark following the URL is irrelevant; however, do   not select the blank paragraph on the following line. Convert the selected   text to a table, accepting all default settings. Apply a table style of Grid,   Table 4 (row 4, column 1 under Grid Tables) and add a caption below the new   table as Table 3: Major   Ratings Sources.   (Do not type a period.)

Begin a mail merge procedure,   selecting the Access database Source   Ratings.accdb as a recipient list. Note Mac users, select the text file Source Ratings.txt as a recipient   list.
  Edit the recipient list to add the following record and respond affirmatively   when asked to update the recipient list:
 

  Source ID  Company Guild Member
B9111 Insight False

Filter the recipient list to   select only those with a value of False in the Guild Member column. Replace [Company Name] in the last body paragraph on page 2 with the   merge field of Company. Be sure to   include the brackets in the text to be replaced.

Preview results and then finish   the merge, editing individual documents and merging all. Press CTRL+A to   select all of the merged document and copy the selection. Display Exp19_Word_Ch03_HOEAssessment_Radio,   move the insertion point to the end of the document (after the last caption)   and insert a page break. Paste all copied text, resulting in a 7-page   document

Save and close Exp19_Word_Ch03_HOEAssessment_Radio.docx. Close all other open documents without   saving. Submit   Exp19_Word_Ch03_HOEAssessment_Radio.docx as directed.

• Select one of these major cloud service models: IaaS, SaaS, or PaaS.
• Describe key issues when configuring and operating security for your selected cloud service model.
  • Be sure to support your response with examples based on your research and experience.
• Provide a full citation and reference

I need this paraphrased so it shows less than 10% on turnitin.com provide the report.

Need guidance with my computer ethics class.

2018 ACM Code

https://plato.stanford.edu/archives/sum2020/entries/ethics-computer/

https://mediacentral.princeton.edu/media/CITP+WebinarA+Ed+Felten+-+COVID-19%2C+Technology%2C+Privacy+and+Civil+Liberties/1_syzkrdfd

Need a 300 words discussion post for each question with URL references links. 

1.  Data mining and big data 

2.  Protection of cloud-based applications and infrastructures 

Note: NO PLAGIARISM

Write a short survey on computer graphics.

The question is: How has computer graphics influenced the gaming industry?

This assignment is not a group paper. Follow the APA Publications Manual sixth Ed. Limit your first post to a minimum 300 words. You must include five verifiable references.