Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Access grader project chapter 3

29/10/2021 Client: muhammad11 Deadline: 2 Day

Office 2013 – myitlab:grader – Instructions Exploring - Access Chapter 3: Assessment Project 1

Retirement Accounts

Project Description: One-Stop Finance is a company that works with Clients in all areas of finance. They assist with banking, financial planning, mortgages, stock, insurance, retirement counseling, and debt consolidation. Cala Hamieh, one of the senior planners for the company, is hoping to extract information from the database. The company has a large database with hundreds of thousands of accounts, but to allow you to rapidly test your queries, you have created a smaller version of the database with a small amount of clients. Once you are confident your queries work, you can import them in to the main Access database.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named exploring_a03_Grader_a1. 0 2 Create a query using Query Design. From the Clients table, display the client’s first and last name. From the Accounts table, select the savings balance and account open date. Sort the query by savings balance in descending order. 5 3 Add a calculated field named AccountTime that calculates the number of days each client’s accounts have been open. Assume today’s date is 12/31/2017. Recall dates must be enclosed in # to denote to Access it is a date. Format the results in General Number format. Save the query as Account Longevity, and close the query. 10 4 Create a query using Query Design. From the Clients table, display the client first name and last name. From the Accounts table, select the savings balance. 10 5 Add appropriate grouping so the client’s total retirement account savings balances are displayed. Add a sort so the highest total savings balances are displayed first. 10 6 Switch to Datasheet view. Add a totals row displaying the count of the clients and the average of total savings balances. Save the query as Total Balances By Client, and close the query. 10 7 Create a copy of the Total Balances By Client query. Name the query Total Balances By State. Open the query in Design view and remove the client name from the query. Add grouping by the client’s state. 10 8 Sort by the client’s state in Ascending order. Add criteria so clients with retirement account savings balances of $10,000 or more are factored in to the query. Save and close the query. 10 9 Create a new query using Query Design. From the Clients table, select the client first name, last name, and state. From the Accounts table, select the Savings Balance. Add criteria so only customers with balances under $15,000 are displayed. 10 10 Add a new field named LoanPayment using the Expression Builder. Insert the PMT function to determine the monthly payment for a 2-year loan, paid monthly, with a 5% yearly interest rate. The present value is 25000 minus the savings balance. For example, if the purchase price were 25000, with 5000 in savings to put toward the purchase, your present value would be 20000. Ensure the number displays as a positive number. 15 11 Change the format of the LoanPayment field to Currency. Change the caption to Loan Payment. Save the query as Monthly Loan Payments and close the query. 10 12 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0 Total Points 100

Updated: 04/15/2013 2 A_CH03_EXPV1_A1_Instructions.docx

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Custom Coursework Service
Assignments Hut
University Coursework Help
Financial Analyst
Assignment Guru
Accounting & Finance Specialist
Writer Writer Name Offer Chat
Custom Coursework Service

ONLINE

Custom Coursework Service

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$21 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$31 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$16 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$19 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$36 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$36 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Cattell's phd was earned with - CC W 2 D - Racv home security system - West coast cooler dan murphys - Einstein's big idea worksheet - What is the current model of our solar system - 23013 devonshire ln frankfort il 60423 - Model ecosystems virtual lab journal answers - The examination of sarah good - Jpmorgan chase swot analysis summary - Complete penetration weld symbol - Ideal diode bridge controller - Du4 - ERP - Determining forces in truss members - Tma moodle - Using currents to sail around the world - Page Design - Bastion 20kg concrete mix - Square root of 1/8 - The case of anna o - Chick fil a goals and objectives - Brand Personality Presentation - Case analysis - Pi notation in matlab - Uni - The prefix in the word trigeminal means - Business Intelligence and Analytics (Exercise) - What is the difference between ignorance and apathy worksheet - Nestle case study managing organizational change - Blank map of egypt to label - Kol balish english meaning - Group 16 period 3 - Answers to pbi interview questions - Module3 discussion - Wendell berry the pleasures of eating summary - Discussion Question Assignment - Roach v electoral comission - Lactate threshold vs obla - Data analysis - Risk and Resilience Value Article - Chemalite case study income statement - Samsung robot vacuum error code c05 - Organizational design of coca cola - Arrowmark vending - What are the fennec foxes predators - Explain why disorders caused by dominant alleles on - Btec qcf grade calculator - Thermo scientific material safety data sheet - Components of discrete event simulation - Lossing barrett - Agriculture persuasive speech topics - The great vowel shift - Week 2: picot/pico and practice questions - How many inventory accounts does a manufacturer have - Bsc subjects part 1 - Neisser 1967 cognitive psychology - Experiment 1 determining the chemical formula for copper gluconate - Indian statistical institute six sigma green belt mumbai - Industrial Supremacy Assignment - Mg/l to ppm water - Reread this sentence from the letter from birmingham jail - 0.2 fte how many hours - Unit 6 Discussion - Domestic building contracts act 1995 pdf - Percentage of acetic acid in vinegar lab answers - Bryant and stratton self service banner - Precision circuits power control system - Water in the lake behind hoover dam is - A3 a4 a5 paper size - Winmend folder hidden password hack - Which of the following are not true in reference to converting a basic disk to a dynamic disk? - Due Sunday by 1 pm - Disadvantages of internal fertilisation - Cambs fire service jobs - Arctic habitat shoebox project - Eyeglassomatic manufactures eyeglasses for different retailers - Best Finance Assignment Help in USA - 2 page writing - X culture readiness test answers - Course Project Week 4 Outline - Dean woodcock neuropsychological battery dwnb houghton mifflin harcourt - ARTIFICIAL INTELLIGENCE - LIGHTING THE WAY AT THE MANOR HOUSE HOTEL - History of clothing in india ppt - Penn foster biology research paper example - NS-10-D - Keith rn case study answers pdf - Swinburne online teaching periods 2021 - Stimulus for narrative writing - One night the moon essay - Animal farm chapter 9 summary - What is an allusion - The planning process phl 320 - Sample customer service charter - Change management simulation power and influence scenario 1 - Zappos case study pdf - Derivative classification course exam answers - Discussion A: Exploring Your Own Styles of Communication - Tuesdays at the castle discussion questions