|
|
 |
 |
 |
Directions: Open Access (Go to
start, programs,
Microsoft Access).
When the dialog box opens, choose blank access database then OK.
Another dialog box will open. On the file name line, type Presidents
(replacing db1), choose your folder to save it to, then click on create. You will then be given several
options to choose from. Choose
Create
table in Design View.
If prompted to assign a primary key,
choose no because the presidential number will be the primary key in this
table. Type the following information in the Table under its appropriate
column. To set your field size, click on data type and box
will appear at the bottom of your field box. The field size is automatically
set at 50. Reset the size according to the field length given in
the chart below. The numeric field length is already set. You
just need to set the length on the text field lengths.
|
|
|
|
|
| Presidential # |
|
number | Presidential order |
| Last Name |
|
text | Last name of President |
| First Name |
|
text | First name of President |
| Party |
|
text | Presidents Party Affiliation |
| Nickname |
|
text | Nickname of President |
| Date of Birth |
|
date | Date President was born |
| Date of Death |
|
date | Date of Presidents death |
| Term in Office |
|
text | Date President was elected |
| Decade |
|
text | Decade of Presidential term |
| Other Positions |
|
text | Other positions held before Presidency |
| Major Accomplishments |
|
text | Major Accomplishments made during his lifetime |
| Picture |
|
OLE object | Picture of President |
| Wars During Office |
|
text | Wars fought during term in office if any. Write none if there was not a war fought during this time. |
Now you have your table set up. Save your file as Presidential Information. Close your table. Your primary key will be presidential number so you will not need to name it. It is automatically named as your first field entry name. After saving it, close the table.
Now you will design a Form for entering information into the table. In the Database window, click Forms in the Objects Column, then double click on Create Form Using Wizard. Select all of the fields by clicking the button with two arrows. You will see that all the fields automatically appear in the left column. Click next. Select the column layout, click next, then standard, then click next. Title your form Presidents of the United States. Click Modify the forms design radio button, then click finish. The form will appear in design view.
To prevent images you imported into the database from being clipped or distorted, select the picture field by clicking on it, then select Properties from the View menu. Select the All tab, click in the Size Mode Field and select Zoom from the drop down list. Close the property window.
Make any other changes you would like to the form in Design view, either by selecting and dragging objects to display fields words or by dragging objects to different locations. To drag objects, you must select them (you will see a small hand appear which when clicked on will move the object on the page).
Save then close the database. Now you can create records for each president. Double click on your form tab titled Presidents of the United States, then begin entering your information that is found on the following web pages.
While you can enter your text
information with no problem, inserting the picture into the form is a little
different. In order to enter a picture into your form, right
click on the blue border
at the top of the record, then choose form
design. Click in
the picture box
and a toolbox will appear. Click the button
that looks like two mountains
with the moon behind it (this is the insert image button), then click in
the picture box again.
This will open a dialog
box where you will go
to find the picture you want to insert into the document. Navigate
to the folder where you picture can be found and click
on the picture.
It will then be imported into your record. To return to form view
to enter text items, right
click on the blue border at the top of the record and
choose design view.
You are now returned to your form to enter
text information.
Remember, you must import your picture in a different view!!!!
Education Planet Presidents Page
Presidents of the United States
Portraits of the President and First Lady
Assignment 2:
Click on the worksheet below and save it to your folder. You will now generate queries to answer the questions on this worksheet.
A query is a set of criteria you specify to retrieve certain data from a database. You will be graded not only on your answered worksheet, but on your saved queries as well.
To create a query, open your presidential table. Drop down the new object menu and choose new query. Choose design view, then click OK. Choose the field you wish to find information about (you can double click the fields and it will automatically fill in the field for you). To move to another field box you can either click in it with your mouse or tab over. We will go step by step through several questions in order for you to get a better understanding of how to input information in order to get answers back from your stored data. For the first question, how many republican presidents were there, name them, you need to look at the fields first name, last name, and party. Choose these three fields by clicking in the field cell and dropping down the menu with the list of field names and highlight it. You will have three fields you need for your query, one in each column. Under the Party field, locate the criteria cell. Click inside the criterian cell and type the word Republican. Next, to see the results of your search, click on the exclamation mark on your standard toolbar and the query results for all Republican Presidents will be listed. Name this query Republican Presidents. Answer the rest of the presidential questions using the following criteria:
Every question will have a query and should be saved and named as indicated in each questions. You will be graded for each one.
Inserting calculations can be burdensome, however, with the build button (the one that looks like a magic wand), it can be a snap. After inserting all your fields, when calculations need to be made, all you do is click in the criteria cell under the field, then click the build button, and type or choose the calculations needed to get your end result.
Criteria Guidelines:
Is Null-diplays data that is left blank. Example, if you did not enter data in the date of death field, you are saying that the president is still alive.
The sign > means greater than.
The sign < means less than.
The sign = means equal to.
Not operator-Not T* will find all data in that field whose names don't begin with T, or Not 2 will find data whose ID isn/t 2.
Or operator-displays data in either of the two fields. "London" or "Hedge End."
#2/2/95#-displays data only on that day.
In operator-displays data in that particular circumstance. In("Canada", "UK")
Like operator-Like "S*"recognizes data whose name starts with the letter S. The * is a called a wild card in a query.