Creating a Database

Create a database of 5 students:

Student number, Last name, First name, Address, City, Zip, Phone

Launch Access:

Creating a Table

Select under New:  Blank Database

You are going to save the information in your folder on the desktop. BUT FIRST

Create a new folder with in your folder: My Access File

Type Students in the File Name box.  Click create.

Creating Fields:

Double click Create table in Design view

Type Student ID in the field name; Press tab.

You could select numbers here since our student IDs are all numbers or select text.

Continue to name the fields.

Field Properties: 

You can change the number of characters in a field.  For example for state the number could be 2.

Primary Key: 

This must be a unique field.  (Student ID)

Click the row selector to the left of the student ID.

Click the Primary key on the toolbar

Click the SAVE button.  Save the table as Student Info

Setting Input Mask:  (Formats data and controls the type of data)

Click the Phone field; click the box next to Input Mask in the Filed Properties section.

Notice the   (Build box) to the right of the box. 

Click the three dots to bring up the Wizard

Select Phone Number.  Click finish.

Entering Data:

Click the View button to change to Datasheet view

You will be prompted to save.  Click YES.

Type the information in the appropriate fields

To adjust the width of the column, move the cursor to the lines between the titles for the fields.  It turns into a crosshair.

Double click the cursor.  (Its Magic!!)

Sorting:

Click the Column Selectorlast name.  The cursor turns into a black arrow.

The column becomes selected.

Click the Sorting Ascending button (or Descending if appropriate) 

To complete assignment: