Exp19_Access_Ch09_Cap – Trading Cards 1.0

Exp19_Access_Ch09_Cap – Trading Cards 1.0

Exp19 Access Ch09 Cap Trading Cards 1.0

Access Chapter 9 Capstone – Trading Cards

EX19_AC_CH09_GRADER_CAP

  

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.

Risk management

 

Write a 250 to 500 word-long discussion post addressing the way risk management affects the way an organization implements an Information Security program. 

APA format is not required for discussion posts, but if you do choose to use external references, you need to format them using the APA format and cite them in your post.

Design Document

A design document consists of various elements including a style guide and navigation structure. Creating the style guide is one of the more creative aspects of a mobile application. As the style guide is created this week, you want to establish the colors and fonts that will be used throughout the mobile application. These design and style choices should directly reflect the purpose of the mobile app and appeal to the target audience. This style guide should help ensure that the visual aspects of the website will be consistent regardless of the page users will be on in the site. Each style guide would consist of a proposed set of color swatches with their hexadecimal color code to ensure that the exact same colors are being used throughout the entire design of the mobile application. The style guide package would also consist of the font specifications that will be used within the app. The fonts should be selected for the buttons, navigation and the text at the minimum. These fonts should be displayed using the actual font and size that you are proposing. The mobile application navigation should provide the information about the navigation process between the various screens. The information that should be created in this visual diagram should be presented in a flowchart. The flowchart should list all the planned main screens and identify how the pages are going to be linked together. Note that some of your screens are universally accessible such as the home screen whereas other screens may only be accessible based on specific criteria. This flowchart will provide a blueprint for the mobile navigation designating how the various screens will be connected.

Software -2

 

Please read chapter 3 of your  textbook and reputable resources and in your own word discuss what is Plan driven Software Development and What is Agile Development.

Discuss at least one application where you will use plan driven development and one application where you will prefer to use agile development.

Computer

 

