Microsoft Access Chapter One - Student Projects

Introduction

Level 1 Access Chapter 1 Student Project One: Student Database  Access Chapter 1 Student Project Two: Record Management Access Chapter 1 Student Project Three: Find and Replace Access Chapter 1 Student Project Four: Entering Records Through a Form   Access Chapter 1 Student Project Five: Parent Contact Database

Level 2 Access Chapter 1 Student Project Six: Record Management Part 2 Access Chapter 1 Student Project Seven: Table Wizard  Access Chapter 1 Student Project Eight: Query   Access Chapter 1 Student Project Nine: Specifying a Table   Access Chapter 1 Student Project Ten: Student Report

Level 3 Access Chapter 1 Student Project Eleven: African Countries  Access Chapter 1 Student Project Twelve: Form Wizard   Access Chapter 1 Student Project Thirteen: Relational Database  Access Chapter 1 Student Project Fourteen: Forms  Access Chapter 1 Student Project Fifteen: Design View

Group Access Chapter 1 Student Project Sixteen: From Excel to Access   Access Chapter 1 Student Project Seventeen: African Colleges   Access Chapter 1 Student Project Eighteen: Relational Database   Access Chapter 1 Student Project Nineteen: Combining Tables, Forms, and Reports Access Chapter 2 Student Project Twenty: Creating a Database

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

• Start Microsoft Access on your computer. 
• On the open dialogue box, select More Files and click OK. (Another way to open a file is by pulling down the File command and then selecting Open from the File menu).
• Open StudentProject1.mdb. NOTE: Go to Student Projects folder, then open Student Files.
• On the Student Database dialog box, click the Tables button from the list of buttons on the left (to help you, the buttons are listed in this order: tables, Queries, Forms, Reports, Pages, Macros, and Modules). 
• Click on Students table twice. Refer to the following diagram for reference.

• Pull down Insert and select New Record, or select the New Record button (). 
• Add an entry for yourself. In the grade column, give yourself a grade of A. After completing the last field, press ENTER.

Task Two: Filter by selection

• Click M under the Gender column in Lee's row.
• Click the Filter by selection button ().
• You should now have a list of seven names, not including yourself if your a male, in a new filtered table.
• Print this table and hold on to it.

Task Three: Filter by Form

• Click the Filter by Form button ().
• Click in the column for Gender and press the Delete key. It is always important to clear all prior filters before issuing a new one, unless told not to.
• Under  the Grade column enter the grade letter A. 
• Press the Apply Filter button ().
• You should get the following results in your chart, not including your name.

• Close the new table but DO NOT save any changes. Instead, click on the Filter by Form button () again.
• Delete any previous filters used by clicking the column with a filter in it and pressing the Delete key.
• Under the Grade column, filter all the students who are passing the class (grades other than an F).
• Press the Apply Filter button ().
• Print the new table and hold on to it.
• Close the new table but make sure to NOT SAVE any changes.

Task Four: Sort the Table

• Click the Remove Filter Button ().
• Click any field under the Last Name column and click on the Sort Ascending button ().
• DO NOT make any changes, but print the new table and hang on to it. Your result should look like this: 

Task Five:  Submit Materials

• Combine documents and submit to your instructor.

|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

•     Open Microsoft Access and open the StudentProject2.mdb. NOTE: Go to Student Projects folder, then open Student Files.

 Task Two: Add to field

•     Type “allergic to milk” in the Notes column for Tony Ponsion.

 Task Three: Add a record to database

•  New Student:

            David Muilfa

            Male

            Notes: Transferred 3/10/ 2003

 Task Four: Replace Command

•       Use the replace command to change “Lexy” with “Lexxy".

 Task Five: Record Deleting

•     Delete record of Alex Bjubo.

 Task Six: Print the table

•     Print the table showing the changes made to the information in the Student roster database.

|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

• Open up Access.

• Pull down the File menu, click the Open Command and locate the file Project3mdb. NOTE: Go to Student Projects folder, then open Student Files. Click on it to open.

• Open the table “Find, replace and Sort: African Countries” which can be found in the “Find, Replace, and Sort” database.

Task Two: Find and Replace

• Pull down the Edit menu and click on the Find Command.

• In the Find and Replace dialog box, click on the Replace tab.

• Click in the Find What text box and type Kenya.

• Click in the Replace With text box and type Liberia.

• Find and Replace: Cape Town with Pretoria, Nelson Mandela with Thabo Mbeki, and Zambia with Egypt. Refer to the image below for reference.

Task Three: Find and Replace Part 2

