Creating a Math Vocabulary Database
Open Microsoft Access
Click on Blank Database on the right task pane
Name your file, Math Vocabulary with your initials and save in My Documents
Click on Table under Objects bar
- Click on Create Table in Design view
- Click on first cell under Field Name and type Term
- Tab over and select Text
- Close the table and answer Yes to Save
- Name the table Terms and press OK
- When it asks to create a primary key say, NO
Open the Terms table to enter your vocabulary words
- Type one at a time and click Enter
- Close the table when you are finished
- Answer Yes to Save
Click on Table under Objects bar
- Click on Create Table in Design view
- Click on first cell under Field Name and type Term
- Tab over and select Lookup Wizard…
- Choose “I want the lookup column to look up the values in a table or query” and click Next
- Choose Tables and the Terms table and click Next
- Move Terms to the right with the arrow > and click Next
- Adjust the column width if necessary, clickNext and Finish
- When it asks if you want to save say Yes
- Name the table Math Vocabulary
- When it asks to create a primary key say, NO
- Enter Definition as the next Field Name
- Tab over and select Memo
- Enter Example as the next Field Name
- Tab over and select Memo
- Enter Hyperlink as the next Field Name
- Tab over and select Hyperlink
- Close the table and say Yes to Save
Click on Table under Objects bar
- Highlight Math Vocabulary table
- Click on Forms under the Objects bar
- Click on Create form by using wizard
- Use the double arrow to select all fields and click Next
- Select Columnar and Next
- Choose the style you would like and Next
- Select Open the form… and Finish
Begin entering all of your information
- Click the right arrow to go to the next record
- Continue until you have finished all of your vocabulary words
Click on Table under Objects bar
- Highlight Math Vocabulary
- Click on Report under Objects bar
- Select Create report by using wizard
- Click the double arrows to select all fields and click Next
- Click Next to grouping levels
- Click Next to sorting
- Select Columnar and Portrait and Next
- Choose the style you would like and Next
- Select Preview the report and Finish
- Print your report