Write, in your own words, a summary on the Database Design Tips tutorials while incorporating your own experience and understanding. Apply critical thinking and an academic writing style that demonstrates your understanding of the difference between a Microsoft Access database and an Excel spreadsheet by comparing the features of each and when they would be used as personal computer applications if applicable.  Additionally, include basic diagram for a database that includes at least 2 tables and at least 3 fields on each table.

  • Paper Format:
    • Save As ~ CIS101_YourUsername_DatabaseDesign
    • Title Page ~ Course Name, Paper Title, Your Name, Total Word Count, Submission Date
    • Paper ~ APA Style (Information on proper formatting can be found here(Links to an external site.)
    • Reference Page ~ Minimum 2 resources required using proper citation. Just listing an URL address will not count as a citation.
    • If you need help creating acceptable citations please visit https://www.citationmachine.net (Links to an external site.)
    • Minimum 1.5 pages including image, but not including title or reference page

Resources to write your paper can be collected from various Internet sites using Google, and you are welcome to visit the EGCC Library (Links to an external site.) as well. 

Be sure to review the assignment rubric before submitting to ensure you have met all evaluation criteria.

Rubric

Access RubricAccess RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeDatabase Tips35 ptsMeets ExpectationsStudent successfully discusses tips for creating a database using industry appropriate terms18 ptsPartially Meets ExpectationsStudents describes some tips for creating a database but there are some inaccuracies or incorrect terms0 ptsUnacceptableStudent does not discuss tips to design a database35 pts
This criterion is linked to a Learning OutcomeDatabase Design10 ptsMeets ExpectationsIncluded image of database design that meets the minimum required for the assignment5 ptsPartially Meets ExpectationsIncluded image of database design that partially meets the minimum required for the assignment0 ptsUnacceptableStudent does not include an image of a database design10 pts
This criterion is linked to a Learning OutcomeGrammar & Mechanics10 ptsExceeds ExpectationsUses exceptionally clear grammar and written mechanics to completely convey tone and objective8 ptsMeets ExpectationsConveys a clear use of grammar and mechanics, in line with appropriate scholarly standards4 ptsPartially Meets ExpectationsUses basic grammar and written mechanics, but with significant errors or omissions0 ptsUnacceptableDoes not use appropriate grammar and written mechanics10 pts
This criterion is linked to a Learning OutcomeGrammar & Mechanics10 ptsMeets ExpectationsPaper is formatted according to APA standards and free from errors5 ptsPartially Meets ExpectationsPaper is mostly formatted to APA standard but with some errors0 ptsUnacceptablePaper is not formatted to APA specifications and contains significant errors10 pts
Total Points: 65PreviousNext
 

Implement the Java

  

Implement the Java code for the Ticket inheritance hierarchy in IP1. Write a test application that instantiates at least one of each subclass type and prints the contents. Use an overridden toString() method to provide a readable string representation of each subclass instantiated.

 
 

Required: Code is readable with consistent style, contains embedded comments and method headers. Submit your zipped NetBeans project with all files and screenshots demonstrating that your code runs and that you used the debugger to set breakpoints.

Exp19_PowerPoint_Ch03_ML1_Teamwork

Exp19_PowerPoint_Ch03_ML1_Teamwork

  

Project Description:

You are a recruiter for Sperry Consults and have been asked to put together a workshop on teamwork. Your presentation will be used at various events sponsored by the company. You decide to add a chart to show the results of a survey on the benefits of working on a team. You will add a SmartArt graphic to illustrate teamwork skills. Finally, you will create a table that describes the roles of team members.

     

Start PowerPoint. Download and   open the file named Exp19_PPT_Ch03_ML1_Teamwork.pptx.   Grader has automatically added your last name to the beginning of the   filename. 

 

Insert a Clustered Bar chart on   Slide 3.
 

  Replace the spreadsheet data with the following:
Attribute % of   Respondents
Ability   to work in a team 82.9%
Problem-solving   skills 82.9%
Communication   skills (written) 80.3%
Leadership 72.6%
Strong   work ethic 68.4%
 

  Delete the data in columns C and D and resize the data area to include only   data in the range A1:B6.

 

Make the following modifications   to the chart:
  • Apply the Style 3 chart style.
  • Remove the legend, chart title, horizontal axis, and gridlines.
  • Select the vertical axis and change the font size to 16 pt, font color to Black, Text 2,   and apply Bold.
  • Change the data labels font size to 16 pt.

 

Insert a Basic Venn SmartArt   graphic from the Relationship category on Slide 4.
  Type the following list items into the Text pane:
Listening
Questioning
Persuading
Respecting
Helping
Sharing
Participating

 

Make the following changes to   the SmartArt graphic:
  • Apply the SmartArt Intense Effect style.
  • Change the font color text for all shapes to White, Background 1 and apply   Bold.

 

On Slide 6, insert a three   column, nine row table in the content placeholder. In the table, merge the   following:
 Column 1 – Merge the cells in rows 1,   2, and 3.
  Column 1 – Merge the cells in rows 4, 5 and 6
  Column 1 – Merge the cells in rows 7, 8, and 9
 

 

Type the following information   into the table:
  Row 1: Col 1: Action Oriented Roles; Col 2: Shaper; Col 3: Challenges the team to improve
  Row 2: Col 2: Implementer; Col 3: Puts ideas into action
  Row 3: Col 2: Completer/Finisher; Col 3: Ensures thorough, timely completion
  Row 4: Col 1: People Oriented Roles; Col 2: Coordinator; Col 3: Acts as a   chairperson
  Row 5: Col 2: Team Worker; Col 3: Encourages cooperation
  Row 6: Col 2: Resources Investigator; Col 3: Explores   outside opportunities
  Row 7: Col 1: Thought Oriented Roles; Col 2: Plant; Col 3: Presents new   ideas and approaches
  Row 8: Col 2: Monitor/Evaluator; Col 3: Analyzes the options
  Row 9: Col 2: Specialist; Col 3: Provides specialized skills

 

Make the following changes to   the table:
  • Apply the No Style, Table Grid table style.
  • Change the font color for the text in the table to White, Background 1.
  • Center Vertically the text in the table.
  • Apply Dark Blue, Accent 1 shading to the cells in Column 1.

 

On Slide 7 convert the list to a   Grouped List SmartArt graphic. 

 

Apply the Intense Effect   SmartArt style to the SmartArt graphic on Slide 7. Select the text Stage 1:   Forming, Stage 2: Storming, Stage 3: Norming, and Stage 4: Performing and   change the font color to Black, Text 2 and apply Bold.

 

Save and close Exp19_PPT_Ch03_ML1_Teamwork.pptx. Exit   PowerPoint. Submit the file as directed.

Security Controls

Microsoft adheres to a defense-in-depth principle to ensure protection of its cloud services, such as Microsoft Office 365. Built-in security features include threat protection to reduce malware infections, phishing attacks, distributed denial of service (DDoS) attacks, and other types of security threats.Answer the following question(s):

  • Would an organization need to apply security controls to allow safe use of those applications? Why or why not?

Fully address the question(s) in this discussion; provide valid rationale for your choices, where applicable, be sure to include three questions in your thread 

500 words

APA format with references needed.