Microsoft Access Chapter One - Student Projects

Level 1
Level 2
Level 3
Group

Chapter Description:

     Chapter One of Access basically encapsulates Microsoft Access. The chapter goes over the purpose of Access and the various options found in the program. The options mentioned in chapter one are Tables, Forms, and Reports. The emphasis of the chapter one student projects is to give the student a hands on experience of the various uses of Access. The students will not only learn how to use a table, but to also to make one. Also, since chapter one mentions such programs as Report Wizard and Form Wizard, there are some student exercises that pertain to those subjects. It is understood that tables, forms, and reports are looked at more closely in later chapters, however, it should be noted that it is in chapter one in which these three (forms, tables, and reports) are introduced. In order for the student or students to be able to understand what they are facing in later chapters of Access, the exercises in chapter one dealing with tables, forms, and reports are simple compared to later projects (those found in Chapters 2,3, and 4). 

     Microsoft Access is one program in a package. Students must know that Microsoft Office 2000 is a package so it is important to learn all four programs included in the Microsoft Office. With that said, students will also find some projects that require them to open up files with Microsoft Word and Excel. However, the student will do no alteration whatsoever to the files found in other programs, but they will use those files to learn that certain things done in Word and Excel can be incorporated to Access as well, such as pasting a table. 

     Again, Access Chapter One is basically an introduction to Access as a whole. The student projects are designed to get the students to become acquainted with the program through an array of student projects that range from tables, to forms, reports, and even relational databases. 

|Back to top|


Microsoft Access- Chapter One                      

 

Student Project One: Student Database

Description: To display records on a database table and to file and sort the records.

Task One: Open Students Table

Task Two: Filter by selection

Task Three: Filter by Form

Task Four: Sort the Table

Task Five:  Submit Materials

|back to the top|


Microsoft Access- Chapter One                      

 

Student Project Two: Record Management 

Description: Student will learn to actually manage a database into more detail by entering records and editing them.

 Task One: Open Table

 Task Two: Add to field

 Task Three: Add a record to database

            David Muilfa

            Male

            Notes: Transferred 3/10/ 2003

 Task Four: Replace Command

 Task Five: Record Deleting

 Task Six: Print the table

|back to the top|


Microsoft Access- Chapter One                      

 

Student Project Three: Find and Replace

Description: Your friend from the U.S.A just made a table of countries she has visited in Africa and a little bit of information about each.  She plans on showing the table to her friends when she gets back to the U.S.  Looking over the table, you see some mistakes.  Correct the mistakes and put the countries in alphabetical order.  

 Task One: Opening the Table

 

Task Two: Find and Replace

 

Task Three: Find and Replace Part 2

 Task Four: Alphabetizing

 Task Five: Submission

|back to the top|


Microsoft Access- Chapter One                      

 

Student Project Four:  Entering Records Through a Form

Description: Data entry is not just about typing in information into a table. To make it a little more interesting, enter data into a table by using a Form.

 

Task One: Getting Started

 

Task Two: Opening the Form

 

Task Three: Adding Records

 

                        ID:             (autonumber)       (autonumber)   (autonumber)  

                        Fruit:            Banana             Watermelon     Cherry

                        Color:            Yellow             Green             Red

 

Task Four:  Opening Table

Task Five:  Print Results

|Back to the Top|


Microsoft Access- Chapter One                      

 

Student Project Five: Parent Contact Database

Description: Student is prompted to modify a database and thereby using a report to present results.

Task One: Sorting 

 Task Two: Deleting records

 Task Three: Changing Information

 Task Four: Report Wizard

 |back to the top|

 


Microsoft Access- Chapter One                      

 

Student Project Six: Record Management

Objective: The student should know enough about Access to complete simple editing procedures. The following exercise focuses on marinating a database through a table and reporting the results through a report.

Task One: Open Students Table

Task Two: Record Deleting

Task Three: Record Change

Task Four: Replace Command

Task Five: Printing a Report

|Back to the top|

 


Microsoft Access- Chapter One                      

 

Student Project Seven: Table Wizard

Description: A business that you started has become too large for you to handle alone, and so you’ve decided to get more people to help.  To have a record of your employees, create a table that has the: number (1 for the first worker hired, 2 for the second, and so on), last name, first name, and salary.

 Task One: Opening Table Wizard

Task Two: Table Wizard

 

 

