EX19_AC_COMP_GRADER_CAP_AS – Student Loans 1.0

Project Description:

In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate opening a report.

Start Access. Open the file named Exp19_Access_AppCapstone_CompAssessment_Student Loans.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 import a text file into the database so that you do not have to create   it from scratch.
 

  Create a table in the database by importing the downloaded tab-delimited text   file named Loans_Text.txt. Use the   first row of the file as field names, use ClientID as the primary key, and   then name the table Loans_Text.   Accept all other default options. Do not save the import steps.

Create   a new field in the Colleges table after Phone named Website with the Hyperlink data type. Save the table. In Datasheet view, add the   website www.atlantic.edu to the Atlantic Cape Community College record (Record 1). Close the   table.

Create   a new field in the Clients table after CollegeID named StudentPhoto with the Attachment data type. Save the table. In Datasheet view for   Record 1 (Rabiah Hussein), add the   downloaded picture file named RHussein.jpg   to the StudentPhoto field.

You   will set a rule that will prevent inaccurate data entry in the table.
 

  Set the validation rule on the ExpectedGraduation field to accept the values 2021 or 2022 or 2023 (in that order) only. Set the   validation text to read Please enter 2021,   2022, or 2023. (include the period).

Make   ClientID a lookup field in the   Clients table. Set the lookup to get values from the ClientID field in the Loans_Text   table. Accept all other defaults and save the table. In Datasheet view,   click in any ClientID cell, and click the arrow to view the options. Close the   table.

You   will copy a query and use it as the basis for a new query.
 

  Create a copy of the 2022 Graduates   query. Save the query as Missing Phone.

Set   the criteria in the Phone field to find null values. Delete the criteria of 2022 from the ExpectedGraduation   field. Run the query (two records will display). Save and close the query.

Create   a new query using Design view. From the Clients table, add the ZIP field. Change the query type to Update and set the criteria to update   zip codes of 07003   to 07003-9999. Run the query (two records will   update). Save the query as Zip Code_Update   and close the query. Use the Find command to view the updates in the Clients   table and close the table.

Create   a new query using Design view. From the Clients table, add the FirstName, then LastName fields. From the Loans_Text table, add LoanAmount. Save the query as Large Loans_Make Table.

You   will modify the query so that when run, a new table is created in the   database.
 

  Change the query type to Make Table   and set the criteria to loan amounts that are greater than 25000. Run the query (fours records will be   added). Set the new table name to Large Loans.   Save and close the query. View the changes in the Large Loans table and close the table.

Create   a copy of the 2022 Graduates   query. Save the query as Graduates_Parameter.

You   will modify the query to prompt the user for input.
 

  Set the criteria in the ExpectedGraduation field to display the prompt as Enter the graduation year: and run the query. In the prompt,   enter 2022 and click OK to view the results (16 records). Save and close the query.

Create   a Navigation form based on the Vertical Tabs, Left template. Drag and drop   the Client Information form onto   the first tab of the form. Drop the Clients   Report by Year onto the second tab. View the form in Form view, click   each of the tabs, and then save the form as Navigator.   Close the form.

You will use an SQL statement to   display specific records in a report.
 

  Open the Clients Report by Year report   in Design view. Modify the record source of the report using an SQL statement   to select only client records with an ExpectedGraduation   of 2022. (Hint:   copy and modify the existing SQL code). Print Preview the report (sixteen   records will display). Save and close the report.

You   will add a button to a form that will open a report when clicked.
 

  Open the Client Information form   in Design view, and click to add a command button at the intersection of the   6-inch mark on the horizontal ruler and the 3-inch mark on the vertical ruler.

Set   the command button to open the report named Clients Report by Year. Use the default picture as the button.   Set the name and the caption properties of the button to Open Client Report. Save the form. View the form in Form   view, scroll down if necessary, and click the command button.

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

Exp19_Access_Ch07_Cap – Replacement Parts 1.0

Exp19 Access Ch07 Cap Replacement Parts 1.0

