1 / 0

Importing and Managing Stationery Data for ABC Stationery Supplies

In this project, you will engage in data management tasks for ABC Stationery Supplies. Firstly, you will import data from the Stationery.csv file, ensuring correct assignment of data types and meaningful field names for optimal organization. Following the import, complex queries will be constructed to extract valuable insights from the database. Finally, you will learn the process of exporting data for further analysis or reporting purposes. Enhance your data handling skills while supporting a business in the stationery industry.

chill
Download Presentation

Importing and Managing Stationery Data for ABC Stationery Supplies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

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
More Related