You are going to create a database of historical figures using the information that you provided and other classmates provide for you.
Phase 1: Collect the data
- You are going to enter information asked for about 25 historical figures.
- They should be important and in the past (in other words, no longer living).
AICT 1 15F Access Final Assignment Information Input FormAICT 1 15F Access Final A...nt Information Input Form
Google SpreadsheetGoogle Spreadsheet
If your data is not showing up in the form above, follow this link.
Phase 2: Prepare the database
- Then you are going to create a database using your information and that of your other classmates.
- Your database will include information on at least 150 people.
- You will need at least five fields based on the ones in the spreadsheet at the bottom of this page.
- One of your fields should be gender. You will need to add this in. Do this using a Lookup Field for male and female.
- Import the information into a table (or two or three as appropriate) in your database.
- Set up a form so that you could enter more data into the database. (You will be asked to demonstrate this form to show that it works.)
- Set up a query to sort out only the people of the same gender as you are sorted out.
Phase 3: Make a report
- Create an attractive, easy to read report that shows the results of your query.
- It should show the first and last names.
- It should show the country these people are associated with.
- It should show only people of the same gender as you.
Evaluation
Collecting Data
|
5 |
Importing Data into Database
|
5 |
Creating a working form
|
5 |
Creating a Lookup field
| 5 |
Generating a query
|
5 |
Create a report
| 5 | Total | 30 |
|