I need someone to do this assignment on Microsoft Access?

User Generated

Znexb

Programming

Unformatted Attachment Preview

CSC 121 - USING A COMPUTER SYSTEM I Assignment #10 - Access - Creating and Using a Database 40 Points Due February 19, 2015 at Midnight Terms:     A database is a structured repository for storing data; it is a single file that contains everything needed to define, analyze, manipulate, publish and work with the data. The data itself is stored in tables. A database can have one or more tables. For example, you might have one table for storing employee information, another table for storing client information and other tables for storing information about service vehicles, replacement parts, sales information, etc. Each table can be described as a grid of rows and columns. Each column in a table is a field which contains a specific piece of information about that record (e.g. a name, a salary, a part number). Each row in a table is a record which contains information about one entity (e.g. one employee, one client). Problem: A real estate company located in an ocean resort community provides a rental service for apartment/condo owners. The company rents units by the week to interested tourists and “snowbirds” (people who spend their winters in warmer climates). The database consists of two tables. The Rental Unit table contains information on the units available for rent. Instructions: Perform the following tasks. 1. Create a new database in which to store all the objects related to the rental data. Call the database Resort Rentals. 2. Create the Rental Unit table using the structure in Figure 10a. Use the name Rental Unit for the table. Figure 10a – Structure of Rental Unit Table 3. Add the data shown in Figure 10b to the Rental Unit table. Figure 10b – Data for Rental Unit Table 4. Using the Report Wizard create a Rental Unit report for the Rental Unit table. 5. Select the following fields to appear on the report: Rental ID Address City Weekly Rate 6. Select Next to continue. 7. Select Next to continue. 8. Select Next to continue. 9. Select Next to continue. 10. Change the title of the report to Available Rental Units Report. 11. Select Finish. 12. The report should look similar to Figure 10c Assignment #10 Microsoft Access – Creating and Using a Database 2 Figure 10c – Report for Rental Unit 13. Upload the Resort Rentals database to Bb using the Assignment #10 link. Assignment #10 Microsoft Access – Creating and Using a Database 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags