We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Visual Basic Project Essay Sample

essay
  • Pages: 2
  • Word count: 448
  • Rewriting Possibility: 99% (excellent)
  • Category: database

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

The menu structure is as follows:

Module design

Visual Basic modules will be used to automate many aspects of data entry and updating of customer records. Complete listings of the code for all buttons, events, etc. in two data entry forms will be given in the hard copy of solution

Entering an order for a new or existing customer (The design is expressed in the pseudocode.)

Security and Integrity of Data

Integrity

Errors in entering the data are reduced by the use of the validation checks on the system, and also by visual verification on the part of the operator before entering the order.

The application will be tested to ensure that errors in the system do not threaten the integrity of the data.

Security

The database file will be password protected to stop an unauthorised user from opening it

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
and making changes.

It is expected that the computer system used to enter the data will be in a physically secure location, and that it may run a secure operating system such as Windows XP which requires a user to log on and which can be used to set access permissions to the database file.

The database saves the data after each change is made so if there was a power failure the file on disc would be up to date as long as it was not corrupt.

To recover from corruption a backup copy of the database could be made during the evening.

The option to delete all the days data is a potential hazard and should have a confirmation step in it and perhaps a password as well.

Test strategy

The test strategy will include four different types of testing as described below.

Logical testing

This will be used to test every aspect of each form, report and query as soon as it is implemented, using valid, invalid and extreme data. Test data will be added to test each code module and results compared with the expected results. The data that will be added initially is shown below. Subsequent tests will often involve adding new data which will then be deleted when the test works satisfactorily.

We can write a custom essay on

Visual Basic Project Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

What is the difference between controlled and...

Controlled redundancy is the state to improve the performance of queries. We want to control redundancy and retrieve the data along with the all the details. By placing all the data together, we do not have to search multiple files to collect this data. In some cases, the DBMS should control this redundancy in order to prohibit inconsistencies among the files. A controlled redundancy is a necessary technique to use redundant fields in a database. When a record showed that is inconsistent with the data file and when the DBMS has no control over this, we have uncontrolled redundancy. An example, of controlled and uncontrolled redundancy, is if you put in a document please enter your name and the input could be numbers, symbols, letter and multiple letters with a maximum of x things. But we could have controlled redundancy and put a rule where we only allow 12 letter...

Database Design

Introduction Every Weekend I rent a Video or DVD from my local videostore in Dungannon, and when I ask about new releases the employee behind the desk sits rummaging through lots and lots of file paper. I can see where they have taken down details of the person renting the filming in one column and in another the film number. I think they would be better off with a computer, so I put that idea to them and they said, "how would a computer help us?" so I would like to give them my answer by designing a database for them that not only is organised but very secure. Explanation of databases and why they would be of use to this system What is a database? A database is a collection of information put together in an organised way so that it is easy to retrieve. The first databases systems...

Database Report

In this report I will show how I created my own database so you can also create your own database following these simple steps that I will guide you through. How to set a Drop down list: How to set the primary key: How to set the Input Masks: How to set the Data Validation: Relationship: I have completed my tables now I need to make a relationship between them, we use relationships to link tables. This is done so that the details in the table can easily link up. The purpose of a Relationships The purpose of a relationship is to link tables together by a specific filed that consists in both tables. I linked the "Costumers Details" table with the "Lending Details" by the "Account no". This is called a one too many relationships because there could be only one "Account no" in the "Costumers Details" table per...

Popular Essays

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?