Database Exercise 1

1. Run OpenOffice
2. Click on Database
3. Select "create a new database"
   Name it "Banking"
   Click on "Next"
4. Register the database
5. Select "Open the database for editing" then "Create tables using the table wizard"
6. Click "Finish"
7. In the "Table wizard" select "Business"
8. Select "Transactions" under "Sample Tables"
9. Select the following fields: TransactionNumber, Date, Description, WithdrawlAmount,
   DepositAmount, and Notes. Click on "Next".
10. Make the TransactionNumber, Date, and Description fields, "Entry Required"
11. Use the TransactionNumber field as the primary key field. Click "Next".
12. Name the table "Bank Transactions". Click on "Create a form based on this table". Click "Finish".
13. When the form wizard appears move all of the fields to the form. Click "Next".
14. No sub form is required. Click "Next".
15. Click on "Columnar - Labels Left" and "Right Align". Click on "Next"
16. The form will be used to view all data. Click "Next".
17. Select "Grey" color and 3D look. Click "Next".
18. The name of the form should be "Bank Transaction Entry" and select "Work with the Form". Click "Finish".
19. 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.