• Find 2000 and Replace it with 1969.

 Task Four: Alphabetizing

• Put the Countries in Alphabetical Order.

 Task Five: Submission

• Print the table and turn it in to your instructor.

|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

• Open Microsoft Access and open the StudentProject4.mdb database.  NOTE: Go to Student Projects folder, then open Student Files. Click on Tables. 

• Double click on Fruits to open the current table.  Observe that there are four records. 

Task Two: Opening the Form

•   Close the table and then open the form that is also called Fruits.  Note that it contains the same four fields as the tables.

Task Three: Adding Records

• Add the following three records:

                        ID:             (autonumber)       (autonumber)   (autonumber)  

                        Fruit:            Banana             Watermelon     Cherry

                        Color:            Yellow             Green             Red

Task Four:  Opening Table

• Close the form and then open the table again.  

• Observe that the records you added to the form have already been added to the table.  There is no need to add them again.

Task Five:  Print Results

• Print out the table version and hand it on to your instructor.

|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 

• Open up StudentProject5.mdb from the Student Files folder. 

• Sort Parent Names in ascending order.

 Task Two: Deleting records

• Delete Parent Contact Field.

• Delete Mr. & Mrs. Jensen record.

 Task Three: Changing Information

• Change City of Mr. & Mrs. Hjanmiba from Butare to Ruhengeri.

• Change Phone Number of Mr. & Mrs. Ghandara to (250) 75813.

 Task Four: Report Wizard

• Go under objects and select the Reports button.
• Double click the Create Report by using wizard icon.
• Include all the fields listed in the Available Fields scroll down list by using the arrows on the right hand side of the list.
• Click the Next button two more times.
• Under the "What sort of order do you want for your records?", pull down the drop-down menu next to number 1 and click on ParentNames. Make sure the order is ascending. You can check the sorting order by referring to the button next to the drop-down list. The button should have a letter A on top of a letter Z with an arrow pointing down.
• Click the Next button. Under layout select columnar. Refer to the image below for reference:

• Click the Next button and select Corporate as the style of the report.
• Click the Next button again and name the report as Parent Contact List.
• Print and submit to your teacher. Your report should look as the following:

 |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

• Start up Microsoft Access and open the StudentProject6.mdb. NOTE: Go to Student Projects folder, then open Student Files.

Task Two: Record Deleting

• Delete the record for Joe Smith. Click on the delete record button ().

Task Three: Record Change

• Change Laura Mason's grade to a C.
• Change Stephanie Myer's major to Pre-Med.
• Change Maggie Henson's grade to a B.

Task Four: Replace Command

• Use the replace command to change all "Journalism" majors to "Business" majors.

Task Five: Printing a Report

• Print a Student Report showing the changes made to the information in the Students table. Do this by clicking the Reports button in the Student Database dialog box, which is located under Tables.
• Select the Students report file. Include all fields, and continually click the next button until Report Wizard is finished.
• Submit the report to your instructor. 

|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

• Start a new database and open the Table Wizard. Refer to the image below for reference. 

Task Two: Table Wizard

• In the far left scroll down box, select the Employees sample table.

• In the middle scroll down box, select the Sample Fields: EmployeeID, Last Name, First Name, and Title. Refer to the image below for reference.

• Highlight the Title field name in the far right box and underneath the box, click on the button Rename Field. 

• Rename Title field to Salary (in RWF). NOTE: RWF stands for Rwanda Franc.

• Click Next. In the textbox, name the table Employees. Allow the program to automatically set the primary key for you. Click Next.

• Make sure that the option for "Enter data directly into table" is selected. Click the Finish button.

Task Three: Entering information

• Enter the following information into the Table under the correct fields. 

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

• Save the Table.  Print it and hand it to your instructor

|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

•  Open Microsoft Access and open the database StudentProject8.mdb.  NOTE: Go to Student Projects folder, then open Student Files. There will be one table already created named “contacts”.

 Task Two: Starting Query

•   Click on Query option and choose create query using wizard.   

Task Three: Selecting Fields  

• Select all fields available by clicking the top arrow button and then click next.  Name your Query Contacts Query and then choose modify the query design.  Click finish and you will see the followings screen:

Task Four: Sorting

• You would like to receive your results in alphabetical order by last name.  To receive your results like this, click on the cell where Sort and Last Name intersect.  Pull down the menu and choose ascending.

Task Five: Editing

•   Go to the Relation column and intersect it with the Criteria row. Type "Classmate".  Be sure to include the quotation marks. 

Task Six: Closing Document 

• Close the document and then re-open it. If the program wishes you to save then click on YES. Your contacts that are classmates have been sorted out.

