• 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 ...

    opened up a spreadsheet which lacked in design and presentation, then they probably would not bother using it or decided not to buy it. I decided to colour the background black, so that it was eye catching, and looked professional, as if I had colours the cells bright pink, then it would not have been suitable for my target audience.

  2. bookings database

    Easy to navigate around forms- the command button 'Return to Room status' will deliver the user back to the Room status form. The user can also abandon the booking and this will cancel the form and allow the user to navigate around forms.

  1. AQA GCSE ICT Specification B

    The fields necessary to do this should not be left blank. The system prevents this from happening. Length Check Applies To Credit Card Number First Name Last Name Home Phone Mobile Phone Evidence of Implementation Justification The length check enables the input of irrationally long entries to be recognized and prevented.

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

    * Some information about the famous actors and actress visiting the restaurant. The above information is fully used in designing this project. I am going to manually key in all the above data so as to make a proper menu. The menu will contain 2 sheets each having 3 sides.

  1. Analyse - Database

    fields - Expensive to set up initially - Mr Browne does not have it - The Employees will need to be trained Microsoft Access - Relational Database - Queries and Forms - Easy to understand - Display data in graphical and chart form - Editing and sorting fields - Visual

  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 ...

    as it will waste valuable customer and labour time. Also in respect to saving data I will require a computer, which will work fast enough to retrieve data that I hope to only take 15 seconds maximum to log on into a spreadsheet (MS Excel 97)

  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