Double check your work before submitting in Blackboard.

Instructions: Read each very carefully!

$1.5$ pts $-$ Open Microsoft ACCESS and create a new blank database. Name the database as Access Skills Test.

$2.20$ pts $-$ Create a new table in your Access Skills Test database. Use the following table structure to create the

table $($in design view$).$ The table will have seven fields. Use the field names, data types and other properties

$($like Field Size$)$ accordingly.

Field sizes are not supposed

to be typed into the

description...that is left

blank. Name the table

$$tblRegistration$.$

$***$PLEASE NOTE THERE IS NO PRIMARY KEY...DO NOT MAKE LAST NAME OR ANY OTHER FIELD

THE PRIMARY KEY. Points will be deducted if some field is made into the primary key$***$

$3.25$ pts $-$ Enter the following ten records: $($the last field is Registration Fee, not Reg. Fee$)$

$4.10$ pts $-$ Create a Query that will show the Last Name, City and Registration Fee for those students that live in

McAllen. Save the query as McAllen.

$5.10$ pts $-$ Create a Query that shows $$all fields$$ for those students who have not paid the Registration Fee $($Not

paid are those students who have $$0\mathrm{.}00$ on the Registration Fee field$).$ Save the query as Not Paid.

$10$ pts $-$ Create a Query that shows the Last Name, First Name, Registration Fee and State for all the $$out of

state$$ students. In other words, not from TX$.$ Hint: key word NOT is useful. Save the query as Non$-$Residents.

$6\mathrm{.}10$ pts $-$ Create a Query that shows the Last Name, First Name, Registration Fee and State for all the $$out of

state$$ students. In other words, not from TX$.$ Hint: key word NOT is useful. Save the query as Non$-$Residents.

$7.10$ pts $-$ Create a Query that shows $$all fields$$ for students who are $$out of state$$ and who have $$not paid$$ the

Registration Fee. Save the query as Out Of State. Hint: two criterions are being used

$8.10$ pts $-$ Create a Query that shows the Last Name, First Name and Registration Fee for all students who have

paid more than $$40\mathrm{.}00$ in registration fees. Sort this query by last name $($use the sort option in the same area

where the query is being built$).$ Save the query as Paid And Sorted.

$9.$ Close Microsoft Access and submit your Access Skills Test before the deadline.