Database Exercise 1
- Run OpenOffice
- Click on Database
- Select "create a new database"
Name it "Banking"
Click on "Next"
- Register the database
- Select "Open the database for editing" then "Create tables using the table wizard"
- Click "Finish"
- In the "Table wizard" select "Business"
- Select "Transactions" under "Sample Tables"
- Select the following fields: TransactionNumber, Date, Description, WithdrawlAmount,
DepositAmount, and Notes. Click on "Next".
- Make the TransactionNumber, Date, and Description fields, "Entry Required"
- Use the TransactionNumber field as the primary key field. Click "Next".
- Name the table "Bank Transactions". Click on "Create a form based on this table". Click "Finish".
- When the form wizard appears move all of the fields to the form. Click "Next".
- No sub form is required. Click "Next".
- Click on "Columnar - Labels Left" and "Right Align". Click on "Next"
- The form will be used to view all data. Click "Next".
- Select "Grey" color and 3D look. Click "Next".
- The name of the form should be "Bank Transaction Entry" and select "Work with the Form". Click "Finish".
- Enter the following data:
Transact. Numb. | Date | Description | Withdrawal Amt. | Deposit Amt. | Notes |
10025 | 2/28/2015 | Pay Check | | 4357.00 | |
1402 | 3/1/2015 | Rent | 1025.00 | | |
1403 | 3/4/2015 | Vons | 65.50 | | For party Saturday |
1404 | 3/4/2015 | SDG&E | 73.31 | | |
1405 | 3/6/2015 | Water & Sewer | 100.00 | | |
1406 | 3/6/2015 | Master Card | 75.76 | | |
1407 | 3/10/2015 | Vic's Auto | 732.71 | | Fix transmission |
10026 | 3/10/2015 | Overtime Check | | 583.25 | |
1408 | 3/15/2015 | Union Dues | 156.61 | | |
1409 | 3/21/2015 | Visa Card | 271.97 | | I need to pay this off. |
This database will be the first attachment to your submission.