Task Seven: Present Results

• Print the query and turn it in to your instructor.

|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

• Open up Microsoft Access
• In the open dialog box, select the option for making a new database or go to File menu and then select New. Make sure you name your database with your first and last name.
• In your database dialogue box, make sure that the Table option is selected.
• There are three ways to make a table and they are listed on the right hand side of your database dialogue box. Select Create Table by using Wizard by double-clicking the () icon.

Task Two: Creating Field Names

• The first step is to create field names. However, before doing this, refer to the image below to familiarize over Wizard view.

• The first scroll down list is Sample Tables. In this scroll down list, select Mailing List.
• The second scroll down list is entitled Sample fields. Go ahead and click on First Name, Last Name, Title, and Organization Name by selecting each one and then using the arrows to the right of the Sample fields pull down menu to have the sample field names appear on the far right scroll down list. The far right scroll down list is called Fields in my new table.
• Select one of each sample field name in the Fields in my new table scroll down menu and click on the Rename button. Rename the sample field into the following names:

           NOTE: Rename the Sample Field 'Title' first!

• Refer to the following image below for reference:

Task Three: Table Wizard Steps

• Click the Next button and name the table Book Inventory.

• Under the question "Do you want the wizard to set the primary key for you?", click the answer No. You will be setting the primary key.

• Click the Next button. In the drop down box, make sure Title is selected so that it holds the unique files for your table.

• Refer to the following image for reference.

Task Four: Entering Records

• Click the Next button. Under the question "After the wizard creates the table, what do you want to do?", select the option "Enter data directly into the table". Click the Finish button.

• In the Datasheet view, highlight Title column, then click and drag the mouse to widen the column. Do the same for the Publisher column.

• Go to Microsoft Word and open up StudentProject9.doc (NOTE: Go to Student Projects folder, then open Student Files.) and manually enter the information listed in the word document. 

• Print the table and hand to the instructor.

|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

• Open Microsoft Access and open StudentProject10.mdb database file. NOTE: Go to Student Projects folder, then open Student Files.

 Task Two: Filtering

• Use Filter by form to find the grades below 80 (Hint: <80)

 Task Three: Sorting

• In the filtered table, sort the “Average” Field in descending order (lowest grade to highest grade).

 Task Four: Print Report 

• Print a report showing the results of the preceding tasks.

 Task Five: Filtering 

• Filter by form for grades above 80 (Hint: >80)

 Task Six: Sorting 

• Sort “Average” Field in descending order (lowest grade to highest grade).

 Task Seven: Print Report

•  Print a report showing results of the preceding tasks

 Task Eight: Submit

•  Turn in both printed reports to your instructor

 |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

• Open the StudentProject11.mdb database (NOTE: Go to Student Projects folder, then open Student Files.) and then open the African Countries and Information Table. 

Task Two: Entering Rwanda

• Add Rwanda to the table, along with the following information about it.

Task Three: Find and Replace

• Find Lagos and replace it with Abuja, then find Laayoune and replace it with no capital.

Task Four: Sorting

• First sort the populations in descending order and print out the 15 most populated countries in Africa. Refer to the image below to see what countries that need to be selected: 

Task Five: Sorting Pt. 2

• Sort the Area of the Countries in ascending order and print out the 15 countries with the smallest area. Again refer to the image below for reference:

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

• Open up Microsoft Access. Locate the StudentProject12.mdb file. NOTE: Locate the Student Project folder and open it to find Student Project Files.  

• Click the Forms option and select Create a Form using wizard.

Task Two: Choosing Fields

• Choose the fields you would like to include in this form.  For this form choose Address ID, First Name, last name and children’s names.  Add each field by clicking on top arrow.

Task Three: Deleting Fields

• You realize that for this form you do not want children’s names listed.  Delete this field by clicking the third arrow down.  Click Next to proceed making a form. 

Task Four: Choosing a Layout

•  Next you must choose a layout.  Use columnar for this form and click next. Refer to the image below for reference:

Task Five: Choosing Style

•  Choose a style.  For this task, choose Ricepaper, then click next.

Task Six: Naming the Form

• Finally, the form must be named.  Since this is the first form with this database, keep the name Addresses. 

Task Seven: Entering Information

• Open the form and see what it looks like.  Save all your work and submit it to your professor.

 |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

• Locate and open up the StudentProject13.mdb file. NOTE: Go to Student Projects folder, then open Student Files.  
• Pull down the Tools menu and click the Relationships command to open the Relationships window.
• Pull down the Relationships menu and click the Show Table Command to show the Show Table dialog box. Refer to the image below for reference.

