MS Access Activity

1. Create a new database. Save it using the filename Lastname.Firstname.accdb. (use your own first and last name)

2. Create a table in your database using the following:

Field Name	Data type	Field size or Format
ID Number	Text	10
Name	Text	15
Last Name	Text	15
Telephone Number	Number	Long integer
Date of Birth	Date/Time	Medium Date
Department	Text	4
Family Income	Currency	Currency

3. Make the ID Number field as the primary key.

4. Save the table as Student table.

5. Enter 5 complete records.

6. Sort the table in ascending order by surname.

7. Change the field size of the surname to 20.

8. Create a form with all the fields in the student table.

9. Name the form student entries.