Students are introduced to the basic commands and functions of database software, and demonstrate how this software can be used as a personal tool in data and information management.

Remember online tutorials are available at Atomiclearning.com

Lesson 1 - Creating Tables & Entering Data in Forms, Designing a Relational Database, Creating Filters

What do your phone number, concert ticket prices, the temperature December 5, 2002 and the largest pancake ever made have in common?

Read about a relational database on this handout. Fill in the blanks on the handout and keep a copy in your binder for reference.

Tutorial
Complete the Lesson One tutorial on handouts available in the classroom Practices 2 - 4. Work through this tutorial step by step and save in your network folder. It is necessary that you complete all steps and save files as you will require them later in this module.

Assignments
Complete the assignments for Lesson 1 - Located in the INFO folder. Save all documents in your network folder.

There are several databases for Lesson 1 - You must create all databases as instructed. Do not print until instructed in the assignment. Much of Lesson 1 will be marked from your network folder, be sure to save your documents with the appropriate file name.

The planning sheets you create for the Music assignment must be submitted for evaluation. Read the Instructions for Designing a Relational Database.

Tutorial
Complete the Lesson One tutorial on handouts available in the classroom Practice 5.

Assignments
After completing Lesson 1 - Part 2 - print as specified in the instructions. Fill out an assignment cover sheet and submit - these assignments will be marked from your folder.

Lesson 2 - Modifying and Updating Forms, Defining Relationships, Creating Select Queries, Creating Range Queries, Creating Wildcard Queries, Sorting Results.

Read about the topics above on the Lesson 2 handout.

Tutorial
Complete the Lesson 2 tutorial on handouts available in the classroom.

Assignments
Complete the assignments for Lesson 2 - Part 1 & 2 - that are located in the INFO folder. Save all documents in your network folder and print as instructed in assignments.

After completing Lesson 2 - Part 2 - print as specified in the instructions. Fill out an assignment cover sheet and submit - these assignments will be marked from your folder.

Lesson 3 - Creating Reports, Report Summaries, Creating Calculated Fields.

Read about the topics above on the Lesson 3 handout.

Tutorial
Complete the Lesson 3 tutorial on handout available in the classroom.

Assignments
Complete the assignments for Lesson 3 - Located in the INFO folder. Save all documents in your network folder and print as instructed in assignments.

After completing Lesson 3 - print as specified in the instructions. Fill out an assignment cover sheet and submit - these assignments will be marked from your folder.

End of Module Summary Assignment - Desiging Your Own Database

Step 1 – Choose a Topic
Choose a topic to design a relational database about.  Some ideas:

• Musical artist information
• Athletic teams
• Movies
• Personal collections

The more familiar you are about your topic the easier this assignment will be.  Choose something you know about and that you have easy access to information about.  You can use the internet to research your topic.

Step 2 – Design the Layout of Tables
Create a rough copy of the layout of your tables (on paper or the computer).  Include:
Field names, length, format, descriptions and the primary key for each table. 
You must have at least two tables.  Each table must have at least 3 fields.  A relationship must exist between the tables.  The complexity of your design (number of tables and fields) will contribute to your overall mark.
For example:  A database about musical artists may contain three tables. 
1 – Artist Information (artist name, age, hometown, genre)
2 – Albums (album name, artist name, number of tracks, year released)
3 – Concerts (artist name, date, location, price)

Your design must be approved by Mrs. Laturnas before beginning.  Include Primary Keys and Relationships.

Step 3 – Create Tables on the Computer
Using your planning create the tables in Access that you have planned on paper. 

Step 4 – Entering Data in Tables
Using the Forms feature enter information into your tables.  Include at least 20 records (records are all the information about one item) in your forms.  You may have more in one table than another.  For example:
            1 – Artist Information may have 7 records
            2 – Albums may have 16 records
            3 – Concerts may have 5 records

 Step 5 – Creating Queries
Define the relationships between your tables.
Create 2 Queries which include information from more than one table.  Label each query appropriately.  Both Queries should be sorted in alphabetical order – choose a logical field to sort by. 
Explain the purpose of the Query – What did you search for?  How would this particular information be useful to someone?
Print Queries.

Step 6 – Creating Reports
Create 2 Reports.

• Report 1 – Should contain information from more than one table.  Information should be organized in a logical way and sorted.  How would this report be useful to someone?
• Report 2 – Should contain information from a Query.   Information should be organized in a logical way and sorted.  How would this report be useful to someone?
• Print Reports

Submit the following for evaluation (In Order):

• Rough copy planning of database – Should include your name and the file name of the database you have created.
• 2 Queries – clearly labeled and purpose explained
• 2 Reports – clearly labeled and purpose explained