SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 210 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 22 Dec 2017 My Price 10.00

ACCESS PROBLEM SOLVING PROJECT FOR GOSSETT’S CLASSES

It is Access Problem case, I updated two files, so please use the data file to follow instructions file.

  • ACCESS PROBLEM SOLVING PROJECT FOR GOSSETT’S CLASSES

    The data used in this case has been provided in your Canvas assignment.  Please download this file to begin your work. Page numbers from your textbook have been provided in parentheses.

    Database Creation

    1.       Create a new database namedScholarships.(AC 4-5, OFF 61).Hint:  Make sure you know where you are saving the file so that you know where to find it again.  Be aware files saved on university computers will be erased when you logoff or the computer reboots.

    2.       Import data from an external source, the Excel file provided in the Canvas assignment, as a new table named Students. (AC28-31 In the importing procedure, be sure to select an appropriate primary key.(AC 6)

    Data Analysis

    3.       Create Access Queries(AC 34-38) to answer the following questions.  Name the queries appropriately so that I will know which query answers which question.  For example, Query 1, Query 2…., Query 6.

    1.       Which students were awarded scholarships?  Show me the Student ID, Last Name, First Name and Scholarship Type Awarded.

    2.       How many students received $5000 or more in scholarship funds? Show me the Student ID, Last Name, First Name and Scholarship Amount Awarded.

    3.       Students are required to maintain a GPA of 2.75 throughout their educational career in order to maintain their scholarship for the following years.  Which students will lose their scholarship after the first year of college?  Show me the Student ID, Last Name, First Name, Scholarship Amount Awarded, and 1st Year GPA.

    4.       How many students are majoring in computers? Show me the Student ID, Last Name, First Name and Major.

    5.       What is the average amount of money awarded per scholarship type? Show me the Scholarship Type Awarded and the Scholarship Amount Awarded. Hint:  Can you add a row to the design grid OR use the Query Wizard to help you solve this problem?

    6.       Students are eligible for the Dean’s List if they make a GPA of 3.7 or higher.  Which students are eligible for the Dean’s List after the first year of college? Show me the Student ID, Last Name, First Name and 1st Year GPA.

    Data Reporting

    4.       Create a report (AC 41-47)that shows all scholarships that were awarded, along with who they were awarded to and how much was awarded.  Also, include the degree program and major of the student in this report. Format the report so that each scholarship award is grouped by Program and then Major, and then sorted by Student Name. Name the report appropriately. Format it to display on one page. Use totals for the overall amount awarded and subtotals for the amount awarded per major.

    5.       Create a form (AC 39-41)that will allow University employees to input semester/year GPAs more easily for each student.

    Finishing the project

    6.       Make sure all objects created are saved and named appropriately. Close completely out of your database before trying to upload. Upload your completed file to the appropriate assignment in Canvas.

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 22 Dec 2017 01:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)