Description
- Discuss how you would discover and adhere to policies and procedures in an organization that did a poor job of documenting them.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Completion Status:
100%
Review
Review
Anonymous
Goes above and beyond expectations!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
8 pages
Successful Digital Forensic Investigations.edited
A successful digital forensics investigation needs to follow certain clear steps in order for it to have tangible evidence ...
Successful Digital Forensic Investigations.edited
A successful digital forensics investigation needs to follow certain clear steps in order for it to have tangible evidence especially for purposes of ...
CSCI 430 Page Replacement Schemes and Clock Algorithm Codes Project
The following google drive link contains all the required filed needed in the assignment. I have also attached the assg04 ...
CSCI 430 Page Replacement Schemes and Clock Algorithm Codes Project
The following google drive link contains all the required filed needed in the assignment. I have also attached the assg04 pdf file which contains the question and ass04 zip file where you have to edit the code. https://drive.google.com/drive/folders/1TA6o9JXVg4...
6 pages
Project Selection And Planning..edited
It’s the dream of every organization to reduce the cost of production and increase the profit margins. Therefore, Pine V ...
Project Selection And Planning..edited
It’s the dream of every organization to reduce the cost of production and increase the profit margins. Therefore, Pine Valley Furniture should ...
IT Assignment Find one article on any course related topic (computer or information technology), computer science homework help
Find one article on any course related topic (computer or information technology).The article should be relevant to a cour ...
IT Assignment Find one article on any course related topic (computer or information technology), computer science homework help
Find one article on any course related topic (computer or information technology).The article should be relevant to a course topic and from a creditable source. You may choose your article from independent reading and research; or you may search the Internet. Also consider the following:The magazine Smart Computing in Plain English:www.smartcomputing.com/ A more technical publication is PC Magazine:www.pcmag.comSee also:http://www.itworld.com/http://www.pcworld.com/www.howstuffworks.com/www.geek.comAtwww.pcpitstop.comSummarize the article in your own words and include information in your paper on how the article relates to course concepts. Discuss the course material. Demonstrate you have read the textbook and you understand how to relate your research to current events. Use the appropriate APA citation to illustrate when you move from the article summary to material from the textbook.Your article summary should not exceed 5 pages and not less than 3 pages. Turnitin will be used to assess the originality of your work
ENTD 321 APUS Application Classes and Architecture Implementation Programming Task
Application Classes and ArchitecturePurposeThe purpose of this assignment is to begin the design modeling for our ITOT Cas ...
ENTD 321 APUS Application Classes and Architecture Implementation Programming Task
Application Classes and ArchitecturePurposeThe purpose of this assignment is to begin the design modeling for our ITOT Case Study. For this assignment, you will develop an application class diagram that includes entity, view, and controller classes as well as an architecture diagram.In this assignment we will begin the design for the case study, the IT Online Training Project. You have already completed sample analysis specifications for this case study. This assignment is based on the IT Online Training Project Requirements 2018R2. In this assignment you will develop an application class diagram and the software architecture for the application. The software architecture is usually developed at the very beginning of analysis and design, is continually updated, and is the guiding document for the design of the application.Course Objective(s)CO5: Describe the software development process including application analysis and system designYou will use the new Design Specification Template 2018 document to create your design specifications. Make certain that you keep the formatting and numbering of the template for your assignments. The Design Specification Template is a Word file with predefined sections that you will complete each week as you did with the Analysis Specification. In this assignment you will create an application class diagram for your detailed use case and you will also create a system architecture for your application.In this assignment you will complete the following sections of your Design Specification:1, 1.1, 1.2, 1.3 Introduction to the Project2, 2.1, 2.2, 2.3, 2.3 System Architecture Diagram for Case Study3, 3, 3.1, 3.2, 3.3, 3.4, 3.5 4+1 Architecture4, 4.1, 4.2 Application Class DiagramClass Design PurposeThe purpose of this assignment is to continue our design modeling for the ITOT Case Study by creating detailed class designs for both ShoppingCart and ShoppingCartItem classes.Course Objective (s)CO6: Describe the software development process including the implementation of models and object oriented languagesCO9: Apply your knowledge of object oriented and UML concepts by designing and developing UML modelsIn this assignment you will develop a detailed design for both the ShoppingCart and ShoppingCartItem classes. Follow the class design guidelines in your readings and use the appropriate use cases you have already developed for the project. Remember that the actions in the use cases and sequence diagrams have to be allocated to classes as operations and ultimately implemented in a programming language. Sequence diagrams include messages which are implemented as operations in classes. So you will need to make certain that your messages in your sequence diagram are reflected in your detailed design. You will need the detailed steps of the Manage Shopping Cart use case and your sequence diagrams. Provide a description of your class design and justification for your decisions.A class is often asked to provide the values of its attributes, so we usually create getter operations for each of the attributes while the attributes are made private. Like for Course we could create public operations like get.courseNo(), get.CourseTitle(), etc. and each of the attributes of Course would be made private so that any change is made through a publicly available operation(method). On the other hand we would create setter operations for each of the attributes to change the value of the attribute. So again we would have set.CourseTitle(courseTitle), etc. where the parameter would be the new course title.ShoppingCartItem would need operations/methods to manage the attributes it has like itemName, qty, costPerItem, and totalCost. So you would have an update operation/method and the getter/setter operations/methods. It would also have the operation/method to calculate the total cost since it has all of the attributes and values to do this.You will complete Sections 5 Class Design, 5.1 Detailed Class Diagram, and 5.2 Detailed Class Diagram Discussion in your Design Specification from last week.ImplementationPurposeThe purpose of this assignment is to continue with our design modeling of the ITOT Case Study. For the Manage Shopping Cart use case, you will create a test scenario, and two test cases. You will also create a persistent UML class diagram and SQL statements for ShoppingCart and ShoppingCartItem. Finally you will map your domain classes ShoppingCarat and ShoppingCartItem to Java statemens. Use you domain class diagram with attributes and operations.Course Objective(s)CO7: Describe implementation modeling for databases and programming styleCO9: Apply your knowledge of object oriented and UML concepts by designing and developing UML modelsYou will create two test cases following the format described in your design specification. In testing, test cases are developed first and then tested later by a different team. You will not be able to exercise your test cases (so you won't have Actual Results) but you can create the test case. You will also create SQL statements including constraints forShoppingCart and ShoppingCartItem. You will also create sample Java statements for ShoppingCart and ShoppingCartItem design classes.In this assignment you complete the following sections in your Design SpecificationSections 6, 6.1, 6.2, 6.2.1, 6.3, 6.3.1 on test cases, Sections 7, 7.1, 7.1.2, 7.2, 7.2,1 on SQL, and Sections 8, 8.1, 8.2 on Java.Instructions1. Review the Quick Resources listed at the end of this assignment.Test Scenario and Test Cases2. Section 6, 6.1. You will identify and document one test scenario (name and description) based on the Manage Shopping Cart use case and complete Sections 6 and 6.1 in your design specification. A test scenario is not the same thing as a test case!3. You will create and discuss two test cases for your scenario above for Manage Shopping Cart including test Case Name, Description, Prerequisites, Steps, Input, Expected Result, Actual Result, Status. The steps of the test case must be numbered!Test Scenario: <add your test scenario here for Manage Shopping Cart>Test Case IDTest Case DescriptionTest Case StepsExpected ResultsActual ResultsTest Case StatusTC001<add description?1. <add step><add expected result><add actual result><add status pass/fail>2, <add step>………………TC002<add description?1. <add step><add expected result><add actual result><add status pass/fail>2, <add step>………………3.1 You will create Test Case 1 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.2 of your design specification.3.1.1 You will add a discussion of Test Case 1 to Section 6.2.1 in your design specification.3.2 You will create Test Case 2 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.3 of your design specification.3.2.1 You will add a discussion of Test Case 2 to Section 6.3.1 in your design specification.4. Your entity (persistent) classes will most likely become tables in a relational database. In database design, we would follow normalization and functional decomposition guidelines to normalize our entities (classes) into valid relations. Then we would create SQL (Structured Query Language) statements to create the tables and add constraints. After that, we could populate our tables with data. We will assume our classes are normalized for this exercise.Persistent Class Diagram4.1 Create a persistent UML class diagram (without operations) of persistent data. You already have this from Assignment 2. Make certain that you include ShoppingCart and ShoppingCartItem. Designate primary and foreign keys. Add this to Section 7.1 in your design specification.4.2 Include a discussion of your persistent class diagram in Section 7.1.2 in your design specification.SQL Statements for ShoppingCart and ShoppingCartItem5. You will use two classes (ShoppingCart and ShoppingCartItem) from your persistent UML class diagram and create the SQL statements to implement the tables and constraints. You will need to include primary key and foreign key constraints. Add the SQL Statements to Section 7.2 of your design specification.5.1 Include a discussion of your SQL statements in Section 7.2.1 in your design specification6. Complete Section 7 of your design specification.Java for ShoppingCart and SoppingCartItem7. Create Java statements for ShoppingCart and ShoppingCartItem detailed design classes. Note that ShoppingCart and ShoppingCartItem have a composition type of part whole relationship. See the Engine and Piston example at https://coderanch.com/t/443002/java/Java-Coding-UML-Aggregation-Composition. Add them to Section 8.1 of your design specification and complete Section 8 and 8.2 discussion. You need to map the attributes and methods.
CIS 105 Maricopa Community College Macros & SQL Statement Microsoft Access
Lesson 12: Project DirectionsHands-On ProjectView GlossaryOverviewIn this hands-on project, you will be downloading a data ...
CIS 105 Maricopa Community College Macros & SQL Statement Microsoft Access
Lesson 12: Project DirectionsHands-On ProjectView GlossaryOverviewIn this hands-on project, you will be downloading a database from the Lifetime Media Company, a film and graphics company that does onsite filming and photos. The company uses this database to manage equipment assigned to its employees. You will be completing the following tasks in Microsoft Access:Creating a stand-alone macro Creating an embedded macro.Creating an event-driven data macroCreating a query by writing an SQL statement Project PreparationDownload the Lesson 12_Hands On Project file to your course lesson folder. Extract the file to the same folder.Open the file in Access.Save your file as "Lesson12_Project1_MEID.accdb" where MEID is your MEID.Project DirectionsOpen the Macro Designer and create a stand-alone macro to automatically open the Lifetime Media Equipment table. Select the following arguments:Table Name: Lifetime Media EquipmentView: Datasheet (default)Date Mode: Edit (default)Save the Macro as 'Open Name Objects' where name is your first name (example: Open John's Objects)Right-click the 'Open Name Objects' macro in the database and select Design View. Add an OpenForm action and the following arguments:Form Name: Equipment Checkout FormView: Form(default)Window Mode: Normal (default)Save and close the Macro. Right-click on the Equipment Assignments Report and open in Design View. The Property Sheet should also be on the right of your screen. You will now create a macro to send a reminder to the user upon closing the report to send an email to the auditor each Friday. Select 'On Close' from the Event list. Use the Macro Builder to create an embed macro that will prompt the user to send an Equipment Assignment report to the auditor each Friday by displaying a Message Box. In the Macro Builder, choose Message Box from the Actions drop-down menu.In the Message box type: 'Send Report to Auditor each Friday'.Beep: YesType: InformationTitle: 'Reminder'Save and close the macro. You can test your macro by opening the Equipment Assignments report from the Navigation pane and then closing the report. Open the Lifetime Media Equipment table if not already opened. You will be adding fields to indicate if a lost/damaged item needs to be replaced and a field indicating the replacement amount per item. Add a field titled 'ReplacementRequired' and format the field as Short Text. Add a field titled 'ReplacementAmountPerItem' and format the field as Currency. Save the Table before moving on to the next step.Create an event-driven data macro to calculate a 60% replacement amount when the 'ReplacementRequired' field has a value of "YES". Enter the arguments per the illustration below. If the 'ReplacementRequired' field has a value of "NO" the 'ReplacementAmountPerItem' field will remain empty. Event-Driven Data Macro - Sample FigureIf the 'ReplacementRequired' field = "YES" you will SetField 'ReplacementAmountPerItem' to be equal to 60% of the Per Unit Cost amount. Save and Close the macro. In the Lifetime Media Equipment table enter "YES" for 'ReplacementRequired' for records 2, 8, 9, 24, and 25. Enter "NO" for the rest. In the Lifetime Media Equipment table, add the following 2 records:One DSLR HD Camera for Jones at a per unit cost of $875.00. Replacement will not be required.One Studio HD Camera for Bernard at a per unit cost of $1200.00. Replacement will be required.Note: The replacement amounts are automatically calculated. Save and Close the Lifetime Media Equipment Table. Open a new query in SQL View. Type the following commands:SELECT [Employee Assigned To], [Item Name], [Quantity]FROM [Lifetime Media Equipment]WHERE [Per Unit Cost] >700;Run the query.View your results in Datasheet View.Save the query with the title Items over $700 Close the QueryCompact, repair, and save your database. Submit the assignment based on the instructions provided in the lesson.
Similar Content
MUSC Steps in Your Career Development Is a Lifelong and Ongoing Process Discussion
Career development is a lifelong and ongoing process. The Steps in your career development began with you, your style, and...
Creating a Organization, computer science homework help
All answers to the questions should be well written and well thought out.
Criteria to meet: Organization - strive for w...
What difference does the 5th generation computer have from other generation computers, computer science homework help
What difference does the 5th generation computer have from other generation computers?A.Technological advancementB.Scienti...
Can anyone do these 4 assignments for my Modules 3/4?
Module 3 - Case WIRELESS NETWORKS AND PERVASIVE COMPUTING ASSIGNMENT OVERVIEW The Case for this module involves a trage...
IP Camera’s Security Discussion
I need about 3 papers analyzing survey results for research about security concern of IP cameras. The analysis should incl...
Need help with computer science Which of these effects helps to make a circle look more round?
Which of these effects helps to make a circle look more round? (Select the best answer.) A. Ripple B. Lens flare...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
8 pages
Successful Digital Forensic Investigations.edited
A successful digital forensics investigation needs to follow certain clear steps in order for it to have tangible evidence ...
Successful Digital Forensic Investigations.edited
A successful digital forensics investigation needs to follow certain clear steps in order for it to have tangible evidence especially for purposes of ...
CSCI 430 Page Replacement Schemes and Clock Algorithm Codes Project
The following google drive link contains all the required filed needed in the assignment. I have also attached the assg04 ...
CSCI 430 Page Replacement Schemes and Clock Algorithm Codes Project
The following google drive link contains all the required filed needed in the assignment. I have also attached the assg04 pdf file which contains the question and ass04 zip file where you have to edit the code. https://drive.google.com/drive/folders/1TA6o9JXVg4...
6 pages
Project Selection And Planning..edited
It’s the dream of every organization to reduce the cost of production and increase the profit margins. Therefore, Pine V ...
Project Selection And Planning..edited
It’s the dream of every organization to reduce the cost of production and increase the profit margins. Therefore, Pine Valley Furniture should ...
IT Assignment Find one article on any course related topic (computer or information technology), computer science homework help
Find one article on any course related topic (computer or information technology).The article should be relevant to a cour ...
IT Assignment Find one article on any course related topic (computer or information technology), computer science homework help
Find one article on any course related topic (computer or information technology).The article should be relevant to a course topic and from a creditable source. You may choose your article from independent reading and research; or you may search the Internet. Also consider the following:The magazine Smart Computing in Plain English:www.smartcomputing.com/ A more technical publication is PC Magazine:www.pcmag.comSee also:http://www.itworld.com/http://www.pcworld.com/www.howstuffworks.com/www.geek.comAtwww.pcpitstop.comSummarize the article in your own words and include information in your paper on how the article relates to course concepts. Discuss the course material. Demonstrate you have read the textbook and you understand how to relate your research to current events. Use the appropriate APA citation to illustrate when you move from the article summary to material from the textbook.Your article summary should not exceed 5 pages and not less than 3 pages. Turnitin will be used to assess the originality of your work
ENTD 321 APUS Application Classes and Architecture Implementation Programming Task
Application Classes and ArchitecturePurposeThe purpose of this assignment is to begin the design modeling for our ITOT Cas ...
ENTD 321 APUS Application Classes and Architecture Implementation Programming Task
Application Classes and ArchitecturePurposeThe purpose of this assignment is to begin the design modeling for our ITOT Case Study. For this assignment, you will develop an application class diagram that includes entity, view, and controller classes as well as an architecture diagram.In this assignment we will begin the design for the case study, the IT Online Training Project. You have already completed sample analysis specifications for this case study. This assignment is based on the IT Online Training Project Requirements 2018R2. In this assignment you will develop an application class diagram and the software architecture for the application. The software architecture is usually developed at the very beginning of analysis and design, is continually updated, and is the guiding document for the design of the application.Course Objective(s)CO5: Describe the software development process including application analysis and system designYou will use the new Design Specification Template 2018 document to create your design specifications. Make certain that you keep the formatting and numbering of the template for your assignments. The Design Specification Template is a Word file with predefined sections that you will complete each week as you did with the Analysis Specification. In this assignment you will create an application class diagram for your detailed use case and you will also create a system architecture for your application.In this assignment you will complete the following sections of your Design Specification:1, 1.1, 1.2, 1.3 Introduction to the Project2, 2.1, 2.2, 2.3, 2.3 System Architecture Diagram for Case Study3, 3, 3.1, 3.2, 3.3, 3.4, 3.5 4+1 Architecture4, 4.1, 4.2 Application Class DiagramClass Design PurposeThe purpose of this assignment is to continue our design modeling for the ITOT Case Study by creating detailed class designs for both ShoppingCart and ShoppingCartItem classes.Course Objective (s)CO6: Describe the software development process including the implementation of models and object oriented languagesCO9: Apply your knowledge of object oriented and UML concepts by designing and developing UML modelsIn this assignment you will develop a detailed design for both the ShoppingCart and ShoppingCartItem classes. Follow the class design guidelines in your readings and use the appropriate use cases you have already developed for the project. Remember that the actions in the use cases and sequence diagrams have to be allocated to classes as operations and ultimately implemented in a programming language. Sequence diagrams include messages which are implemented as operations in classes. So you will need to make certain that your messages in your sequence diagram are reflected in your detailed design. You will need the detailed steps of the Manage Shopping Cart use case and your sequence diagrams. Provide a description of your class design and justification for your decisions.A class is often asked to provide the values of its attributes, so we usually create getter operations for each of the attributes while the attributes are made private. Like for Course we could create public operations like get.courseNo(), get.CourseTitle(), etc. and each of the attributes of Course would be made private so that any change is made through a publicly available operation(method). On the other hand we would create setter operations for each of the attributes to change the value of the attribute. So again we would have set.CourseTitle(courseTitle), etc. where the parameter would be the new course title.ShoppingCartItem would need operations/methods to manage the attributes it has like itemName, qty, costPerItem, and totalCost. So you would have an update operation/method and the getter/setter operations/methods. It would also have the operation/method to calculate the total cost since it has all of the attributes and values to do this.You will complete Sections 5 Class Design, 5.1 Detailed Class Diagram, and 5.2 Detailed Class Diagram Discussion in your Design Specification from last week.ImplementationPurposeThe purpose of this assignment is to continue with our design modeling of the ITOT Case Study. For the Manage Shopping Cart use case, you will create a test scenario, and two test cases. You will also create a persistent UML class diagram and SQL statements for ShoppingCart and ShoppingCartItem. Finally you will map your domain classes ShoppingCarat and ShoppingCartItem to Java statemens. Use you domain class diagram with attributes and operations.Course Objective(s)CO7: Describe implementation modeling for databases and programming styleCO9: Apply your knowledge of object oriented and UML concepts by designing and developing UML modelsYou will create two test cases following the format described in your design specification. In testing, test cases are developed first and then tested later by a different team. You will not be able to exercise your test cases (so you won't have Actual Results) but you can create the test case. You will also create SQL statements including constraints forShoppingCart and ShoppingCartItem. You will also create sample Java statements for ShoppingCart and ShoppingCartItem design classes.In this assignment you complete the following sections in your Design SpecificationSections 6, 6.1, 6.2, 6.2.1, 6.3, 6.3.1 on test cases, Sections 7, 7.1, 7.1.2, 7.2, 7.2,1 on SQL, and Sections 8, 8.1, 8.2 on Java.Instructions1. Review the Quick Resources listed at the end of this assignment.Test Scenario and Test Cases2. Section 6, 6.1. You will identify and document one test scenario (name and description) based on the Manage Shopping Cart use case and complete Sections 6 and 6.1 in your design specification. A test scenario is not the same thing as a test case!3. You will create and discuss two test cases for your scenario above for Manage Shopping Cart including test Case Name, Description, Prerequisites, Steps, Input, Expected Result, Actual Result, Status. The steps of the test case must be numbered!Test Scenario: <add your test scenario here for Manage Shopping Cart>Test Case IDTest Case DescriptionTest Case StepsExpected ResultsActual ResultsTest Case StatusTC001<add description?1. <add step><add expected result><add actual result><add status pass/fail>2, <add step>………………TC002<add description?1. <add step><add expected result><add actual result><add status pass/fail>2, <add step>………………3.1 You will create Test Case 1 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.2 of your design specification.3.1.1 You will add a discussion of Test Case 1 to Section 6.2.1 in your design specification.3.2 You will create Test Case 2 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.3 of your design specification.3.2.1 You will add a discussion of Test Case 2 to Section 6.3.1 in your design specification.4. Your entity (persistent) classes will most likely become tables in a relational database. In database design, we would follow normalization and functional decomposition guidelines to normalize our entities (classes) into valid relations. Then we would create SQL (Structured Query Language) statements to create the tables and add constraints. After that, we could populate our tables with data. We will assume our classes are normalized for this exercise.Persistent Class Diagram4.1 Create a persistent UML class diagram (without operations) of persistent data. You already have this from Assignment 2. Make certain that you include ShoppingCart and ShoppingCartItem. Designate primary and foreign keys. Add this to Section 7.1 in your design specification.4.2 Include a discussion of your persistent class diagram in Section 7.1.2 in your design specification.SQL Statements for ShoppingCart and ShoppingCartItem5. You will use two classes (ShoppingCart and ShoppingCartItem) from your persistent UML class diagram and create the SQL statements to implement the tables and constraints. You will need to include primary key and foreign key constraints. Add the SQL Statements to Section 7.2 of your design specification.5.1 Include a discussion of your SQL statements in Section 7.2.1 in your design specification6. Complete Section 7 of your design specification.Java for ShoppingCart and SoppingCartItem7. Create Java statements for ShoppingCart and ShoppingCartItem detailed design classes. Note that ShoppingCart and ShoppingCartItem have a composition type of part whole relationship. See the Engine and Piston example at https://coderanch.com/t/443002/java/Java-Coding-UML-Aggregation-Composition. Add them to Section 8.1 of your design specification and complete Section 8 and 8.2 discussion. You need to map the attributes and methods.
CIS 105 Maricopa Community College Macros & SQL Statement Microsoft Access
Lesson 12: Project DirectionsHands-On ProjectView GlossaryOverviewIn this hands-on project, you will be downloading a data ...
CIS 105 Maricopa Community College Macros & SQL Statement Microsoft Access
Lesson 12: Project DirectionsHands-On ProjectView GlossaryOverviewIn this hands-on project, you will be downloading a database from the Lifetime Media Company, a film and graphics company that does onsite filming and photos. The company uses this database to manage equipment assigned to its employees. You will be completing the following tasks in Microsoft Access:Creating a stand-alone macro Creating an embedded macro.Creating an event-driven data macroCreating a query by writing an SQL statement Project PreparationDownload the Lesson 12_Hands On Project file to your course lesson folder. Extract the file to the same folder.Open the file in Access.Save your file as "Lesson12_Project1_MEID.accdb" where MEID is your MEID.Project DirectionsOpen the Macro Designer and create a stand-alone macro to automatically open the Lifetime Media Equipment table. Select the following arguments:Table Name: Lifetime Media EquipmentView: Datasheet (default)Date Mode: Edit (default)Save the Macro as 'Open Name Objects' where name is your first name (example: Open John's Objects)Right-click the 'Open Name Objects' macro in the database and select Design View. Add an OpenForm action and the following arguments:Form Name: Equipment Checkout FormView: Form(default)Window Mode: Normal (default)Save and close the Macro. Right-click on the Equipment Assignments Report and open in Design View. The Property Sheet should also be on the right of your screen. You will now create a macro to send a reminder to the user upon closing the report to send an email to the auditor each Friday. Select 'On Close' from the Event list. Use the Macro Builder to create an embed macro that will prompt the user to send an Equipment Assignment report to the auditor each Friday by displaying a Message Box. In the Macro Builder, choose Message Box from the Actions drop-down menu.In the Message box type: 'Send Report to Auditor each Friday'.Beep: YesType: InformationTitle: 'Reminder'Save and close the macro. You can test your macro by opening the Equipment Assignments report from the Navigation pane and then closing the report. Open the Lifetime Media Equipment table if not already opened. You will be adding fields to indicate if a lost/damaged item needs to be replaced and a field indicating the replacement amount per item. Add a field titled 'ReplacementRequired' and format the field as Short Text. Add a field titled 'ReplacementAmountPerItem' and format the field as Currency. Save the Table before moving on to the next step.Create an event-driven data macro to calculate a 60% replacement amount when the 'ReplacementRequired' field has a value of "YES". Enter the arguments per the illustration below. If the 'ReplacementRequired' field has a value of "NO" the 'ReplacementAmountPerItem' field will remain empty. Event-Driven Data Macro - Sample FigureIf the 'ReplacementRequired' field = "YES" you will SetField 'ReplacementAmountPerItem' to be equal to 60% of the Per Unit Cost amount. Save and Close the macro. In the Lifetime Media Equipment table enter "YES" for 'ReplacementRequired' for records 2, 8, 9, 24, and 25. Enter "NO" for the rest. In the Lifetime Media Equipment table, add the following 2 records:One DSLR HD Camera for Jones at a per unit cost of $875.00. Replacement will not be required.One Studio HD Camera for Bernard at a per unit cost of $1200.00. Replacement will be required.Note: The replacement amounts are automatically calculated. Save and Close the Lifetime Media Equipment Table. Open a new query in SQL View. Type the following commands:SELECT [Employee Assigned To], [Item Name], [Quantity]FROM [Lifetime Media Equipment]WHERE [Per Unit Cost] >700;Run the query.View your results in Datasheet View.Save the query with the title Items over $700 Close the QueryCompact, repair, and save your database. Submit the assignment based on the instructions provided in the lesson.
Earn money selling
your Study Documents