Access Chapter 7 Capstone – Replacement Parts

EX19_AC_CH07_GRADER_CAP

Start Access. Open the file named Exp19_Access_Ch07_Cap_Replacement_Parts.accdb. Grader has automatically added   your last name to the beginning of the filename.

You’ll   begin by creating a basic form based on the Employees table.
 

  Select the Employees table and use the Form tool to create a new form. Change   the title to View Employees.   Delete the Orders subform.

It   is important for the staff to only be able to view the form and not make any   edits to the data provided in the form.
 

  Change the Allow Edits, Allow Additions, and Allow Deletions  settings to No.   View the form and data in Form view. Save the form as View Employees. Close the form.

For   those staff members that are permitted to edit employee data,  it is important   to control for the risk of human error. In this case,  we are concerned with   the Country field related to each employee. You  will create a table and enter   only the countries you would like your  staff to choose from into it.
 

  Create a new table in table design view. Name the first field Country and ensure the field is set as the   primary key. Switch to Datasheet view, saving the table as Countries. Enter two records, UK and USA   (in that order). Close the table.

Now,   you’ll update the Update Employees form so that the countries  that your staff   can choose from will be limited to those countries  that exist in your newly   created table.
 

  Open the Update Employees form in Design view. Change the Country  field to a   Combo Box. Set the Row Source to Countries and the Limit To  List property to   Yes.

You   will need to ensure that the tab order makes sense in the  Update Employees   form. This makes it easier for your staff to  use/navigate.
 

  Fix the tab order so the Postal Code field comes immediately before the   Country field. Save and close the form.

Adding   specific policies and/or procedures to various forms is one  of the best ways   to ensure that your staff sees then on a regular  basis and understands them.   You’ll add a note on the View Employees  form stating that the viewable data   is considered private and should  be handled with caution.
 

  Open the View Employees form in Design view. Add a new label  control in the   left-side of the form footer that displays the text Personnel information is considered private and printouts should   be shredded after use (do not include a period). Change the   font color to Black, Text 1 and bold the text. Save and close the form.

Summary   reports are great for providing company executives with  quick information.   You will create a report that lists the important  employee information to   your executives.
 

  Create a new report using the Report Wizard based on the Employees  table.   Select the FirstName, LastName, HireDate, and HomePhone fields,  in that   order. Accept all other default options.

Your   executives have asked to summarize the employee information by  who each   employee reports to. As such, you’ll add a grouping by the  ReportsTo field to   the report. You’ll also add a count to the footer  section of each group that   counts the number of employees that report  to each supervisor.
 

  Switch to Layout view. Add grouping by the ReportsTo field. Switch  to Design   view. Switch the option to with a footer section in the  Group, Sort, and   Total pane Use the pane to also display the count of  the First Name field in   the Group Footer section.

The   executives that each group of employees appears on a different  page. You’ll   add a page break in the footer section of each group.
 

  Add an Insert Page Break control at the bottom of the ReportsTo  footer. Decrease   the size of the Home Phone field label, by dragging  the right border so it   lines up with the 6-inch mark on the horizontal  ruler. Ensure that the label   width is set to as close to 1.08 inches  as possible. 

Finally,   you’ll need to calculate the number of years each employee  has been at the   company. Adding a text box to the report will allow  you to do so.
 

  Add a new Text Box control to the right of the HomePhone text box.  Use the   Tabular button in the Table group of the Arrange tab to place  it correctly.   Change the label for the field to Years Employed.

Add   a formula in the text box to calculate the number of years (not  days) since   the employee’s hire date, assuming the current date   is #12/31/2018#. Format the field as Standard with 1   decimal place. Save and close the report.

Close   the database, and submit the file as instructed.

Project Description:

The Human Resources Department asked you to assist them in updating  the database they are using. The department requires a form that can be  used to find information but not change information. In addition, you  will enhance an existing form and generate a report showing which  employees report to each supervisor.

