Solved Questions

Solutions
Question
1
solution
Category: Computer Science
In this assignment, you will inspect the data in the database and answer a few questions along the way. Task 1 How many records are in each of the four tables of the database? Which table has the highest record count? While there are a few ways to answer such questions, you should use queries to create repeatable tasks that can be used to generate ...
1
solution
Category: Computer Science
ASSIGNMENT 1: CREATING SPREADSHEET MODELS FOR DECISION SUPPORT In this assignment, you will create spreadsheets that model the business decision Rose Tree Regional Airline is seeking. In Assignment 1A, you will create a spreadsheet and attempt to assign the planes manually to minimize the total operating cost. In Assignment 1B, you will copy the sp...
1
solution
Category: Computer Science
Query 1 The development director wants to know which donors gave $500 or more in each of the past two years. A letter of appreciation will be sent to these generous people. Create a query named Generous Donors that lists the donors and the amounts they gave in both years. The first few records of your output should look like those in Figure 10-7. N...
1
solution
Category: Computer Science
ASSIGNMENT 2: CREATING THE DATABASE, FORMS, QUERIES, AND REPORT In this assignment, you first create database tables in Access and populate them with data. Next, you create a form and subforms, five queries, and a report. You will create a form and subforms, five queries, and one report, as outlined in the Background section of this case. Query 2 Y...
1
solution
Category: Computer Science
Complete the case by (1) using the spreadsheet to gather data about possible financial scenarios and (2) documenting your findings in a memo. Snow Top managers would like you to explore two sets of three scenarios. They request that the first set not include any summer expansion. The input values for these scenarios are as follows: Optimistic—The n...