CIS 110 Access 5 Assignment

 

Enhancing Forms with OLE Fields, Hyperlinks, and Subforms

 Key Concepts
  • Use date, memo, OLE, and hyperlink fields
  • Use the Input Mask wizard
  • Update fields and enter data
  • Change row and column size
  • Create a form with a subform using the Form wizard
  • Modify a subform design
  • Modify a form design
  • Move and resize fields and labels
  • Change label alignment and size
  • Change the size mode of a picture
  • Change special effects and colors of labels
  • Add a form title and fine-tune the form
  • Change tab stops and tab order
  • Use the form to view data and Web pages
  • Use Date and Memo fields in a  query
  • View object dependencies

 

Videos
  • No videos posted.

What to do

1.      Create a copy of the database used on the previous project.

Create copies of the databases as follows:

Ashton James College 4.mdb  -->  Ashton James College 5.mdb

City Guide 4.mdb  -->  City Guide 5 .mdb

 

 Videos

o                                Copy a database using Windows Explorer - (1:48 - 378KB)

o                                Copy a database using Access Backup feature - (1:11 - 320KB)

 

3.      Complete SAM training and exam for Access 5

4.      Pages AC - Ashton James College; this assignment is not graded or submitted

Chapter 5 Downloads

5.      Part 1 Instructions:

A.      Add the Start Date, Comment, Picture, and Web Page fields to the add Rep Table

B.      Add the data shown below to the Ad Rep table.

C.      Be sure that the datasheet displays the entire comment.

D.      Print the table

AD REP
NUMBER

START
Date

 COMMENT

 PICTURE

 WEB PAGE

21

06/12/2006

Excellent copy editor

pict1

http://cis.cuyamaca.net/draney/110/download/Access/web/trainer1.htm

29

02/06/2006

Records radio advertisements for chamber

pict2

http://cis.cuyamaca.net/draney/110/download/Access/web/trainer2.htm

32

07/04/2006

Also works as a freelance journalist

pict5

http://cis.cuyamaca.net/draney/110/download/Access/web/trainer5.htm

 

5.      Part 2 Instructions:

A.      Create a form for the Ad Rep table that is similar in design to the form shown below.

B.      Include all fields form the Ad Rep table except the Address, City, and Zip Code fields.

C.      Include the Advertiser Number, Name, Balance, and Amount Paid fields from the Advertiser table.

D.      Name the form Ad Rep Master Form

E.      Print the form for ad rep 29.

6.      Part 3 Instructions:

A.      Create a query that includes all ad reps that also work as freelance journalists including the
Ad Rep Number, First Name and Last Name fields.
Save this query as Journalists

B.      Create a query that includes all ad reps that started after 2004 including the
Ad Rep Number, First Name, Last Name, Comm Rate and Commission fields.
Save this query as Employees After 2004

 Grading Rubric

Points

 Requirements

5

Modify Ad Rep Table

5

Ad Rep Master Form

5

Journalists Query

5

Employees After 2004 Query

20

Total possible for uploading City Guide 5.mdb

Drop Box  - Upload Your Assignments to the Digital Drop Box

Downloads