NEED HELP IN MICOROSOFT ACCESS DATABASE

Grading Rubric – Access 2010

Tutorial 9, Case Problem 2

Class:

Professor:

Notes:

Solution File: Exercise.accdb

Description Pts Your

Score

tblMember and tblSchedule have a many-to-many relationship, with

tblClass serving as the related table 3

tblMember and tblCreditCard have a one-to-one relationship, with

referential integrity and cascade updates options selected 2

tblSpecialMember is created from a make-table query that selects

records from the tblMember table where the MembershipStatus field

value is On Hold, and displays all fields except Street, City and State

4

An append query adds records in which the MembershipStatus field

value is Inactive to tblSpecialMember 3

An update query changes the MemberComments field value to

“Create a special program” for records with a Zip field value of 23058 3

A delete query deletes records in which the ProgramID field value is

207 3

tblMember and tblCreditCard use an outer join in the

qryMemberCreditCardOuterJoin query 4

qryMemberCreditCardOuterJoin selects all records from the

tblMember table and any matching records from the tblCreditCard

table

3

tblMember has an index that allows duplicates named JoinDate, but

not a ProgramID index 3

The first record in tblMember has the student’s first and last names in

the First Name and Last Name columns 2

TOTAL POSSIBLE POINTS: 30 0

YOUR SCORE: _______________

Grading Rubric – Access 2010

Tutorial 9, Case Problem 4

Class:

Professor:

Notes:

Solution File: Rentals.accdb

Description Pts Your

Score

The first record in tblGuest has the student’s name in the Guest First

Name and Guest Last Name columns 2

tblProperty and tblPersonnel have a many-to-many relationship, with

tblWork serving as the related table, with referential integrity and

cascade updates options selected

4

tblSelectedReservation is created from a make-table query that selects

records from the tblGuest and tblReservation tables where the City

field value is Chicago, and displays the fields shown

4

An append query adds records where the City field value is Aurora or

Evanston to tblSelectedReservation 3

A delete query deletes records in which the RentalRate field is less

than $1,000 from tblSelectedReservation 3

tblGuest and tblReservation use an outer join in the

qryGuestReservationOuterJoin query 4

qryGuestReservationOuterJoin query selects all records from the

tblGuest table and any matching records from the tblReservation table 3

qryPersonnelSelfJoin has been created based on tblPersonnel with the

PersonID field as the primary key and Manager as the foreign key,

with fields selected as shown and column names in the query

recordset as shown

4

tblGuest has an index named Location that consists of the StateProv

and City fields but does not have a PostalCode index 3

TOTAL POSSIBLE POINTS: 30

YOUR SCORE: _______________

Grading Rubric – Access 2010

Tutorial 10, Case Problem 2

Class:

Professor:

Notes:

Solution File: Exercise.accdb

Description Pts Your

Score

frmQueries has the text Exercise Queries on its tab 2

The heading “Select a query” appears above the list box in Century

Gothic 12 point bold font 2

A list box with the Name Property value lstQueryList displays all the

query names contained in the Portland database, except those that

begin with ~

2

Two command buttons appear below the list box 2

The left command button displays the Preview icon above the word

Preview, and the right command button displays the MS Access

Query icon above the word Display

2

Double-clicking a query name or selecting a query name in the list

box and clicking the right command button causes the query datasheet

to appear

2

Clicking the left command button opens the selected query in Print

Preview 2

Macros have been created for the form, the list box, and both

command buttons 2

The background color of the Detail section is Aqua Blue 2 and the

background color of the list box is Aqua Blue 1 2

frmQueries’ shortcut menu, record selectors, and navigation buttons

are disabled 2

frmNavigation has been created, using the Horizontal Tabs, 2 Levels

layout 2

The name of the left tab is Forms, and it has the forms below it in the

order shown 2

The name of the second tab is Queries, and the frmQueries form is

below it 2

The name of the third tab is Reports, and it has the reports below it in

the order shown 2

The navigation form’s picture and title have been deleted, and the tab

name changed to Exercise database 2

TOTAL POSSIBLE POINTS: 30 0

YOUR SCORE: _______________

Grading Rubric – Access 2010

Tutorial 10, Case Problem 4

Class:

Professor:

Notes:

Solution File: Rentals.accdb

Description Pts Your

Score

frmQueries has the text Rentals Queries on its tab 2

The heading “Select a query” appears above the list box in 12 point

bold font 2

A list box with the Name Property value lstQueryList displays all the

query names contained in the Rentals database, except those that

begin with ~

2

Two command buttons appear below the list box 2

The left command button displays the Preview icon above the word

Preview, and the right command button displays the MS Access

Query icon above the word Display

2

Double-clicking a query name or selecting a query name in the list

box and clicking the right command button causes the query datasheet

to appear

2

Clicking the left command button opens the selected query in Print

Preview 2

Macros have been created for the form, the list box, and both

command buttons 2

The background color of the Detail section is Light Gray 1 and the

background color of the list box is Aqua Blue 1 2

frmQueries’ shortcut menu, record selectors, and navigation buttons

are disabled 2

frmNavigation has been created, using the Horizontal Tabs, 2 Levels

layout 2

The name of the left tab is Forms, and it has the forms below it in the

order shown 2

The name of the second tab is Queries, and the frmQueries form is

below it 2

The name of the third tab is Reports, and it has the reports below it in

the order shown 2

The navigation form’s picture and title have been deleted, and the tab

name changed to Rentals database 2

TOTAL POSSIBLE POINTS: 30 0

YOUR SCORE: _______________

Grading Rubric – Access 2010

Tutorial 11, Case 2

Class:

Professor:

Notes:

Solution File: Exercise.accdb

Description Pts Your

Score

frmMemberInfo has been created using tblMember as the source table 3

A procedure for frmMemberInfo converts City field values to their

proper case 6

The above step run properly. 2

A procedure for frmMemberInfo verifies Phone field values equal

either 703 or 804 if the State is VA 3

The above step runs properly. 2

The procedure displays an appropriate error message if the Phone

field value is invalid, cancels the event, reverses the change, and

moves the focus to the Phone field

6

A procedure for frmMemberInfo displays the word “Current” to the

right of the MemberID text box in bold, magenta text when the

MembershipStatus field value is “Active”, or “Review” in bold blue

text otherwise

6

Make a backup copy and post it also in the link. 2

TOTAL POSSIBLE POINTS: 30 0

YOUR SCORE: _______________