-
Everything on this
PROJECT will be on your test! Be sure to use
help and Pizza Payroll for assistance.
-
DAP: Create a
data access page containing all the fields from the Coral Sites Table.
Save it in your folder.
-
CALCULATED FIELD:
Create a parameter query
that asks for the Site. Include the Date, SiteID and Time fields. Create
a calculated field that calculates the Days_Elapsed. (Use Date() as part
of your calculated field). Save it as Days Elapsed. [See Pizza
Payroll for examples].
-
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 DAP's and queries.
All forms, reports, tables, queries and DAP's must be linked.
- Include an
option on your main switchboard to open tables, forms, reports,
DAP's and queries.
- Include an
option on your main switchboard to edit your switchboard.
-
Include an command button
on your main switchboard to exit your database--Coral
Research. Done in Switchboard Manager.
- Include a
command button
on the main switchboard that will exit
Microsoft Access.
Make a macro.
- Include an
option on your tables, forms, reports and queries switchboards that returns
you to the main switchboard.
- Open all
forms in add mode.
- Customize your switchboard
colors. Be consistent.
- Add an appropriate picture to the Main Switchboard.
- Set the
switchboard to be loaded at start-up. [See Pizza Payroll]
- Have you Main Switchboard maximize at
startup. [See
Pizza Payroll].
-
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 coral divers. Create an
appropriate relationship.
-
Run the Days Elapsed
Query entering in 2 for the parameter value. Export the results
of the Days Elapsed Query to Excel and create
the chart you see below. Save it as an item in the spreadsheet.
Save the spreadsheet as coralchart in your Access Unit 3 Folder.
|