Task Three: Entering information

  1. Ngeze, Nwokike, 10,000,000.00

  2. kagame, Haanita, 7,000,000.00

  3. Nahimana, Egyde, 6,000,000.00

  4. Samuels, Sabiq,    7,500,000.00

  5. Terry, Doresha,    5,000,000.00

  6.  Wati, Domanique,  5,250,000.00

  7. Kabarebe, Jean,    6,750,000.00

  8. Kabila, Kamalja,   7,250,000.00

  9.  Peters, Deaw,    5,250,000.00

  10. Davis, Kokor,     4,000,000.00

 Task Four: Submission

|Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Eight: Query

Description: You realized that you have quite a few contacts that come from all over the world and decided to make a database.  A few months later, you would like to know how many of these contacts are classmates.   This project will familiarize you with the query function of Access, which will help you sort the information you want.

Task One: Getting Started

 Task Two: Starting Query

Task Three: Selecting Fields  

 

 

Task Four: Sorting

 

Task Five: Editing

 

Task Six: Closing Document 

 

Task Seven: Present Results

|Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Nine: Specifying a Table

Description: The student will now actually make a table of their own rather than working with a table that was already provided. The student will pretend to own and operate a bookstore in which they will use a table to keep track of an inventory of books. Ten books will be used for this exercise.

Task One: Making a new table

Task Two: Creating Field Names

           NOTE: Rename the Sample Field 'Title' first!

Sample Field Name

Renamed Field

First Name Title
Last Name Author
Title List Price
Organization Publisher

 

Task Three: Table Wizard Steps

Task Four: Entering Records

|Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Ten: Student Report

Description: Just as before, the student is prompted to edit a table and then is told to furnish a report. 

Task One: Open database

 Task Two: Filtering

 Task Three: Sorting

 Task Four: Print Report 

 Task Five: Filtering 

 Task Six: Sorting 

 Task Seven: Print Report

 Task Eight: Submit

 |Back to the top


Microsoft Access- Chapter One                      

 

Student Project Eleven: African Countries

Description: The student will alter a table of African Countries and submit documents to the instructor.

Task One: Opening the File

Task Two: Entering Rwanda

Capital Kigali
Independence 1962
Population (estimation) 7,398,074
Area 26,338 square miles

Task Three: Find and Replace

Task Four: Sorting

 

Task Five: Sorting Pt. 2

Note:  In the table, a country with the independence year of 3000 represents a country that does not have it’s independence. Also, Ethiopia is believed to have received it’s independence over 2000 years ago, therefore the year 3(2003-2000) represents when it might have gotten it’s independence.

|Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Twelve: Creating a Form

Description: Although you don't look into forms until later in the Access Chapter, it is important to familiarize yourself with it before advancing into the course. Follow the steps, which instruct you on how to make a Form through wizard (Form Wizard was mentioned in Chapter One).

Task One: Getting Started

 

 

Task Two: Choosing Fields

 

 

Task Three: Deleting Fields

 

Task Four: Choosing a Layout

           

 

Task Five: Choosing Style

           

 

Task Six: Naming the Form

           

Task Seven: Entering Information

 |Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Thirteen: Relational Database

Objective: The student will get a chance to open up tables and see relationships established in them. They are then going to use a query which will familiarize them with relational databases and queries.

Task One: Opening Relationships Window

Task Two: Creating Relationships

Task Three: Filtering Clerks

Task Four: Making Report

|Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Fourteen: Editing and Modifying a Form

Description: This project is used to familiarize the student with Forms. Modifying a table is very much different from modifying a Form. There are more options with the form making it almost more enjoyable to work with it than entering data by a table. Again, this project is simple as possible and is only served to get the students familiarized with the Form, since Chapter One went over Forms, Tables, Queries, and Reports. 

Task One: Getting Started

 

 

Task Two: Changing Font

 

 

 

Task Three: Editing Form

 

Task Four: Changing Background

 

Task Five: Find and Replace

 

 

 |Back to the top|


Microsoft Access- Chapter One                      

 

Student Project Fifteen: Design View 

Description: Although design view will be discussed more thoroughly in later chapters, this exercise will give the student a brief introduction.

 Task One: Opening Microsoft Access

Task Two: Beginning Table 

 Task Three: Saving Table 

 Task Four: Datasheet View 

 Task Five: Creating Table

 Task Six: Sorting by Price

 Task Seven: Save File

|back to the top|


