mga boss baka may gumagamit sainyo ng ms access dko kasi alam kung paano ma deduct yung transaction table sa fruit quantity table dko magets yung instructions ng instructor namin ala,m ko na po yung mga add button ang hindi ko ma gets yung number 5 6 7 sana matulungan nyo po ako begginner palang po kasi akong gumamit ng MS access
..
Ito po yung task nya
ASKS
1. Create a Microsoft Access Database
2. Create four Tables with following configurations:
a. First Table: Name it as Customer = Add five columns here about the customer.
b. Second Table: Name it as Dates = Add three any columns here about the dates of the
customer’s transaction.
c. Third Table: Name it as Fruit Quantity: Add column for Orange, Grape, Banana, Apple and
Watermelon. This will store the quantity for each fruit.
d. Fourth Table: Name it as Transaction, create a field name for the following: Deduction for
Oranges, Deduction for Grapes, Deduction for Bananas, Deduction for Apples, and Deduction
for Watermelons.
3. Create two forms based on the four tables from Tasks No. 2.
4. The form must have the following buttons:
a. “Save”, This will save the data inputted.
b. “Delete” This will remove the saved data.
c. “>” To view the next record.
d. “<” To view the previous record.
e. “Next Form” This will jump to different form
f. “Previous Form” This will jump to previous form.
5. Tables must have relationships especially for customers to know their fruit orders/transaction.
6. Design the forms attractively.
7. The Customer table can order fruits using transaction table. The number of fruits will be deducted to
the table three and save the date details to the table two
..
Ito po yung task nya
ASKS
1. Create a Microsoft Access Database
2. Create four Tables with following configurations:
a. First Table: Name it as Customer = Add five columns here about the customer.
b. Second Table: Name it as Dates = Add three any columns here about the dates of the
customer’s transaction.
c. Third Table: Name it as Fruit Quantity: Add column for Orange, Grape, Banana, Apple and
Watermelon. This will store the quantity for each fruit.
d. Fourth Table: Name it as Transaction, create a field name for the following: Deduction for
Oranges, Deduction for Grapes, Deduction for Bananas, Deduction for Apples, and Deduction
for Watermelons.
3. Create two forms based on the four tables from Tasks No. 2.
4. The form must have the following buttons:
a. “Save”, This will save the data inputted.
b. “Delete” This will remove the saved data.
c. “>” To view the next record.
d. “<” To view the previous record.
e. “Next Form” This will jump to different form
f. “Previous Form” This will jump to previous form.
5. Tables must have relationships especially for customers to know their fruit orders/transaction.
6. Design the forms attractively.
7. The Customer table can order fruits using transaction table. The number of fruits will be deducted to
the table three and save the date details to the table two