Student Database Activity

EDUC 210: Computers in Education

Simple Access Database Tutorial

CREATING AND EDITING A TABLE

1. Open Microsoft Access.

2. Click “Blank Database” to create a new database.

3. Name the database FSU Courses (your initials) eg FSU Courses RJ.

4. Click the view icon , and select Design View.

5. Save the table as Spring 2009.

6. Change the first field name to CRN.

7. Change the data type to Number

8. Create the following additional fields (make all fields required)

Field Name	Data Type
Department	Lookup Wizard**
Course_Number	Number
Description	Text
Instructor	Text
Location	Text
Allow_Pass_Fail	Yes/No

** Once you have clicked lookup wizard, follow the following steps:

· Select “I will type in the values that I want” and click Next.

· Under Column 1, type the these Departments:

· BIOL

· CHEM

· EDUC

· ENGL

· ELEM

· SPAN

· Click Next

· Click Finish

· The data type for Department will revert to “Text”. That’s okay. You will see the items you typed after steps 9 and 10.

9. Click the View icon again. Save the table.

10. Enter the following Data into the table:

4568	BIOL	110	Principles of Biology	Smith	LS 111	No
6166	CHEM	102	Chemistry II	Mattson	LS 209	Yes
8523	EDUC	210	Computers in Education	Johnson	BU 361	No
6541	ELEM	315	Methods of Teaching Reading	Rosenthal	SBE 104	No
6953	SPAN	110	Spanish I	Diaz	JKSA 301	Yes

CREATING A FORM AND ENTERING DATA

1. Click the Create tab.

2. Click Form.

3. Click the View icon to go to the Form View.

4. Use the form to enter the following additional information:

9432	CHEM	101	Chemistry I	Mattson	LS 209	Yes
5751	EDUC	310	Foundations of Education	Baker	BU 119	No
7596	EDUC	330	Ed Psych and Measure	Baker	BU 136	No
3587	ENGL	300	Children’s Literature	Moore	BU 216	Yes
1358	SPAN	120	Spanish II	Diaz	JKSA 301	Yes

Use the navigational button above to scroll through the records. The arrow with the gold star will take you to a blank form so that you may enter new information.

CREATING A QUERY

1. Click the Create tab.

2. Click Query Wizard.

3. Choose Simple Query Wizard.

4. Add all the fields except Description and Allow_Pass_Fail to the Selected Fields box.

5. Click Next twice.

6. Select Modify the Query Design.

7. Click Finish.

8. Let’s filter the query: under the Department column at the bottom of the page, enter CHEM in the Criteria row.

9. Click the View icon.

10. You should now only see the CHEM classes listed.

CREATING A REPORT

1. Click the Create tab.

2. Click Report Wizard.

3. Under Tables/Queries, select the Spring 2009 table.

4. Add CRN, Department, Course_Number, and Location to the Selected Fields box.

5. Click Next twice.

6. Sort Ascending by Department.

7. Click Next.

8. Select a layout and an orientation and click Next.

9. Select a style and click Next.

10. Click Finish.