PROJECT 2: QUERY, FORM, & REPORT

PROJECT DESCRIPTION

In this exercise, you will create a database that includes a table, form, report, and a query.

The University of Maryland Global Campus seeks to provide a quality education to each of its students. In order to do this, the college administration needs an efficient way to keep track of the vast amounts of information associated with each student served. A college administrator has asked you to create and update a database to help with this task. 

Note: All information provided below is fictitious and NOT real data obtained from UMGC.

PROJECT DIRECTIONS

Step 1:

Create a new blank database.

Step 2: 

Name the Access file as your last name and “.accdb” (for example; Henry.accdb).
Be sure to name the database before hitting the “Create” button.

Step 3:

In Design View, create a table using the structure shown below:

Name the table: Student List.

Set the “Student #” filed as the primary key.

FIELD NAME

1. DATA TYPE
2. FIELD SIZE

OTHER FIELD PROPERTIES

Student # (Primary Key)

Short Text

5

Last Name

Short Text

Default

First Name

Short Text

Default

Address

Short Text

Default

City

Short Text

Default

State

Short Text

2

Format: Upper case Default value: IL

Zip Code

Short Text

5

First Semester Attended

Short Text

4

Format: Upper case

Step 4:

In Datasheet view, add the data below to the Student List table: Note: For “First Semester Attended” the last two characters are numbers, not letters. For example, ‘SP09’ is an abbreviation of “Spring 2009.” Thus the ‘09’ should both be numbers – not the letter “O” and number “9.”

LAST NAMEFIRST NAMEADDRESSCITYSTATEZIP CODEFIRST SEMESTER
ATTENDED54783WilliamsJack62 Smith LaneChicagoIL60605FA0864849MattoxAlexa125 FairviewBurlingtonIA60606SP0797654Van WeganAllison100 QuanticoChicagoIL60605SS1127846RadcliffPeter230 Hills CircleDecaturGA24756SP1096312BerinsteinChrista126 South StreetSpringfieldMO86542FA0876546JacksonRyan644 Mills CircleBaltimoreMD45632SP1154387JamesClifton84 Heads DriveSan AntonioTX76548FA0887566CollinsJane122 Windy Hill PlaceAthensAL30546SP1337219MajewskiAllen958 Valley BendAustinTX72148FA1065657Your Last NameYour First NameType in any addressType in any cityType in any stateType in any zip codeUse your first semester

Step 5:

Modify the column widths as necessary.

Step 6:

FORM: Create a form using the Form Wizard based on the Student List Table.

a. Use all fields.
b. Layout: Columnar or Tabular.
c. Form Name: Student Form.

Step 7:

In Design View, change the form theme to ANY style you like.

Step 8:

Once the form is created, open the form in Design view and add a label to the Form header that says “Students”.

Step 9:

Format the label so that the text is the Garamond font with size 26 and the text is centered.

Step 10:

Add another label, this time to the form footer with your name.

Step 11:

Format the label so that the text is the Garamond font with size 14 and so that the text is centered.

Step 12:

Save the form.

Step 13:

Add the following 2 records using the form. Note: (Your field data will not wrap around in the field as shown below).

STUDENT ID

LASTNAME   

FIRSTNAME   

ADDRESS    

CITY     

STATE      

ZIPCODE   

FIRST SEMESTER
ATTENDED

76543

Davenport

Lucy

89 Middlebrook Road

Germantown

MD

28564

FA15

84572

Dean

Richie

234 Red Hills Road

Fort Lauderdale

FL

73512

SP17

Step 14:

When you are finished adding the records, save the Form as “Student Form”.

Step 15:

Report: Using the Report Wizard, create a report based on the “Student List” table, according to the following specifications:

a. Use all fields.
b. Group by: First Semester Attended.
c. Layout: Stepped.
d.  Orientation:  Landscape.
e. Title the report: Student Report.
f. Adjust the column widths as necessary.
g. Labels & Text boxes resized to allow for all information to be visible.

Step 16:

Query: Create a query from the “Student List” table using the Simple Query Wizard. The basis of the query is as follows:

a. Your supervisor wants to see a report with the names and student numbers of the students who first attended in the Fall of 2008.
b. Select the appropriate fields and the appropriate criteria.
c. Run the query.
d. Save the query as qry_Fall08.
e. Save the Access database.

SUBMISSION REQUIREMENTS

Please submit the following to your Assignments Folder:

1. The completed Access database file to the CMST 100F Assignment Folder.
2. Submit a Project Reflection (see below):

Project Reflection

Answer the following questions when you submit your assignments files. 

Question 1:  What are some roadblocks that you encountered while completing this assignment?

Question 2:   What is the most important thing that you have learned from completing this assignment?

Note 1:  Please submit your Project Reflection as a Microsoft Word document or just copy and paste your answers in your Assignments Folder’s text box when you submit your assignment along with the rest of the required project files.

Project Grade Weight

Points: This project is worth 400 points or 40% of your total grade for the course.

Grade Reductions: You will lose points for issues such as: not following directions, not submitting your work on time, and failure to include all required elements. Each omission will result in a partial point deduction.

Project 2 Due Date

Hard Due Date: End of Week 4

Laste Penalty: You can submit this assignment until the LAST DAY OF WEEK 4. The Assignments Folder will then be closed and you will not be able to physically submit the assignment for a grade. Exceptions may be allowed, on a case-by-case basis, for life situations (military deployment, medical illness, death in the family, etc.). In all cases, timely notification of a “life situation” is critical to the approval of any extensions. 

Technical Difficulties in Submitting Your Work

Submit Early: Please do not wait until the last minute to submit your assignment. Give yourself at least a 5-hour window to account for any technical difficulties that might arise. If you experience technical difficulties beyond your control that do not allow you to successfully complete the assignment, immediately follow the steps below: 

Step 1: Contact the UMGC Help Center. Inform them of the problem you are having. Get a problem ticket number from them to document the situation.

Step 2: E-mail me ASAP and include a description of the problem you are having and your problem ticket number from the Help Center so I can investigate the situation.

Step 3: E-mail the assignment to my e-mail address. The date and time your e-mail is received will help provide a timestamp of your work.

Archive Your Assignment

CYA:  Please make sure you keep a copy of your project stored on your computer. Technical difficulties do happen–you may need to resubmit your assignment for a number of reasons.  It is always a good policy to CYA (Copy Your Assignment).

Verify Your Assignment Has Been Posted

Make Sure Your Project Was Submitted: It is your responsibility to make sure you have posted your assignment CORRECTLY! Once you have posted your assignment, immediately attempt to view it, just to make sure your post was accepted by LEO, that it is formatted correctly, and you have posted the correct file. You should also receive an Assignment Submission Verification via e-mail (If you do not, that may be a cause for concer)Rubric Name: old_Access Project 2