• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

VHD tools. The VHD tools database was constructed to aid the staff in their daily duties. Before the database, all operations such as invoices and receipts were carried out manually. With the introduction of this database, receipts and invoices are printe

Extracts from this document...

Introduction

VHD TOOLS Database created using Microsoft Access 2003 1. Purpose of VHD Tools The VHD tools database was constructed to aid the staff in their daily duties. Before the database, all operations such as invoices and receipts were carried out manually. With the introduction of this database, receipts and invoices are printed out automatically with minimum user intervention. In addition to receipts and invoices, the system is able to carry out many tasks. These tasks include tracking customers. So that if a user wishes to find out what products a certain customer has bought or rent in the past, they simply need to enter the unique customer code and all the details would be provided. Stock management is improved with the use of this system. By simply using the user friendly menu, all levels of stock can be shown. This way the user would know whether a certain product is in stock before attempting to sell it. It would also aid the user in deciding what new stock to purchase by reviewing all the items that are low in stock. The system also allows for employee sales to be tracked. Whenever a customer buys or rents an item, the employee that has dealt with that transaction is recorded. This is beneficial so that if the company introduce targets, the system would provide adequate information to support them. If the company wishes to view all the transactions for the past month, by simply executing a simple query, the transactions can be shown. ...read more.

Middle

Availability has been removed from the vehicles table. This was initially a value that determined whether the vehicle was available, but it soon became apparent, that availability is not an attribute, and it is a query. Count: 352 words 6. Difficulties encountered As explained earlier in changes made to part 1, most of the difficulties I encountered were when it came to creating the tables in Access. I noticed that the existing tables were not fully in 3NF form and would therefore lead to an inconsistency in the database. There would be a repetition of data and this is not good for an efficient database since data could be entered twice wrongly. The other main difficulty I had in this project was creating the queries. Unfortunately once I had changed the tables to how I saw fit, they still did not seem right. This only became apparent when I was creating queries. As a result, tables had to be created, fields had to be moved. Because of this, the creation of queries took a long time. This had a knock-on effect on the reports that were created, because of the confusion of the tables. Count: 152 words 7. Queries and Reports This system has more queries than reports. There are a total of eight queries and four reports. The check rent stock query displays all the stock that is available at the present time. ...read more.

Conclusion

The group itself functioned very well, there were people who had different levels of experience using access within the group, from those who had done Access for A-level to those with no experience at all. The group accommodated this, and in our first two meetings there was an emphasis to educate those who did not understand various parts of Access. At the same time those with less proficiency with Access provided some really useful insights as they were able to stand back and take a look at the system as a whole. Within the group there were 3 people, including my self, who had already used Access before. This in itself created debate, and also I think that this created the problems of the first E-R diagram. However, having this level of experience within the group was educational, it challenged my way of doing things and at the same time I was able to learn new things about database construction too. I think I played a key part within the group itself. Although it created problems at times, it was good to have 3 people who had used Access before, and because communication was open within the group it was easy to exchange ideas and thoughts. I was able to generate many ideas and insights, especially because I have seen many company databases, so I knew what type of tables and entities were needed for the project. Count: 515 words ?? ?? ?? ?? Candidate Number: 0322782 Using Microsoft Access 2003 - 1 - ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Marked by a teacher

    An introduction to Identity Theft

    4 star(s)

    a shop, petrol station or a restaurant. This magnetic strip contains information about the card, relevant account(s) and in some cases, its user. A card skimming device is usually attached to a legitimate device or a memory card that can be swapped for the original into it, the information is

  2. Video Rental System

    history for a given employee: update [employee_history] set emp_comp_name=@cmp, emp_strt_dte=@str, emp_end_dte=@end,emp_job_title=@title where [emp_id]=@empid and [emp_line_num]=@lno @cmp @str @end @title @empid @lno Vendor Select select [vend_id] as Id ,[vend_name] as Name ,[vend_cfname] as FirstName ,[vend_clname] as LastName ,[vend_address1] as Address1 ,[vend_address2] as Address2 ,[vend_city] as City ,[vend_state] as State ,[vend_zip] as

  1. Computing Project

    Design Data Dictionary * ER Diagram Member can rent Film has one many times or many copies * Data Dictionary Table: Members Field Name Data Type Length Validation Example Data Comment MemberId String - Must be numeric 4 This is the primary key - Uniquely identifies a member Title

  2. What is transaction processing?

    Information stored in a database can be extracted into other application for example word when creating mailing letter, labels etc, saving a company time have to reproduce documents over and over again. A database can be use for many purposes such as stock control, search for information, customer and personal details etc.

  1. Discuss the relationship that exists in the UK between the legal rules that govern ...

    The Combined Code was published in 1998 by the Hampel Committee, the code covers a range of best practice issues including issues such as the length of directors contracts, reporting and voting on remuneration and the independence of remuneration

  2. Smart Card System

    * Authentication- The sender and receiver can identify each other's identity and the origin or destination of the information. 2.2 DES (Data Encryption Standard) and Implementation DES is the U.S. Government's Data Encryption Standard, a product cipher that operates on 64-bit blocks of data, using a 56-bit key.

  1. System I designed in order to produce a promotion package for her newly formed ...

    These are the customer ID number and the highest entry of the CD. This is therefore a lot easier for the user to access the database. Design Structure 3 This is the best database design structure for the record information out of the lot because the price is in ascending

  2. Computing Project

    The instructor allows 15 minutes after each lesson to do this. Once he has done this he updates his account book by writing down how much the student paid, and what method of payment was used. Once all this is done he heads for the next student, at the end

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work