Criteria Level 4 Level 3 Level 2 Level 1
#1-Project file/name. Launch MS Access and open a blank Access database. Save the new database with the following name: “Student’s First Initial Last Name Provider Information” 0.05 points
Database file name correct

0 points
0 points
0 points
Database file name does not include student’s name
OR
File name does not include “Provider Information”

#2-Field:Provider ID (auto number)-Set as primary key 0.2 points
Field name correct and is set as Primary Key

0.1 points
Field name correct but field not set as Primary Key

0.05 points
Field name not correct

0 points
Field name missing or not as specified
AND
field not set as Primary Key

#3-Field: Provider’s Company Name (text) 0.1 points
Field name correct

0.05 points
Field name not correct as specified

0 points
0 points
Field missing

#4-TWO SEPARATE FIELDS: Field:Provider Contact-First Name (text) and Field:Provider Contact-Last Name (text) 0.4 points
Field names correct and field type correct

0.2 points
Field names not as specified

OR field type incorrect

0.1 points
Field names not as specified

OR field type incorrect

0 points
One or both fields missing

#5-TWO SEPARATE FIELDS: Field:Billing address (text) and Field: City (text) 0.4 points
Field names correct and field types correct

0.2 points
One or both Field names not as specified OR field type incorrect

0.1 points
Field names correct but one or both Field types not correct

0 points
One or both fields missing

#6-Field: State (text—field size set to 2 characters) 0.4 points
Field name and field type as specified
AND
field size set to 2 characters

0.1 points
Field name and field type correct
BUT
field size not set to 2 characters

0.05 points
Field name OR field type not as specified
AND
field size not set to 2 characters

0 points
Field missing

#7-Field: Zip Code (text—field size set to 5 characters) 0.4 points
Field name correct, field type is correct and field size is set to 5 characters

0.1 points
Field name correct and field type is correct BUT
field size is not set to 5 characters s

0.05 points
Field name not as specified
OR
field type not correct
AND
field size is not set to 5 characters

0 points
Field missing

#8-TWO SEPARATE FIELDS: Field:Phone number – area code (text—field size set to 3 characters); Field: Phone number (text) (Use xxx-xxxx format when entering data) 0.6 points
Both field names correct.
Both types are correct
Area code field size is set to 3 characters

0.3 points
Both field names and types correct
BUT
Area Code field size is not set to 3 characters

0.15 points
One field name or field type incorrect
AND
Area Code field size is not set to 3 characters

0 points
One or both fields missing

#9-Field: YTD Orders (currency). When entering the data you will enter the total amount ($s) of orders your company has placed with each Provider 0.2 points
Field name correct and field set to data type Currency

0.1 points
Field name correct
BUT
not field type not set to data type Currency

0 points
0 points
Field missing

#10-Field: Preferred Vendor (Yes/No) (Criteria must be provided in the Description field (Design View) which identifies what constitutes a Preferred Supplier). Base the Preferred Provider on a threshold of YTD amounts. 0.3 points
Field name correct, type correct (yes/no) and criteria entered into Description field

0.1 points
Field name correct, field type correct
BUT
no criteria entered into Description field

0.05 points
Field name not correct
OR
[field type not correct
AND
criteria not entered into Description field ]

0 points
Field missing

#11-All field names are visible in datasheet view 0.1 points
No truncated field names in Datasheet View

0.05 points
At least one field name is truncated in Datasheet View

0.01 points
Two field names are truncated in Datasheet View

0 points
More than two field names are truncated in Datasheet View of the Table

#12-Save and name the table “Provider Information Table” 0.05 points
Table name is correct

0 points
0 points
0 points
Table name not as specified

#13-Data Entry form. Use the Form Wizard to create a form that uses all the fields from the Provider Information Table. 0.2 points
Form contains all table fields

0.15 points
Form missing some table fields

0 points
0 points
No data entry form created

#14-Select Theme. Do NOT use the default theme which is Office 0.1 points
Theme (other than default) selected and applied

