Database Inquiring and Analyzing

Scenarios:

The Music shop at Mall of the Emirates is struggling to keep track of purchases and customers are taking advantage of that fact and claiming refunds to take more money. I have been approached by the music shop to create a easy and efficient way to organise their records. I have decided that Microsoft Access is the best way to make organised records that can be easily inputed.

Planning:

My Customer is the shop Brooklyn Melodies and he wants an efficient way to maintain sales and organise all of the amounts bought and sold. I have come to the conclusion that the best way to solve this is to use Microsoft Access to maintain the records. The database will be used to track purchases of certain products and to make sure that customers get their product. The cashier will use the database to update it constantly but the administrator will use it to make sure that all products are organised and keep track of all movements. There will be many limits to this project, the skills required to create and use the databases effectively. This will require research into the more complex tools that Microsoft Access has to offer.

Research:

1.) A database is a series of records who's categories are separated into fields. Each record contains information about the product mentioned in it separated into different pieces of information including, date of production, price etc, these are called fields. The databases make it easier for people to organise and locate records and information about certain products.

2.) Using Microsoft Access we can create a Database, the program allows for easy inputting of Data into a data entry form which acts as the interface between the human inputting data and the program's tables. Microsoft Access is a easily navigable interface that allows for ease of use, and makes it easier for people who are not as technologically inclined to create databases. This will make it easier for the store to use and utilise the full potential of it.

3.) It helps my customers keep records as it allows for ease of data input and is an efficient way to store information as it is retrievable.

4.) It also allows the customer to search or query for any set of records by using specific criteria.

5.)  The manual way of keeping records involves using files in a filing cabinet that have to be labelled in order to be easily found.

After the initial complex setup, the level of computing skills is minimal as the data entry forms are quite straightforward.