Start Access. Open the file named Exp19_Access_Ch07_Cap_Replacement_Parts.accdb. Grader has automatically added   your last name to the beginning of the filename.

You’ll   begin by creating a basic form based on the Employees table.
 

  Select the Employees table and use the Form tool to create a new form. Change   the title to View Employees.   Delete the Orders subform.

It   is important for the staff to only be able to view the form and not make any   edits to the data provided in the form.
 

  Change the Allow Edits, Allow Additions, and Allow Deletions  settings to No.   View the form and data in Form view. Save the form as View Employees. Close the form.

For   those staff members that are permitted to edit employee data,  it is important   to control for the risk of human error. In this case,  we are concerned with   the Country field related to each employee. You  will create a table and enter   only the countries you would like your  staff to choose from into it.
 

  Create a new table in table design view. Name the first field Country and ensure the field is set as the   primary key. Switch to Datasheet view, saving the table as Countries. Enter two records, UK and USA   (in that order). Close the table.

Now,   you’ll update the Update Employees form so that the countries  that your staff   can choose from will be limited to those countries  that exist in your newly   created table.
 

  Open the Update Employees form in Design view. Change the Country  field to a   Combo Box. Set the Row Source to Countries and the Limit To  List property to   Yes.

You   will need to ensure that the tab order makes sense in the  Update Employees   form. This makes it easier for your staff to  use/navigate.
 

  Fix the tab order so the Postal Code field comes immediately before the   Country field. Save and close the form.

Adding   specific policies and/or procedures to various forms is one  of the best ways   to ensure that your staff sees then on a regular  basis and understands them.   You’ll add a note on the View Employees  form stating that the viewable data   is considered private and should  be handled with caution.
 

  Open the View Employees form in Design view. Add a new label  control in the   left-side of the form footer that displays the text Personnel information is considered private and printouts should   be shredded after use (do not include a period). Change the   font color to Black, Text 1 and bold the text. Save and close the form.

Summary   reports are great for providing company executives with  quick information.   You will create a report that lists the important  employee information to   your executives.
 

  Create a new report using the Report Wizard based on the Employees  table.   Select the FirstName, LastName, HireDate, and HomePhone fields,  in that   order. Accept all other default options.

Your   executives have asked to summarize the employee information by  who each   employee reports to. As such, you’ll add a grouping by the  ReportsTo field to   the report. You’ll also add a count to the footer  section of each group that   counts the number of employees that report  to each supervisor.
 

  Switch to Layout view. Add grouping by the ReportsTo field. Switch  to Design   view. Switch the option to with a footer section in the  Group, Sort, and   Total pane Use the pane to also display the count of  the First Name field in   the Group Footer section.

The   executives that each group of employees appears on a different  page. You’ll   add a page break in the footer section of each group.
 

  Add an Insert Page Break control at the bottom of the ReportsTo  footer. Decrease   the size of the Home Phone field label, by dragging  the right border so it   lines up with the 6-inch mark on the horizontal  ruler. Ensure that the label   width is set to as close to 1.08 inches  as possible. 

Finally,   you’ll need to calculate the number of years each employee  has been at the   company. Adding a text box to the report will allow  you to do so.
 

  Add a new Text Box control to the right of the HomePhone text box.  Use the   Tabular button in the Table group of the Arrange tab to place  it correctly.   Change the label for the field to Years Employed.

Add   a formula in the text box to calculate the number of years (not  days) since   the employee’s hire date, assuming the current date   is #12/31/2018#. Format the field as Standard with 1   decimal place. Save and close the report.

Close   the database, and submit the file as instructed.

 Your PowerPoint should contain 10-15 slides. You can use Microsoft Teams to record the audio narration of your PowerPoint presentation (preferred). You can then share the Microsoft Teams recording link with your teammates, instructor, and the entire class in the week 8 discussion. You could also add this Microsoft Teams recording link to your resume as a portfolio item.Please cover the following topics in this presentation:

• The CTF category
• Problem solved
• Steps used to solve
• The solution
• Strategies, pitfalls, lessons learned
• Workplace relevance

