-
Everything on this PROJECT will be on your test! Be sure to use
help and Pizza Payroll for assistance.
-
CALCULATED FIELD:
Create a select query that
includes: CabinName and NumberOfBunks. Create a calculated
field named DoubledBunks that calculates the number of bunks if we doubled our number of
bunks.
Save it as doubledbunks. Use help! [See Coral or Pizza for
help!]
-
Include one message box macro on each of your
Access Database forms. Have it run when the form is opened.
- Create switchboards
for your database: main, tables, forms, reports and queries.
All forms, reports, tables and queries must be linked.
- Include an option on
your main switchboard to open tables, forms, reports and queries.
- Include an
option on your main switchboard to edit your switchboard.
- Open all
forms in edit mode.
- Include an
option on your tables, forms, reports and queries switchboards that returns
you to the main switchboard.
-
Include an command button
on your main switchboard to exit your
Summer
Camp database.
- Include a
command button
on the main switchboard that will exit
Microsoft Access.
- Customize your switchboard
colors. Be consistent.
- Add an appropriate picture to the Main Switchboard.
- Set the
switchboard to be loaded at start-up.
-
Set a password--use
stock as your
password or I will not be able to grade it!
-
Import the data and
create a new table from the spreadsheet Activity Fees. Create an
appropriate relationship.
-
Run the DoubledBunks
Query. Export the results
of the DoubledBunks Query to Excel and create
the chart you see below. Save it as an item in the spreadsheet.
Save the spreadsheet as doubledbunks in your Access Unit 3 Folder.
|