Presentation Transcript

1. ABC Stationery Supplies

   Database Revision 1 Field names/data types Importing data Complex queries Exporting data

2. Task 1

   You work for a shop selling office and school supplies. Import Stationery.csv and assign the following data types (and sensible names) to the fields:

3. Task 2

   Add the following records:

4. Task 3

   Create a report called “House colors” which shows: All the items which are NOT folders Which have “A4” in the description Which sell for £45 or less And are either blue, red, green or yellow

5. Task 4

   Export your data from Task 3 in a format which can be used in a spreadsheet package. Export it also in a format which can be used in a word processing package.

6. Task 5

   Create labels for all the stationery items that attract a discount. Labels should fit 3 to a row, and include the following labels, picture and data: Description Color Selling Price Your name, centre number and candidate number should be at the bottom of each label