I need help with an intro assignment. The details are as follows. I need to maintain a payment database.
1.
2. Using Access and open the Payments database located in the file named Ebony.
3. Create a table named Payment using the table design shown in Figure 1 (Hint: Make sure that you include spaces between components of the custom format for the Date Paid field.)
4. Add the payment records shown in Figure 2 to the Payment table.
5. Modify the structure of the Payment table by completing the following:
*
* Modify the structure of the Payment table by completing the following:
a.) Field Name: Deposit#
b.) Data Type: Text
c.) Field Size: 3
6. Move the DatePaid field so that it follows the AmtPaid field.
*
* Use the Payment datasheet
to update the database as follows:
Enter these Deposit# values for the three records:
a.) 101 for Payment# 10002
b.) 102 for Payment# 10015
c.) 103 for Payment# 10031
* Add a record to the Payment datasheet with these field values:
a.) Payment#: 10105
b.) Deposit#: 117
c.) Firm#: 1103
d.) AmtPaid: 1750.00
e.) DatePaid: 06/20/2001
7. I created a database named PlusPays that contains recent payments in the Payment Records table. The Payment table you created has the same format as the Payment Records table. Copy all the records from the Payment Records table in the PlusPays database (located in the Ebony file to the end of your Payment table.
resize datasheet columns to fit the data, and then resize all columns in the datasheet for the Payment table.
8. For Payment# 10002, change the AmtPaid value to 1300.00.
9. Delete the record for Payment# 10096.
10. Take a screen shot of the first page of data from the Payment table datasheet, and then save and close the table. The screen shot should be in a word document.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
This has to be done with access.