Mis 300 Access Assignment
MIS 300 Access 2007 Database Assignment
The data are in the two attached files. They are called AccountInfo and CustomerInfo. These are Excel files, but are only meant to get you the required information for the Access database project. These two files contain the information needed to create two tables in Access. These instructions explain how to do this.
1. Open Access 2007
2. Click on the “Office Button”; Select “New”
3. On the right of the screen, under “Blank Database”, enter a filename
“MIS 300 Access Lab-Your Name”; substitute your name for “YourName”.
4. Click on “Create”
5. Create the table CustomerInfo.
To create a table:
If a table already exists, right click on the table tab and choose “Design View”. Access will ask for a table name. Type in “CustomerInfo” and click “OK”.
If the table does not exist,
Click on “Create” on the Ribbon; then click on Table; View; Design View.
Access assumes the first field is the primary key field. This does not have to be the case, so right click on the “key” and click on “Primary Key”.
Input the field names:
Click on the first field and type in “CustomerID”; Use right arrow and choose Number”.
Use the arrow keys and go to the next row under Field Name:
Last Name Text
First Name Text
Middle Initial Text
Address Text
City Text
State Text
Zip Text
Right click on the square box next to the “CustomerID” field and choose “Primary Key”.
Right click on the “CustomerInfo” tab and save the table.
Right click on the “CustomerInfo” tab and close the table.
Use a similar process to create the table “AccountInfo”
AccountID Number Primary key
OpeningDate Date/Time
TypeOfAccount Text
Balance Currency
CustomerID Number Must be the same type as
“CustomerID” in “CustomerInfo”—This is a foreign key
Inputting the data:
Right click on the table and choose “Open” or double click on the table.
Input the information given for the two tables.
Save and close both tables.
Relationships
The data are in the two attached files. They are called AccountInfo and CustomerInfo. These are Excel files, but are only meant to get you the required information for the Access database project. These two files contain the information needed to create two tables in Access. These instructions explain how to do this.
1. Open Access 2007
2. Click on the “Office Button”; Select “New”
3. On the right of the screen, under “Blank Database”, enter a filename
“MIS 300 Access Lab-Your Name”; substitute your name for “YourName”.
4. Click on “Create”
5. Create the table CustomerInfo.
To create a table:
If a table already exists, right click on the table tab and choose “Design View”. Access will ask for a table name. Type in “CustomerInfo” and click “OK”.
If the table does not exist,
Click on “Create” on the Ribbon; then click on Table; View; Design View.
Access assumes the first field is the primary key field. This does not have to be the case, so right click on the “key” and click on “Primary Key”.
Input the field names:
Click on the first field and type in “CustomerID”; Use right arrow and choose Number”.
Use the arrow keys and go to the next row under Field Name:
Last Name Text
First Name Text
Middle Initial Text
Address Text
City Text
State Text
Zip Text
Right click on the square box next to the “CustomerID” field and choose “Primary Key”.
Right click on the “CustomerInfo” tab and save the table.
Right click on the “CustomerInfo” tab and close the table.
Use a similar process to create the table “AccountInfo”
AccountID Number Primary key
OpeningDate Date/Time
TypeOfAccount Text
Balance Currency
CustomerID Number Must be the same type as
“CustomerID” in “CustomerInfo”—This is a foreign key
Inputting the data:
Right click on the table and choose “Open” or double click on the table.
Input the information given for the two tables.
Save and close both tables.
Relationships