Information and Communical technology

Authors Avatar

Page  of

IDENTIFY

INTRODUCTION

 Pineforyou is a company which produces pine furniture. The company was established in 1997. During this time the company has been become very successful. The company has decided to move into a larger building because of the increase in number of customers.  

Who is the “real” user?

The real user of my database in the company will be the sales department of the company.

What is the current problem?

The sales department has to hand write the letters to each of the customers individually which takes too much time. A salesman is responsible for all sales activities in assigned accounts or regions. He manages the quality and consistency of product and service delivery.

Why has this problem arisen?

Due to the company’s products becoming very popular, the number of customers has increased putting added workloads on to the staff

What is the objective or user requirement for this project?

        

  • Create a database by using Microsoft Access
  • Fill in the database with field name and data type and also set up the field size for each of the fields.
  • Create in the database two tables and input one of the tables showing the customers surname and in the other the customers address
  • Create a query such as searching for the surname, Last Purchased Date of the customer
  • Create a report for male customer who have spent more than £1000 and Customers who have bought something from the company during the last year and detailing the results of the query in a report, which will show the result of the query in a specific layout.

  • Use a validation for gender(male=M, F=female) This is because it makes the data more  accurate and quick because the staff need just to press one letter.
  • Use an input mask for the date to make data more accurate.

  • Find the details of the surname “Vandber”
  • Set up a primary key in the Customer ID in both table
  • Create a relationship between these two tables
  • Forms are more efficient method to use to input data. This is because you can design the form to look anyway you want.
Join now!

  • Include an icon to enable user to delete the customer
  • Produce a mail merge letter

What are the different ways this problem could be solved?

  • Use a database
  • Use spreadsheet
  • Use paper based system
  • Use word processing application

What is the best way to solve the problem and why?

The best way to solve the problem is by using a database. A database is made up of one or more related files. Data from the company can be ordered in tables. In ...

This is a preview of the whole essay