Define a new Database

When you open Access, the following window appears.

1. Select Blank Database.



2. Click OK.


The create database window is displayed. This dialog box is VERY IMPORTANT! This is where you SAVE your database and give it a name. Unlike, other Windows programs, Access asks you to create, name, and save your database as the FIRST step, rather than the LAST step.



3. Select a drive to store your database on.



4. Select a folder to store your database in.



5. Type a filename.

Access stores ALL database components in one file (the one you name here).

6. Click Create.

Top of Page

Define a new Student Information Table

The following Database window will appear.

1. Select the Tables Selection from the menu at the left.



2. Select New.



3. Select Design View.

We will be defining a new table with student name, address, and emergency contact information.


4. Click OK.

Alternate method: You may select (DOUBLE-Click) "Create Table in Design View".
The Table Definition window will be displayed.




5. Type the following field names.

(See example above.) All the fields will contain text. We won't change any "Field Properties" at this time.
1. StudentName
2. Street
3. City
4. State
5. Zip
6. Emergency Contact


6. Click Close. ý

You will be asked if you want to save the table.


7. Click Yes.

You will be prompted for table name.


8. Type StudentInformation.



9. Click OK.



10. Click NO to question concerning creation of a primary key.

Top of Page

Insert Information into your StudentInformation Table

1. Select the Tables Tab.



2. Select StudentInformation.



3. Select Open.
1. Select datasheet view, if a dialog box appears.



4. Type the information shown in the example below.

1. Close this window. ý

Top of Page

Define a second Student Table for Grades

1. Select the Tables Tab.



2. Select New.



3. Select Design View.



4. Click OK.

We will be defining a second table with student name and grade information.




5. Type the following field names. (See example above.)
1. StudentName - Note: Data type is text
2. Grades - Use drop-down list in Data Type column to select Number. Use drop-down list in Field Size of Field Properties column to select Integer.

Note: Grades are numeric not text.


6. Click on Close.

You will be asked if you want to save the table.


7. Click Yes.

You will be prompted for table name.


8. Type StudentGrades.



9. Click OK.



10. Click NO to question concerning creation of a primary key.

Top of Page

Insert Information into your StudentGrades Table

1. Select the Tables Tab.



2. Select StudentGrades.



3. Select Open.

The table will be displayed in datasheet view.


4. Type the information shown in the example below..









5. Close this window. ý

Top of Page