Access CH5 project help

The problems are linked in the word doc and will walk you through exactly what needs to be done on the access project.
pack_a03ch05_grader_h1_events.zip

yo16_ac_ch05_grader_ps1_hw_instructions.docx

Don't use plagiarized sources. Get Your Custom Essay on
Access CH5 project help
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 5 Problem Solve 1
YO16_AC_CH05_GRADER_PS1_HW – Event Planning at the Red Bluff
Golf Course & Pro Shop
Project Description:
From weddings to conferences, the resort is a popular destination. The resort has several facilities that can
accommodate groups from 30 to 600 people. Packages and prices vary by size of group, room, and other
services, such as catering. The Event Planning & Catering team works closely with clients to ensure the clients
have everything they need for their event. The resort stocks several choices of decorations, table arrangements,
and centerpieces. These include professional, simple, themed, and luxurious.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
Instructions
Start Access. Open the downloaded Access file named a03ch05_grader_h1_Events.accdb.
Save the file with the name a03ch05_grader_h1_Events_LastFirst using your last and
first name. If necessary, enable the content.
Points
Possible
0
Create a new table with the following attributes:
Field Name
EventItemID
EventID
ClientID
DecorID
Theme
Data Type
AutoNumber
Number
Number
Number
Short Text
Add the following descriptions for each of the fields:
2
EventItemID: Surrogate key for each selected item (primary key)
15
EventID: This is the scheduled event
ClientID: Client ID (foreign key) from the tblClient table
DecorID: What the client wants to have at the event
Theme: Can be professional, simple, themed, or luxurious
Save the new table as tblEventItems.
Create the following field properties in the tblEventItems table.
EventItemID field:
• Under Field Properties, add the following custom format: “ITEM”0.
• Ensure that the New Values field property is set to Increment.
3
EventID field:
• Create a lookup field by changing the data type to Lookup Wizard. Select your data from the
existing tblEvents table, and then click Next. Select EventID, EventName, and EventDate. Click
Next. Sort in Descending order by EventDate. Click Next. Hide the Key Column. Click Next two
times. Click Enable Data Integrity, and then click Restrict Delete. Click Finish. Save the table
when prompted.
• Under Field Properties, enter Event as the caption.
• Under Field Properties, change the Required property to Yes.
Updated: 09/26/2016
1
15
YO16_AC_CH05_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 5 Problem Solve 1
Step
Points
Possible
Instructions
Continue creating the following field properties in the tblEventItems table.
4
ClientID field:
• Create a lookup field by changing the data type to Lookup Wizard. Select your data from the
existing tblClients table, and then click Next. Select ClientID, LastName, and FirstName. Click
Next. Sort in Ascending order by LastName and FirstName. Click Next. Keep the Key Column
hidden. Click Next. Click Enable Data Integrity, and then click Restrict Delete. Click Finish.
Save the table when prompted.
• Under Field Properties, type Client as the caption.
• Under Field Properties, change the Required property to Yes.
15
DecorID field:
• Create a lookup field by changing the data type to Lookup Wizard. Select your data from the
existing tblDecorations table, and then click Next. Select DecorID, DecorItem, and Color. Click
Next. Sort in Ascending order by DecorItem and Color. Click Next. Keep the Key Column
hidden. Click Next. Click Enable Data Integrity. Click Finish. Save the table when prompted.
• Under Field Properties, enter Item as the caption.
• Under Field Properties, change the Required property to Yes.
Continue creating the following field properties in the tblEventItems table.
5
6
7
8
Theme field:
Create a lookup field by changing the data type to Lookup Wizard.
Click I will type in the values that I want. Click Next. Enter the
following options.
Row 1: Professional
Row 2: Simple
Row 3: Themed
Row 4: Luxurious
Click Next, click Limit to List, and then click Finish. Under Field
Properties, change the Field Size property to 12.
Save your changes, and then switch to Datasheet view. Add the following records to test the
field properties in your new table.
Event
Wedding Reception 11/23/2018
Luxurious
Wedding Reception 11/23/2018
Luxurious
Wedding Reception 11/23/2018
Luxurious
Wedding Reception 11/23/2018
Luxurious
Client
Bennett
Item
Tablecloth White
Theme
Bennett
Napkins White
Bennett
Candles with Flowers Silver
Bennett
Fountain (large)
Close the tblEventItems table.
Open the tblEvents table in Datasheet view to create a query from a filter.
• Click the Location field, and then, on the Home tab, in the Sort & Filter group, click Selection.
• Select all events being held in the Eldorado Room. Save this filter as a query named
qryEldoradoRoom by using the Save Object As option.
• Close qryEldoradoRoom.
On the Home tab, in the Sort & Filter group, click Advanced, click Clear All Filters,
and then click Advanced.
• Select Advanced Filter/Sort. The tblEventsFilter1 pane opens.
• Select the following fields, and then enter the following criteria in the tblEventsFilter1 grid.
Field
1
2
Updated: 09/26/2016
Field Name
EventName
EventDate
11
11
11
11
Criteria
2
YO16_AC_CH05_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 5 Problem Solve 1
Step
3
4
9
10
Points
Possible
Instructions
StartTime
EndTime
>5pm
• On the Home tab, in the Sort & Filter group, click Toggle Filter. Notice that the results of the
Advanced Filter are now displayed in the tblEvents table.
• Save this filter as a query named qryEveningEvents by using the Save Object As option.
• Close qryEveningEvents.
• Close tblEvents and tblEventsFilter1. Do not save the changes when prompted.
On the Database Tools tab, in the Analyze group, click Analyze Table. The Table
Analyzer Wizard opens to the first introduction screen.
• Click Next two times, and then select tblEvents if necessary.
• Click Next, and then click Yes, let the wizard decide.
• Click Next. Access will create three new tables: Table1, Table2, and Table3.
• Double-click the current table names, and rename them as follows.
Table1: tblEventData
Table2: tblEventName
Table3: tblEventLocation
• Click Next two times. Access asks whether you want to create a query that resembles your
old table. Because your old table will be saved automatically, you will not need a query with
the same data. Click No, don’t create the query.
• Click Finish. All three tables you just created will open. Close the tblEventData,
tblEventName, and tblEventLocation tables. Click Yes if Access prompts you to save any
changes.
Exit Access, and then submit your file as directed by your instructor.
0
Total Points
Updated: 09/26/2016
3
11
100
YO16_AC_CH05_GRADER_PS1_HW_Instructions.docx

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP