Create a site map of a website you are familiar with. It need not be an overly large or complex website (in fact, it would be to your detriment to choose a very large site!). It can be the website of a local business or one in your hometown, or even the website of a friend or one of your own. Something 7 to 10 pages in size is sufficient. All links must be accounted for and mapped. Using Microsoft Word for this is preferred, but you may use any similar software you choose as long as you achieve map with a similar look to those created in Coding Video 2.
Assignment
Topic: Perform a Vulnerability Assessment of your place of employment or living area. If you use your work area make sure you inform the Security Manager to get permission as to what you are doing. If you live in a gated community inform the security guard of your activities.
Instructions: Please download the Assignment 1 Vulnerability Assessment template (MS Word), which is already in APA 7 format, using size 12 Times New Roman font, 1-inch margins, TOC, Headings and Reference page. If you insert images or tables in your report make sure you label them appropriately according to APA. (click here for link).
For this assignment: The 4 Heading-1s are required. Each Heading-1 must have at least 3 Heading-2s. Each Heading must have at least 2 properly formatted paragraphs with 3 properly formatted sentences each. Once completed name your file: YourName_Assignment_1_Vulnerability_Assessment.docx and submit to the appropriate assignment folder.
Practical Assignment – Crypto
Provide a reflection of at least 500 words of how the knowledge, skills, or theories of cryptography have been applied, or could be applied, in a practical manner to your current work environment.
APA format with references needed.
Practicum Connection Assignment – Telecomm Network Security
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of the course have been applied, or could be applied, in a practical manner to your current work environment.
Write an 8-10-page paper on an organization of your choice
Write an 8-10-page paper on an organization of your choice
project 6 to ppt
All assignment must be/have: In APA with a separate Cover and Reference page In 12 Font Doubles spaced In a Microsoft Word format 2-3 Pages of findings Have 4-6 LIRN Library resources that are cited within the paper to show where they apply.
Explain how to determine appropriate tests of controls and consider the results of tests of controls in auditing long-lived assets.
Explain how to determine appropriate responses to identified risks of material misstatement in auditing long-lived assets.
around these questions make ppt of slides 8.
Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0
#Exp19 Access Ch06 Capstone – Northwind Traders Sales Analysis 1.0
Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0
Project Description:
Northwind Traders is a small international gourmet foods wholesaler. You will update the company’s database by increasing the price of all of the meat and poultry products. You will make a table for archiving older order information. You will also summarize quantities sold by category and identify customers who have no orders.
Start Access. Open the downloaded Access file named Exp19_Access_Ch6_Cap_Northwind. 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.
Using a select query, you will identify all of the products with a category of meat or poultry, and then use an update query to increase the prices of the products.
Create a select query that includes the CategoryID from the Categories table and the UnitPrice and ProductName fields from the Products table (in that order). Run the query and note the CategoryID for Meat/Poultry.
Add the appropriate CategoryID criterion to limit the query output to only Meat/Poultry. Convert the query to an update query. Update the UnitPrice for Meat/Poultry only by increasing it by 6 percent.
View the query in Datasheet view prior to running it to make sure you are updating the correct (four) records. Return to Design view and run the query. Save the query as Update Meat/Poultry Prices. Close the query.
You will identify orders shipped during the first half of the year and create a new table in which to store them. You will then delete the orders from the current orders table.
Create a select query that identifies all of the orders shipped Between 1/1/2020 and 3/31/2020. Include all fields from the Orders table.
Convert the select query to a make table query. Name the new table Orders Archive. Run the query. Save the query as Make Orders Archive Table. Close the query.
Make a copy of the Make Orders Archive Table query and save it as Append Orders Archive Table. Open the Append Orders Archive Table query in Design view. Convert the make table query to an append query. The query will append to the Orders Archive table.
Modify the criteria to append orders shipped Between 4/1/2020 and 6/30/2020. Run the query, save it, and then close it.
Open the Orders Archive table in Design view and set OrderID as the primary key field. Switch to Datasheet view, then save and close the table.
Make a copy of the Append Orders Archive Table query and save it as Delete Archived Orders. Open the Delete Archived Orders query in Design view. Convert the append query to a delete query.
Modify the criteria to delete all archived orders from the Orders table (six records). Run, save, and then close the query.
You want to determine how sales are performing with respect to each product category. You will create a crosstab query that displays quantities by category and salesperson.
Open the Profit query in Design view and add the LastName field from the Employees table to the last column of the design grid. Run, save, and close the query.
Use the query wizard to create a crosstab query based on the Profit query that sums the total Quantity by Ship Country (row heading) and CategoryName (column heading). Accept the query name as Profit_Crosstab.
Modify the query to display CategoryName as the row heading field and LastName as the column heading field. Run, save, and close the query.
You will create a query to determine which customers have no matching orders. The customers will be contacted to determine if they would like to place an order.
Create a query to find out if any of the customers have no current order details. Add all of the fields from the Customers table to the results. Save the query as Customers With No Orders. Run the query and close it.
Close all database objects. Close the database and then exit Access. Submit the database as directed.
Assignment
A Security Awareness Program plays an important role in defining the security posture of an enterprise. When managers consider the nature of risk an organization is exposed to, the threats fall into two distinct categories: the risk of disaster and the risk of intentional abuse.
Using the online library resources, industry websites or published articles (scholarly or trade) find two sources which describe how security awareness impacts the success of an enterprise’s security posture. Write a short paper (2 to 3 pages) which provides description of the components of the Security Awareness Program, the type of security threats it addressed (disaster versus intentional abuse), and the effects on the attitudes and behaviors of members of the enterprise.
Please list your reference/s
Exp19_Access_Ch2_Cap – Metropolitan Zoo 1.0
Exp19_Access_Ch2_Cap – Metropolitan Zoo 1.0
Exp19_Access_Ch2_Cap – Metropolitan Zoo 1.0
EX19_AC_CH02_GRADER_CAP_AS
Access Chapter 2 Capstone – Metropolitan Zoo 1.0
Project Description:
The Metropolitan Zoo tracks its animal data in Excel. The organization decides to use a database to organize the data about the animals, their trainers, and the animal exhibits. In this project, you will open an existing database and create a new table. You will import an Excel file containing information about the animals, and query the database to determine which animals need a checkup. You will also create a query to obtain a listing of the animals in each exhibit.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access file named Exp19_Access_Ch2_Cap_Zoo.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.
0
2
Create a new table in Design view. Add the field name ExhibitID with the AutoNumber Data Type. Add the caption Exhibit ID. Set the ExhibitID field as the primary key for the table. Save the table using the name Exhibits.
6
3
Add the following fields and set their field properties as shown:
Field Name
Data Type
Field Size Property
Caption
ExhibitName
Short Text
15
Exhibit Name
Acres
Number
Integer
(none)
InitialCost
Currency
(no change)
Initial Cost
YearlyCost
Currency
(no change)
Yearly Cost
DateOpened
Date/Time
(no change)
Date Opened
Show
Yes/No
(no change)
(none)
12
4
Switch to Datasheet view and save the table. Add the following records, letting Access assign the Exhibit ID:
Exhibit Name
Acres
Initial Cost
Yearly Cost
Date Opened
Show
Asia
2
2000000
300000
1/15/2011
Yes
Africa
4
3500000
500000
2/3/2014
Yes
The Americas
3
1500000
250000
5/15/2005
No
Close the table.
9
5
Import the downloaded Zoo.xlsx workbook as a new table in the current database. Using the Import Spreadsheet Wizard, specify that the first row contains column headings, set the AnimalID field to be indexed with no duplicates, and set the AnimalID field as the primary key. Import the table with the name Animals and do not save the import steps.
10
6
View the Animals table in Design view, and change the field size for the AnimalID field to Long Integer. Change the field sizes for the ExhibitID and TrainerID fields to Long Integer. Save the table. Click Yes in the dialog box indicating that some data may be lost. Close the table.
6
7
Begin establishing relationships in the database by adding the Animals, Exhibits, and Trainers tables to the Relationships window. Close the Show Table dialog box. Resize the field lists so that all fields display. Create a one-to-many relationship between the ExhibitID field in the Exhibits table and the ExhibitID field in the Animals table, enforcing Referential Integrity. Select the option to cascade update the related fields.
8
8
Create a one-to-many relationship between the TrainerID field in the Trainers table and the TrainerID field in the Animals table, enforcing Referential Integrity. Select the option to cascade update the related fields. Save and close the Relationships window.
8
9
Create a query using the Simple Query Wizard. From the Animals table, add the AnimalID, AnimalType, and DateOfLastCheckup fields (in that order). Ensure the query is a Detail query. Name the query Checkup List and finish the wizard.
10
10
View the query in Design view, and then set the criteria for the DateOfLastCheckup field so that only animals whose last checkup was before 1/1/2022 are displayed.
5
11
Sort the query in ascending order by the DateOfLastCheckup field. Save the query. Run the query, and then close the query.
5
12
Create a new query in Design view. Add the Animals, Exhibits, and Trainers tables to the query design window. Add the following fields to the query (in this order):
AnimalType
Origin
ExhibitName
FirstName
LastName
Position
9
13
Set The Americas as the criteria for the ExhibitName field and sort the query in ascending order by Origin. Run the query, and save the query as Americas Exhibit. Close the query.
6
14
Copy the Americas Exhibit query in the Navigation Pane and paste it with the name Asian Exhibit. Modify the query in Design view to replace The Americas with Asia. Run the query, save the query, and close the query.
6
15
Close all database objects. Close the database and then exit Access. Submit the database as directed.
0
Total Points
100