Exp19_Access_Ch4_Cap – Farm Conference 1.0

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

Create   a form using the Form tool based on the Presenters table. Change the title in   the Form Header to Enter/Edit Presenters.

Reduce   the field value control widths to approximately half their original size (to   approximately 3.6″). Delete   the subform.

Sort   the records by LastName in   ascending order. Save the form as Edit Presenters.   Close the form.

Open   the Location Information form in Layout view. Apply the Stacked Layout   control to the form. Save and close the form.

Create   a new report based on the Exhibits   with Presenters query using the Report Wizard. Select all available   fields, choose to view the data by Presenters, ensure that FirstName,   LastName is the only grouping level, use Date as the primary sort field in   ascending order, accept the default Stepped option, and change the layout to Landscape. Save the report as Presenter Schedule.

Apply   the Integral theme to this report only. Save the report.

Modify   the Presenter Schedule report so that the StartingTime field from the Exhibits table is added as the last   field (appearing to the right of LocationID). In Design view, ensure that the   left edge of the field is at the 8.5-inch mark on the ruler, and then return   to Layout view.

Change   the title of the Presenter Schedule report to Schedule by   Presenter.

Change   the sort so the StartingTime is a   secondary sort field (that is, so that the first sort is Date, and the second   sort is StartingTime). Save and close the report.

Create a new labels report based on the Presenters table. Use the Avery USA 8660   label template. Accept the default font options, and set the labels up so the first and last name appear on the top line, the Address on the second line,   and the City, State, and ZipCode appear on the final line. Your first label   should look like this:
 

Shannon Beck
368 Graham Avenue
Graham, KY 42344
 

  Do not add any sorting. Name the report Presenter Mailing   Labels.   Close the labels.

Chapter. 5 Estimating Project Times and Costs

Chapter. 6 Developing a Project Plan

Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.

Also, provide a graduate-level response to each of the following questions:

1. Why is it difficult to estimate mega project (i.e., costs and benefits (i.e. airports, stadiums, etc.) costs and benefits?
2. Define what a “white elephant” is in project management? Provide a real life example.
3. Why bother creating a WBS? Why not go straight to a project network and forget the WBS?

Text-

Title: Project Management: The Managerial Process 

ISBN: 9781260238860 

Authors: Clifford F. Gray, Erik W. Larson 

Publisher: McGraw-Hill Education 

Publication Date: 2020-01-09

Topic:  Combined Wireless Network Intrusion Detection Model Based on Deep Learning 

Instructions:

The term paper it should be of professional quality and be in the format of an IEEE transaction style. 

Figures must be clear and drawn by you. 

Proper citation of references must be embedded in the term paper. All term report should be printed in 8.5x11in format, 10 size, time new roman font, two-column, about 8 pages, left, right, top, bottom margin 1 inch, and contain the following:

1. Title page.

2. Abstract (summary of the paper).

3. Introduction (problem motivation, background materials, related work, summary of objectives and methods).

4. (i) Description of existing algorithms/protocols for survey papers; 

   (ii) system model, assumptions, and/or formal problem formulation for research-oriented papers.

5. (i)   Comparison   among   existing   algorithms/protocols   and   discussion   on   possible improvements/enhancements; 

  (ii) project results (derivation, proof, justification, or detailed

design/simulation) in one or more numbered sections for research-oriented papers.

6. Conclusions (evaluation of results, suggestions for improvements, or future work).

7. References must follow IEEE Transactions format (at least 10 references). Proper citation of

references must be embedded in the term paper.

8) please have some diagrams as well…

One of the example is attached for reference….

Assignment Content