0 points
0 points
0 points
Office theme used by default

#15-Form Name: Save and name the form “Provider Data Entry Form” 0.05 points
Form name is correct

0 points
0 points
0 points
Form name not as specified

#16-All field names are fully visible in each field in Form View (no truncated entries) 0.1 points
No truncated field names in Form View

0.05 points
One field name truncated in Form View

0.01 points
Two field names truncated in Form View

0 points
More than two field names truncated in Form View

#17-Enter all data (fill all fields) for seven Providers. At least one Provider is marked as Preferred. 0.25 points
Data entered for seven providers
AND
one provider is marked as Preferred and agrees with Preferred Provider criteria.

0.1 points
Data for fewer than 7 providers entered
OR
Selected Preferred provider does not meet criteria in field description
OR
at least one obvious typo in data entry

0.05 points
Provider marked as preferred but no criteria was set in table Preferred Provider field (no way to verify selection)

0 points

[Data for fewer than 7 providers entered
AND
No provider marked as Preferred]
OR
Selected Preferred provider does not meet criteria in field description
OR
more than one obvious typo in data entry

#18-All entered data is fully visible in each field in Datasheet View of the Provider Information Table (no truncated entries) 0.1 points
No truncated Provider data in Datasheet view of the Table

0.05 points
At least one provider data entry truncated in the Datasheet view of the Table

0.01 points
Two provider data entries truncated in the Datasheet view of the Table

0 points
More than two provider data entries truncated in the Datasheet view of the Table

#19- Contact report. Use the Report Wizard to create a report from the database that uses the fields and order specified in the project description 0.2 points
Report created with the correct fields and showing in correct order

0.1 points
Data not in the order specified.

0.05 points
Report created with missing fields or too many fields

0 points
No report created

#20-Sort data in report by Provider Contact-Last Name. Ensure that the order of the fields is still the same as identified above: company name, first name, last name, address, phone number. 0.1 points
Report displays data sorted by Provider Contact Last Name. Fields in correct order: company name, first name, last name, address, phone number

0.05 points
Report sorted by incorrect field
Fields in correct order: company name, first name, last name, address, phone number

0.01 points
Report sorted on last name field, but order of fields not as specified.

0 points
No sort done on the data in the report

#21-All field names and entered data are fully visible in all areas of the report (no truncated entries) 0.1 points
No truncated field names or data in the Report view

0.05 points
One field name or one data entry truncated in the Report View

0.01 points
Two field names or two data entries truncated in the Report View

0 points
More than two field names or data entries truncated in the Report View

#22-Save and name this report as “Provider Contact Information.” Be sure the report includes information on ALL providers. 0.05 points
Report name is correct

0 points
0 points
0 points
Report name not as specified

#23- Mailing labels. Create mailing labels for the provider list: Include • Contact person’s full name • full company name • full mailing address. 0.5 points
Mailing labels created
Layout is correct and is in standard envelope format

0.3 points
Format of labels is not correct
– lines not separated
OR
– spaces do not separate address entries
OR
– two much information included (e.g., ID, phone #).

0.1 points
Format of labels is not correct – lines not separated
AND
spaces do not separate address entries

0 points
No mailing labels created

#24-Save and name this report “Provider Mailing Labels.” 0.05 points
Report name is correct

0 points
0 points
0 points
Report name is not as specified

#25- MS Word document. See project description for format and details to be included in this document. 1 point
(+0.05) document name and format are correct
(+0.05) Title page is correct
********
(+0.45)for each on target response to two questions
********

No typos or grammatical errors

0.5 points
Response to questions not on target
OR
fewer than the required 4-5 sentences per question

0.3 points
Document name OR format are NOT correct (-0.05)
Title page is not correct (-0.05)

Response to questions not on target (-0.45) or less than the required 4-5 sentences per question

OR 1-3 typos or grammatical

0 points
No document included in submission

OR

More than 3 typos or grammatical errors in responses