• Select the Employees table and click the Add button to include the table to the Relationships window. Do the same for Titles table.
• Close the Show Table dialogue box.

Task Two: Creating Relationships

• Click and drag the Titles field under Employees table field list to the Titles field in the Titles table field list.
• The Edit Relationships dialog box will pop up. Check the box that says "Enforce Referential Integrity".
• Click create in the Edit Relationships dialog box to create the relationship.
• Click the save button on the relationship toolbar to save the ().

Task Three: Filtering Clerks

•  Use Filter by Form to identify all the clerks.

Task Four: Making Report

• Make a report using Report Wizard that shows all the clerks and their performance level.
• Make the report in landscape form.
• Save the file and turn the disk into the instructor.

|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

• Open Microsoft Access and open the database StudentProject14.mdb. NOTE: Go to Student Projects folder, then open Student Files.

• Refer to the following image to locate the Form located in this database.

Task Two: Changing Font

• Change the font of all records in each field to Times New Roman by placing the cursor in any record below a field and pulling down the font menu.  

• Choose Times New Roman.  This will change all records.

Task Three: Editing Form

• Lisa is no longer a student and you must delete here record.  Open her record, go to edit and delete record.  

• Click yes when it asks if you are sure.  You can also delete a record by clicking the delete record button on the toolbar.

Task Four: Changing Background

•  You want the major field to stand out so you change the background print color.  Change the background color to blue and text color to white by pulling down the fill and font color menus on the toolbar. Refer to the image below for reference.

Task Five: Find and Replace

•  Replace Science with Biology by pulling down the edit menu and choosing replace.  A window will appear that  will ask you what to find what to replace with. Refer to the image below:  

• Observe the Form, save, and hand to your instructor.

 |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

•    Start Microsoft Access by going to the Start button and pulling up the menu. 

•    Once Access is opened go to Blank Access Document and click on create table with design view.

Task Two: Beginning Table 

•      Begin creating your table.  Name the first field Product ID.  Tab over to Data type and pull down the menu.  Choose numerical.  Tab through description until you get to field 2.  Name this field “Product Name” and choose text as data type.  Tab through description again and create a third field named Price and choose currency as data type.

•      Click in the Product ID field, then pull down the Edit menu and click on Primary Key. NOTE: Every table has a primary key! Refer to the image below for reference.

 Task Three: Saving Table 

• Go to File and pull down the menu.  Go to save as and save your table as YourNametable1.mdb.

 Task Four: Datasheet View 

• Go to View on the menu bar, pull down the menu bar, and choose datasheet view.   This will now give you the screen that you are probably more familiar with.

 Task Five: Creating Table

• Create the names of any ten products and enter in the information for them.

 Task Six: Sorting by Price

• Sort the products ascending by price by going to Records on the menu bar and then select sort ascending.

 Task Seven: Save File

• Save your table and hand it in to your instructor.

|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. 

• Find the Excel document entitled StudentProject16.xls or use a class roster given by your instructor. NOTE: Go to Student Projects folder, then open Student Files.
• Open Access and make a new database. Call it LectureClassDatabase.mdb.

Task Two: Creating a Table

• Make a table. Correspond the sectioned columns from the Excel document to field names in Access.

                Example:

• Open up the required amount of records to match the number of students (i.e., 20 students = 20 records).
• Enter data from the Excel spreadsheet to the new table in Access
• Save.

Task Three: Making Reports

• The professor wants a list of students who are:

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

• Sort the students according to last name. The arrangement of columns should be as follow:

• Save and print the lists.

Task Four: Preparing the Material for Submission 

• Make a cover sheet in Word. Make a title for the project (Ex: Student Lists).
• Put the name of the professor on the title page and the subject taught.
• Put your name in the lower-right hand corner and the date.
• Print the cover page, add it to the printed lists, place in a folder, and submit to the instructor.

|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

• Open access and open database named StudentProject17.mdb. NOTE: Go to Student Projects folder, then open Student Files.

Task Two: Open Website

• Go to http://www.ird.ne/irdam/universite/.

• Fill in the City/Province column and the Telephone Number column in the database from the information found on the website.

Task Three: Insert column

• Insert a special Hyperlink column to the database and name it “Web Address”. You insert columns by going into Datasheet view and then pulling down the Insert menu and then clicking the Column command.       

• Enter the websites for all the universities/colleges listed in database.

 Task Four: Adding Records

• Your professor wants to add four universities to the database. Your group needs to enter all information for each university.

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

• List the “University/College” column in alphabetical order.

