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

The role and functions of law eth 321 - 5 examples of mise en place - What is the best online movie rental service - Disadvantages of ozone disinfection - Hospital management case study pdf - Baulkham hills bc post office - Continuous improvement process in aged care - Famousoneday op gg - Practice test questions classical and operant conditioning - In the 1830s paris was - Performance patterns occupational therapy - Voice projection exercises worksheets - The darkest hour by caroline tung richmond chapter summaries - Benefits of a computerised accounting system - Module 7 past year question and answer - Dissent from secondary use of patient identifiable data - Statistics - Advanced research projects agency network - EP WK9 - Product Development - Fundamentals of nursing final exam - Power point presentation - What is standardisation in titration - Integral DX - Week 7 - Why our campuses are not safer without concealed handguns essay - Whitbread world sailboat race case study - Danny carey isolated drums - Datamatics business solutions work from home - Cathedral ranges wells cave - Peer response - Commedia dell arte acting style - Courage in shawshank redemption - The marketing department of graber corporation has submitted - Torque values for metric bolts - Quiz - Mechanics of materials 9th edition solution manual free pdf - Etymology of my name - Adapting product labels for international markets - Effective leadership and management in nursing sullivan pdf - Can i import cosmetics to malaysia - Assignment - National geographic taboo food - The girl who can ama ata aidoo theme - Webtext answers - Organizational Code of Ethics - Healthcare Finance - Interlux brushing liquid 333 substitute - Literary analysis happy endings by margaret atwood - Which of the following is not a function of bone - 1/7 thomas street brighton east - Marketing ethics product safety and pricing - How to calculate age in python - How to standardize an argument - One assignment due tomorrow before 11:59 pm - Pex pipe chlorine resistance - An example of a formal letter - Bmj simulation & technology enhanced learning impact factor - 750 words: Select an organization that has a Global platform and describe the following. - Discussion - Tata motors case study analysis - Bible dictionary project old testament - Role of computer in accounting ppt - Shaping and chaining reinforcement schedules and one trial learning - Amenable research topic to scientific study in qualitative approach - Refer to the lincolnville school district bus data - A six column table for jkl company follows - Lead nitrate and potassium iodide lab report - Is geh4 polar or nonpolar - Swot - Database project proposal example - Writer federico garcia crossword clue - Week 8 HUM101: World Religion and Cultures - Statdisk download - Managerial economics and business strategy 8e - 65 turpentine street wyoming - What is the main idea of the book charlotte's web - Aka letter of interest format - Bluebeam text box border - Corsham computer centre ufo - Enzymatic browning of apples experiment - Charity - Bf skinner 1904 1990 - Lucky lumen light bulbs have - How does multitasking confuse the resource availability of project team personnel? - Paul kelly everything's turning to white - Editing challenge 2 business communication - Asthenosphere temperature in celsius - What does trini salgado mean in spanish - Tom sawyer discussion questions - Educational prenuptials to consider before co teaching - Name three specific consequences of the boston busing crisis - Cherry willingham cricket club - Software interfaces in srs example - Distracted Driver Project proposal - Butl_ Learnign Feamework - Essay - Chemistry in context answers aquatherm pipe and fittings - Radio clyde ssb rewind - Maximum sustainable yield forestry