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

Opening the database

Extracts from this document...

Introduction

OPENING THE DATABASE To open the database Microsoft Access will need to be opened. The program needs to be opened first in order to access the actual database file. Microsoft Access will either have an icon or will be found under start and then programs. In order to open the database, opening an existing database needs to be selected. If the database is not on the list of existing database then "more files" needs to be clicked on, followed by ok. Once the file has been selected from the relevant folder or user space the database can be opened. In the case of this database, the file was found under my user space and in my IT GCSE coursework folder. When the database has been opened a main menu will be found. This allows the user to easily navigate around the database. The Peterson's main menu shows the separate headings, which make it easier for the user to understand. ...read more.

Middle

The images above show some of the examples of drop down windows in the form. The arrow button can be clicked on and the required data can be chosen from the list or it can be typed in. However, the data will only be entered if the data being typed in matches one of the words in the list. * In some cases the data may not be in the list or a length check may be programmed to be too short. Therefore this will need to be edited. To do this the form can be closed by selecting "close form." The correct table needs to be opened and the design view button needs to be selected. To add another choice to the drop down menu, the correct field needs to be selected, for example "Title." If the option Master was not in there, it could be added by typing "Master" in the box labelled row source. * The user can then type information in the empty boxes. ...read more.

Conclusion

By clicking right clicking on the grey space next to the record not only brings up a menu with a list of commands, but also high lights the record in question. Then to delete the record the "delete record" button needs to be selected. * Microsoft Access then asks if you are sure that you want to delete this record, because it will be unable to undo the operation performed. This is to prevent records from accidentally being deleted. * In order to delete more than one record without having to do the above process several times, the following steps can be taken. The datasheet view should be selected, by right clicking on the form. The appropriate records that need to be deleted can be selected by clicking on the grey bar for the record and then holding the shift key. Then click the last record that needs to be deleted. This will then highlight all the records that need to be deleted. Still holding the shift key down, the information can be right clicked on and then delete records can be selected. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Once the drop down menu has appeared, select "filter." A side bar should appear. Giving you a list of options, select "Autofilter." Step 3 After you have selected "Autofilter," an arrow icon should appear at the top of the data list you selected earlier in Step 1. This arrow allows you to select a specific item, which you can

  2. bookings database

    Easy to abandon record- if the user does not want to save the booking, they can just simply click the 'Abandon booking' command button which will cancel the booking. 4. No deletions of existing records- this is not possible as the user does not have access to these records on the 'Make a booking' form.

  1. AQA GCSE ICT Specification B

    Useful for details such as Name and Address where there is any number of possible answers. The user is not limited in their response, except by validation boundaries, e.g. 7 Characters for a postcode, 16 for a Credit Card Number, which prevent the user making errors.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Then I sat with the waiters to collect the information they are currently narrating to the customers and recorded it on paper. I also asked the waiters for the popular cuisine that was liked by customers and ordered by them mostly.

  1. Analyse - Database

    Not a relational database - Cannot make forms - Queries are hard to understand - Employees are not fully aware of how to use this system FlexiDATA - Relational Database - Queries and Forms - Easy to understand - Display data in graphical and chart form - Editing and sorting

  2. Project 1b; Film Database

    To show how this database can satisfy the needs of a user, I made three queries according to three questions that I listed earlier, which could have been asked by a member of staff or customer. The first query filters the films that answer the question, 'which films are in stock that are not more than three years old?'

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Though this idea consumes a lot of money, which is a major problem, though if applied the spreadsheet, is applied in the Internet then the filing systems of this organisation can be made very simple and organised. Another aspect, which I should shed some light on, is the concept of magnetic disks; these are disks that backup information.

  2. this can be done by starting up Microsoft Access and then selecting the existing ...

    You can also start a new record by pressing in the form view menu (under menu toolbar.) In this menu you can also delete a record by pressing. For all menus including forms and tables, there will be a button on the form view menu (2nd menu from top.)

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