• Save it to floppy disk

Task Six: Filtering

• Using  Filtering by form, make a list of all the institutions in Cameroon

• Save the Report and print it. Refer to the image below for reference.

 Task Seven: Filter by Form Pt. 2

• Using Filtering by Form, make a list of all the institutions in the Eastern Africa region.

• Save it as a report and print it. Refer to the image below for reference.

Task Eight: Filter by Form Pt. 3

• Using Filtering by Form, Make a list of all the institutions in the Central Africa region.

• Save it as a Report and print it. Refer to the image below for reference.

 Task Nine: Save and Present work

• Save the completed database on a Floppy disk. Submit the disk and the three printed reports to your instructor.

|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

•  Open Microsoft Access and select Blank Access Database.  Name your file “Clothing Store” and then click on Create.

Task Two: Creating Table 1

• Create your first table using the same fields and data as the following table. Name the table “Product Units”. Refer to the image below.

Task Three: Creating Table 2

•   Create a second table using the same fields and data as the following table.  Name the table “Products”. Again refer to the image below for reference:

Task Four: Creating a Form

• Create a form using all fields from both tables.  Choose the columnar and standard settings. 

Task Four: Entering Data

• Enter a new record with the following data:                     

• Access will automatically add the data to the appropriate table. Once you have completed the new record, close the form.

Task Five: Creating a Query

• Next you will create a query to find all the products that are male oriented.  Go to Query mode and create query using the wizard.  Use all fields from the “Product Units” table and all fields from the “Products” table. However, for the "Products" table, include all fields except Product ID and Product Name. 

• Choose the detailed setting and name your query “Male Clothing”.  Then select modify design. 

• In the cell where Criteria and Gender intersect, type “Male” and be sure to include the quotation marks. 

• Close the query and save changes to the design.  You will now have a new list that contains only the male clothing.

  Task Six: Creating Report

• Now you will create a report to neatly display the information.  Click on the report option on the left hand side of the database dialog box. 

• Create your report using the wizard and use the product query to make your report.  Include all fields except for gender. 

• Create a grouping level for product ID, product description, product name and season, respectively

• Sort by Unit Price (cheapest to highest price) and use Outline 1 as your layout.  Choose a corporate style and name it Male Clothing Items. 

 Task Seven: Printing Results

•  Print out information and turn it into your instructor.

 |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

• Open Microsoft Access and open a blank database.

Task Two: 

• Select “Create table by using wizard”         

• Choose the “Business” option

• Choose “Employees” under sample tables

• Choose these sample fields: Department Name, First Name, Middle Name, Last Name,            Email Name, and Title

Task Three: Renaming Fields

• Add “Office Location” to new table and rename it “Department Location”

• Change “Email Name” to “Department Email”

Task Four: Table Names and Primary Keys

• Name table “Management Department Employees” and set Primary Key

Task Five: Changing Data type

• Open “Management Department Employees” table

• For “Title Field”:

Task Six: Form Wizard

• Create form by wizard using the “Management Department Employees” Table

• Select all fields

• Choose a Columnar layout with International style

• Name the Form "Management Department Employees".

Task Seven: Completing Table

• Enter the following names into the form:

Task Eight: Finishing Off

• Enter information into related fields in form.

• Department Location: B.P. 117, Butare.

• Department Phone: 250 530330

• E-mail: sesg@nur.ac.rw

Task Nine: Report Wizard

• Create a report for “Management Department Employees” using wizard

• Make sure all fields are shown

• Make a columnar Report with a casual style

Task Ten: Submission

• Save the database to a floppy and label it “Management Department” along with your name.

• Submit to your professor.

 |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

• Launch Microsoft Access and select blank database
• Title the new database BabyNames.mdb.

Task Two: Research

• Go to any baby name website and research under French baby names
• Collect ten French baby girl names and their meanings.
• Collect ten French baby boy names and their meanings.
• NOTE: You may go here for reference.

Task Three: Making a Table

• Make a table for boy names and their meanings (must have two fields).
• Make another table for girl names.
• Title each table according to the gender it represents (i.e. French Male Names, etc..)

Task Four: Sorting

• Sort the names on each table in ascending order.

Task Five: Creating a Report

• Make a report for the girl names
• Make a report for the boy names
• Print each table for submission

Task Six: Creating Two Reports in One

• Combine the male names and female names into one table (Hint: new table then copy and paste).
• Name the new table French Baby Names.
• Make a report for the French Baby Names table. (NOTE: The names must be listed in alphabetical order).
• Print report and submit to instructor.

|Back to the top|

Return to Main Page