Extracts from this document...

Introduction

User Guide Locating and opening the Database On the desktop there is an access database file called "Minster Minibus hire: Double click this file and it will launch the Minster Minibus hire database. Once the database loads, a splash screen will appear with the message "Hello, Welcome to minster minibus hire!" click on "OK" button. How to Log in Once you have clicked "OK" button, you will then be taken to the Log in screen: To log in: - Click on the box beside username and type in your username - Click on the box beside password and type in your password - Click on the "Login" Once you have done this, a splash screen with the message "welcome to work" will appear, click "OK" to continue; If an incorrect username or password is entered, then the user will be prompted with the splash screen message "invalid username or password, please try again" and will be taken back to the login screen, this will prevent any unauthorised users accessing the database: How to navigate the User Interface Once you have successfully logged in, you will then be taken to the home screen user interface: On the user interface there are 4 actions which can be taken by clicking the control button: - Clicking the "Open Minibuses form" button will close the home screen and open the Minibuses form. - Clicking the "Open Customer form" button will close the home screen and open the Customers form. - Clicking the "Open Hiring form" button will close the home screen and open the Hiring form - Clicking the "Logout" button will close the home screen and will take you back to the Login screen. Once you have opened a form you can navigate back to the main user interface by clicking this button: How to add data Adding new customers On the customers form there are a number of action buttons on the form, when you rollover the button, the details of what the button does, ...read more.

Middle

click on the record you want to delete, right click, and select the "Delete record" option like so: Again you will be prompted with a warning message asking you to confirm the message so click yes like so: You may be required to delete multiple records from this table depending on the buses hired out in the hiring record you want to delete. Now if you attempt to delete the record from the Hiring form you should be able to do so without any error messages. How to edit data Editing a customer record To edit a record on the customer's form, simply click on a field, this will highlight the field as shown, then type the new data that you want the field to contain in the highlighted field and click away from field. This will automatically save the new data: When editing a certain fields, only valid data will be allowed to be entered, see validation section. Editing a minibus record To edit a record on the minibus form, simply click on a field, this will highlight the field as shown, then type the new data that you want the field to contain in the highlighted field and click away from field. This will automatically save the new data: When editing a certain fields, only valid data will be allowed to be entered, see validation section. Editing a hiring record To edit a record on the minibus form, simply click on a field, this will highlight the field as shown, then type the new data that you want the field to contain in the highlighted field and click away from field, in this case the field is a dropdown box so typing is not necessary as you can see the details of the customer ID to choose from. This will automatically save the new data: As you can see in the above screenshot because I changed the customer ID this also changes the details in the subform to the right. ...read more.

Conclusion

you go back to the minibus form the prices would have been decreased by the percentage you entered like so: To return the prices back to the original values you can simply navigate back to the discount form from the minibus form and click the "Return original prices" which will pop up a message confirming the change of prices back to their original prices like so: And as you will see the prices have returned to the original values: Disaster Recovery In case of any sudden problems with the database or computer itself, a backup of the database will be needed, to do this follow these steps: - Firstly locate the database on the desktop of your computer and right click and copy the file like so: - Once you have copied the file, click on the "My Computer" from the start menu and locate your Memory stick or external hard drive like so: - Once you have located your memory stick/external hard drive, double click on it to open and paste the file into a backup folder or on the memory stick/hard drive itself like so: You have now successfully backed up your database. If in worst case scenario where you cannot locate the database file on your desktop you can follow these steps to recover the database file: - Go to "My Computer" again like so and click the "Search" icon like so: - Select "All files and folders" option on the left hand side: - - Then type in "*.accdb" as shown in the screenshot below: - This will then search for all database files and show the result for you to choose the file you want to open and you can then just copy and paste it back onto the desktop: If the file is not found then you can simply copy the file from the backup file on the memory stick/hard drive and paste it back onto the desktop like so: ?? ?? ?? ?? Shafi Ali BGS7002 23/09/11 ...read more.

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