Microsoft Access- Chapter One                      

 

Project Sixteen: From Excel to Access  

Description: One important thing that students need to know is that they can merge, or switch files from one Microsoft program to the next. In this project, the student will be given the assignment and asked to work in at least groups of two to complete the project.

Task One: Obtaining the Excel document

Situation: You are an assistant to a professor. Currently, the professor knows nothing about Excel or Access, which is why he hired you because you are now educated in these programs. His last assistant placed his student roster inside Excel, but now he wants to make a student database for his lecture. 

Task Two: Creating a Table

                Example:

Column A (Excel)

Field 1 (Access)

Student ID

Student ID

Task Three: Making Reports

  1. Majoring in Business
  2. Failing the course
  3. Completing the course with an A
  4. Graduating in 2005
  5. Are business majors, failing the course, and graduation in 2005
Last Name First Name Student ID Gender Major Graduation Grade

Task Four: Preparing the Material for Submission 

|Back to the top|


Microsoft Access- Chapter One                      

 

Project Seventeen: African Colleges

Description: Your teacher has started a database of some of the colleges and universities in Central, East, and Southern Africa. The teacher needs your group to go and enter their city/province and the telephone number to each institution. The professor also wants you to enter a hyperlink to each on the universities websites.

 Objective: To familiarize student with entering data into a large database

                  Learning how to get information from a website

                  More practice with filter and sort

 Task One: Open database

Task Two: Open Website

Task Three: Insert column

 Task Four: Adding Records

  1. AHFAD University for Women, Sudan, North

  2. THE AMERICAN University in Cairo, Egypt, North

  3. BAYERO University, Nigeria, West

  4. Université national du BENIN, Benin, West

 Task Five: Sorting

Task Six: Filtering

 Task Seven: Filter by Form Pt. 2

 

  

 

Task Eight: Filter by Form Pt. 3

 Task Nine: Save and Present work

|Back to the top|


Microsoft Access- Chapter One                      

 

Project Eighteen: Relational Database

Description: Creating a Database with multiple tables, then creating a query, form and report using both tables. This exercise contains many parts and may be split among the group.

 Task One: Opening Access

 

Task Two: Creating Table 1

 

 

Task Three: Creating Table 2

 

Task Four: Creating a Form

Task Four: Entering Data

 

Product Name: Flying High
Product Description: Shoe
Season: Spring
Gender: Female
Product Name: Flying High
Units on Hand: 10
Units on Order: 100
Unit Price: 50.00
Reorder Quantity: 25

Task Five: Creating a Query

  Task Six: Creating Report

 Task Seven: Printing Results

 |Back to the top|


Microsoft Access- Chapter One                      

 

Project Nineteen: Combining Tables, Forms, and Reports

Description: Making a table, form, and report.

Task One: Getting Started

Task Two: 

Task Three: Renaming Fields

Task Four: Table Names and Primary Keys

Task Five: Changing Data type

  1. Data type should be text

  2. Delete input mask

  3. Make sure field is required

Task Six: Form Wizard

Task Seven: Completing Table

DEPARTMENT OF MANAGEMENT

Dr. RAMA B. RAO, Head of Department

Dr. Emmanuel MUGUNGA, Senior lecturer
Dr. Jean Bosco MUTAJOGIRE, Associated Professor
Dr. Theodore BUSORO RUTEBEKA, lecturer
Dr. K. VIVEKANANDAN, lecturer
M. Anselme KAYIHURA, lecturer
M. Jean Nathan SEZIBERA, lecturer
M. SHAHANARA HUQ , lecturer
M. Pastor Bonus NSABIYUMVA, Assistant lecturer
M. Tharcisse GASAMBO, Assistant lecturer
M. Emmanuel GAKWAYA, Assistant lecturer
M. Jean Bosco SHEMA, Assistant lecturer
M. Celestin MUSERUKA, Assistant lecturer 

Task Eight: Finishing Off

Task Nine: Report Wizard

Task Ten: Submission

 |Back to the top|  


 

Student Project Twenty: Creating a Database

Description: This last project is left up to the discretion of the student. He or she should know by know, especially since this is a group project, on the purpose of Access and how to use it.

Task One: Getting Started

Task Two: Research

Task Three: Making a Table

Task Four: Sorting

Task Five: Creating a Report

Task Six: Creating Two Reports in One

|Back to the top|

Return to Main Page