1. All projects begin by answering one of two questions:
   • How can I make business scenario ABC better or more efficient?
   • What business scenario can I automate to benefit organization XYZ?
   • For this assignment, select a business scenario you would like to develop into a project over the next five weeks. You have two options:
   • You may select one of the two business scenarios described in Select a Business Scenario.
   • You may select a business scenario of your choosing. This can be a scenario from your workplace; for example, a frustrating process you have been eager to rework or a potential process you have been thinking of that does not exist yet but that you think would be valuable to your organization if it were developed into an IT project.
   • Note: If you decide to select a business scenario of your choosing, you must obtain approval from your instructor for your scenario before beginning the project proposal assignment, which is also due this week.

     Download Select a Business Scenario and read through the options.

     You can to do the following:
     1) Download the Select a Business Scenario document and read through the options
     2) Do not delete any of the options or anything at all from the downloaded document
     3) Type your selection (Scenario A, Scenario B, or Scenario C) directly into the Select a Business Scenario document (on the space provided next to each scenario) . Please see the example PDF document below.
     4) Save and then submit the document
     Select a Business Scenario Example screenshot.pdf
      

Agile Methodology

Overview

In this assignment you focus on the process methodology of Section 5, Standards and Procedures of your software development plan (SDP)—choosing, diagramming, explaining and finally applying your choice of Agile development methodology to CapraTek. The choices that you make here drive the rest of the SDP, so it is an appropriate starting point.

Preparation

Use the assignment Resources to complete the following:

• View the CapraTek scenario in the CapraTek Overview document.
• Download the Software Development Plan Template. Save it as “CapraTek_SDP_u1” and use it to complete and submit your assignments for this course.

Directions 

Consider the CapraTek scenario and address the items below in Section 5 of the CapraTek SDP document.

• Select an Agile methodology and briefly justify why your chosen Agile methodology is appropriate for CapraTek.
• Create a Unified Modeling Language (UML) activity diagram that illustrates the process methodology life cycle.
• Describe each of the phases depicted in the process methodology diagram with relation to the software development process. Keep your descriptions generic—the point is to explain the processes involved in each phase to illustrate the concept.
  • Partial Example: Scrum initial requirements steps: “During the initial requirements steps, the product owner examines the product backlog and gets feedback from the customer and other stakeholders. The product owner then informs the development team of the items from the product backlog . . .”
• Select two of the phases and describe how each would manifest itself in the context of CapraTek. Consider CapraTek’s requirements, resources, time constraints, et cetera. 

Save and submit your SDP.

 3.44 What is a referential integrity constraint? Define the term, and give an example of its use. Are null values allowed in foreign key columns with a referential integrity constraint? How does the referential integrity constraint contribute to database integrity? 

3.45 Explain the role of referential integrity constraints in normalization. 

3.46 Do relations StudID_SocialSecurityNumber and SocialSecurityNumber_StudName contain a transitive dependency? 

3.47 In normalization example 3, why is the EXTENDED_PRICE relation “silly”? 

3.48 In normalization example 4, under what conditions is the functional dependency (StudentID, Activity) S ActivityFee more accurate than Activity S ActivityFee 

3.49 If a determinant is part of a candidate key, is that good enough for BCNF? 

 3.50 In normalization example 5, why are the following two tables not correct? DEPARTMENT (Department, DeptBudgetCode, Buyer) SKU_DATA_4 (SKU, SKU_Description, Department) 

3.51 How does a multivalued dependency differ from a functional dependency? 

3.52 Consider the relation: PERSON (Name, Sibling, ShoeSize) Assume that the following functional dependencies exist: Name S S Sibling Name S ShoeSize Describe deletion, modification, and insertion anomalies for this relation. 

3.53 Why is BCNF referred to as the best of the forms? 

3.54 Consider the relation: PERSON_2 (Name, Sibling, ShoeSize, Hobby) Assume that the following functional dependencies exist: Name S S Sibling Name S ShoeSize Name S S Hobby Describe deletion, modification, and insertion anomalies for this relation. 

3.55 What must we know in order to find functional dependencies in a table? 

3.56 What is a multivalued dependency? 

3.57 How do the conditions for DK/NF correspond to the conditions for BCNF 

Please review the Todo Project document and write a project based on the requirement. Also, please check the Criteria doc for points.