Can someone help me? =)

[xoxoAllyCat]

I am trying to complete this but I can only get up to 1 query and then everything erases.....
I never used Access before....thank you =)



Product
Name
Product
Number

Taxable
Amount
Purchased
Purchase Price
Amount
Sold
Selling Price

Revenue

Expense

Profit
Sales
Tax

Pizza XA-124-Q No 128 $5.25 92 $10.50
Potato Chips TN-258-Z No 1,024 $1.79 833 $3.58
Soda PG-909-B Yes 512 $2.78 476 $5.56
Ice Cream KR-762-A No 256 $1.99 239 $3.98





Create the following select queries:
1. A listing of the Products in Name order with their Selling Price.
2. A listing of Product Numbers that are not Taxable.
3. A listing of the Products where the Amount Purchased is not greater than 500.

 

[Mihail]

Welcome to the forum !

The first and main help for you is to read... until you will understand this article.
Of course that are more other articles. Do a search on Google. Key: Databases Normalization.
After you will understand at least 1NF, come back and post your DB here.

 

[Joe8915]

I wonder if this is for a class?