Because of the size of the files, work from the desktop while completing All
Access Projects. You can always save them on a floppy when complete. Insert
your name the application and Project number in the header of screen shots submitted.
Label all screen shots.
Access Project 1(35 POINTS) Label the screen
shots using TEXT BOXES
Complete pages AC-7-AC-45 Save all databases in a folder called 1 Access Project
Hand In:
1.A screen Shot of Access Project 1 (details
view) There should be 5 databases and 1 Excel file.
2. A screen Shot of Selections database Window showing 1 new Table (Customers)
3. A screen Shot of Selections database, Customers Table in Design View
4. A screen Shot of Websites.mdb, sites table in Design View
5. Add
a Text box listing extensions for all (5) applications we have learned so far.
Format the text box’s color and lines
NOTES
When importing text files make sure to put a check, in the
box that asks if the First row contains field names
When creating a database using a Wizard…Click File>New>Choose
Database Tab>Then choose the Contact Management Database Template
Access Project 2(25 POINTS) Label the screen
shots using CALLOUTS
Create a folder called 2 Access Project
Copy Selections.mdb into 2 Access Project folder
Complete pages AC-58 – AC-79
Hand In:
Screen Shot of Relationship window for Selections.mdb
Screen shot of relationship window for Employees.mdb
Screen shot of 2 Access Project folder showing all data bases in small
icon view
NOTES
To Create up a Lookup field in the Web Sites Table tab down to a new field
, right click in the data type column and pick Lookup Wizard. Choose the Ratings
table and include both fields in the lookup.
Access Project 3(35 POINTS) Label the screen
shots using SHAPES
Dowload files for project 3, change folder name to 3 Access Project, Copy Selections,
Employees and Web Sites databases into the folder
Complete Pages. AC-83 – AC-106
Screen shot of Selections.mdb, Order Detail Table in Datasheet view
with Lookup showing in the ProductID field
Screen shot of Selections.mdb, Orders Table in Datasheet view with
Lookup showing in the CustID field
Screen shot of Selections.mdb, Customers Table in Datasheet view
showing 30 records.
Screen shot of Database Window showing all 4 tables.
Screen shot of folder 3 Access Project containing all databases DETAILS
VIEW arranged by SIZE
Access Project 4(30 POINTS) Label the screen
shots using STARS & BANNERS
Dowload files for project 4, change folder name to 4 Access Project,
Copy from project 3 the Selections, Employees and Web Sites databases into
the folder
Pg. AC-111 – AC-145
Copy these 4 PATHS, Convert them into a 2-column table and
auto-format the table. Type the pathways in column 2
WORD file named books on a floppy drive
ACCESS file named Selections on the desktop
Text file located in My Documents named test
WORD document named Retirement Plans located in a folder named Project
2 in a folder named WORD
Screen shot of Selections.mdb ProductByCategory query Accessories
category Datasheet view
Screen shot of Selection.mdb CustomerOrders Query Design View
Screen shot of Selections.mdb Customers Table, Datasheet View, Containing
35 Records
NOTES
Make sure to read creating a Parameter Query AC-121 A criteria expression
is enclosed in square brackets.
Creating an Append Query pg. AC-133 It is important to know the path for
the Additions.mdb. It should be in the same folder as the Selections.mdb.
The book says it is on the A drive, but, we have been working from a folder
located on the desktop. Files located on the desktop file this path C:\Windows\desktop\folder\document.extension
Access Project 5(30 POINTS) pg AC-150 – AC-189
Complete Task 1 & 2 in Project 5, add your own name to the Customers Table
Screen shot of the Customers form in form-view Showing 35 records
Products Form in Form View ,Showing 48 records (price will be in currency
format)
Take a screen shot of Orders Form in Form View
Take a Screen shot of Orders Form in Design View
NOTES
A control is an object such as a textbox that displays information in
a form.
