PGCC Data Communications and Computer Networks Planner Program

User Generated

nqronawvbqrlrzv

Business Finance

Prince Georges Community College

Description

YO19_Access_Ch01_PS1 - Planner 1.1

Project Description:

Beth Rakes runs an event planning service. She is moving toward using Access to manage her business more effectively. In one database, she tracks clients, events, and menus that each client has booked. In another database, she has many decorations reserved for events. She has hired you to consolidate the databases and make some additional changes that will improve the database's functionality.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded file named Access_CH01_PS1 - Planner.accdb Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

Import the tblEventItem and tblDecoration tables from the Access_CH01_PS1 - PlanItems.accdb Access database.

10

3

Open tblClients. In record 8, change Colorado Rojas's street address to 528 Oak Avenue. Close the table.

5

4

Create a form to enter decorations into the tblDecoration table, naming the form frmDecorations.

10

5

Change the title of the form to Decorations.

10

6

Enter the following products as new records. Notice that you do not have to enter the DecorID or the Extended Price because Access automatically fills them in:

DecorItem

Color

Category

Quantity

Price

Balloons

Blue

Miscellaneous

15

2.50

Balloons

Red

Miscellaneous

18

1.50


Close the form.

10

7

Create a query for Beth to use to retrieve information on all the different balloon decorations available for events. Use the Query Wizard to create a query listing DecorID, DecorItem, Color, Quantity, and Price from tblDecoration. Save your query as qryRoses. In Design view, type Roses in the Criteria row for the DecorItem field. Run the query to observe the results. Save and close the query.

10

8

Create a query that will return the various types of sit down meals offered for events. Using the Query Wizard, create a query that selects MenuType, CostPerPerson, and ServiceType from tblMenuChoice. Save your query as qrySitDownMeals.

10

9

In Design view, type Sit Down in the Criteria row for the ServiceType field. Sort the results by CostPerPerson in ascending order. Run the query to observe the results. Save and close the query.

10

10

Create a report showing EventDate, EventName, StartTime, EndTime, Location, and TotalAttendees from tblEvents. Do not add any grouping levels. Sort by EventDate and then EventName in ascending order. Change to Landscape orientation. Name your report rptEvents.

15

11

View the report in Layout view. Modify the report title to be Event Report. Save and close the report.

10

12

Save and close Access_CH01_PS1 - Planner.accdb. Exit Access. Submit your files as directed.

0

Total Points

100

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

I got to my work and the first I finished ...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags