excel and excess skill
Microsoft Access Skill Test
1. Create a table called Students with these fields: (20%)
|
Field |
Data Type |
Size |
Format |
|
FirstName |
Short Text/Text |
12 |
N/A |
|
LastName |
Short Text/Text |
12 |
N/A |
|
SocialSecurity |
Short Text/Text |
Input Mask |
Social Security Number |
|
Salary |
Currency |
2 places of Decimal |
Currency |
|
WebAddress |
Hyperlink |
N/A |
N/A |
|
BirthDate |
Date/Time |
Input Mask |
Short Date |
|
Picture |
OLE Object |
N/A |
N/A |
Make Social Security a Primary key.
2. Populate this table with your imaginary 10 records. Make sure you have 5 students that make more than $1000 in salary. (10%)
3. Create an Input Form using Form Wizard and enter your information as the 11th Record. (20%)
4. Create a query with Query Design and display only records of students that make more than $1000. (20%)
5. Create a query with Query Design and sort records of students by LastName in ascending order. (20%)
6. Create a report using Report Wizard. (10%)