CLAIT (level 1): Database Manipulation

Exercise 1. Products Provided by David G Edwards

1. Open Microsoft Access

2. Create a new database on your floppy disk. Give it the name PRODUCTS

3. Create a new table with the following fields

NAME

TOWN

ACCOUNT

PRODUCT

4. Save the table with the filename Paper

5. Enter the data below into the table Paper

NAME	TOWN	ACCOUNT	PRODUCT
ALUMINA LTD	WIDNES	246831	ENVELOPES
SPRIGGS & GRIM	SOUTHPORT	501885	BOARD
BREEZE TRADING	RAMSEY	598357	CUT PAPER
LITHO SUPPLIES	MAGHULL	583819	ENVELOPES
AUSER PACKAGING	ST. HELENS	809365	CUT PAPER

6. Make sure all the data is saved and print a copy of the table

7. Add the following record to the table

ALFRED PRATT

WIGAN

4855758

ENVELOPES

8. Delete the record of LITHO SUPPLIES from the table

9. Make the following changes to the table

The ACCOUNT No of ALUMINA LTD has changed to 473587

BREEZE TRADING has moved to SOUTHPORT

10. In the table sort the data by NAME into alphabetical order

11. Print a copy of the table Paper

12. Create a query to show all the data for those customers who require ENVELOPES

13. Save the query as Envelopes and print a copy

14. Close the database making sure all files are saved securely