Access 2000 – Activity 1

Creating, Saving, and Printing

 

Objectives:

  1. Learn to Create and Save a Database
  2. Learn to Define first database table
  3. Learn to Insert data into first table
  4. Learn to Define second database table
  5. Learn to Insert data into second table

Define a new DatabaseWhen you open Access, the following window appears.Select Blank DatabaseClick OKThe 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.Select a drive to store your database on.Select a folder to store your database in.Type a filename
Access stores ALL database components in one file (the one you name here).
Click CreateTop of PageDefine a new Student Information TableThe following Database window will appear.
Select the Tables Selection from the menu at the left.Select NewSelect Design View
We will be defining a new table with student name, address, and emergency contact information.
Click OK
Alternate method: You may select (DOUBLE-Click) “Create Table in Design View”.
The Table Definition window will be displayed.
Type the following field names.
(See example above.) All the fields will contain text. We won’t change any “Field Properties” at this time.StudentNameStreetCityStateZipEmergency Contact
Click Close. ý
You will be asked if you want to save the table.Click Yes
You will be prompted for table name.Type StudentInformation.Click OK.Click NO to question concerning creation of a primary key.Top of PageInsert Information into your StudentInformation TableSelect the Tables Tab.Select StudentInformation.Select Open.Select datasheet view, if a dialog box appears.Type the information shown in the example below.Close this window. ýTop of PageDefine a second Student Table for GradesSelect the Tables Tab.Select New.Select Design View.Click OK
We will be defining a second table with student name and grade information.Type the following field names. (See example above.)StudentName – Note: Data type is textGrades – 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.
Click on Close
You will be asked if you want to save the table.Click Yes
You will be prompted for table name.Type StudentGrades.Click OK.Click NO to question concerning creation of a primary key.Top of PageInsert Information into your StudentGrades TableSelect the Tables Tab.Select StudentGrades.Select Open
The table will be displayed in datasheet view.Type the information shown in the example below..Close this window.