The Database is used to simply store all the relevant Employee's details which would be good use to the Managers of Somerfield Stores Ltd. It is stored as a computerized Database to enable quick search times, easy access to needed data, good organization and easy out put as you can simply view the Data on screen or just press print. This Database stores Employees details, it also stores which department they work in, in the Supermarket and it stores data on the Employees job specification.
I am now going to demonstrate what happens when the reports and forms are opened and what you can do with each of them. All Reports will open in the same format: All reports are in the same format, I will give an example of what the Reports look like once they are printed out and they will be included with in this documentation. The Forms on the switchboard are as follows: This is Form Employee, named 'Employee's Details Form' on the Switchboard.
This Form will allow you to view the contact Details of the Employees and edit and make new records and save them as employee's details in the report. The other form which will be used is Form Department, as listed on the switchboard as Department Details Form: When running these Queries in the Database, a box will appear asking for a parameter value, this refers to what Data needs to be entered to identify the correct data, for example, Query Search by Department name:
As you can see above the Data will be pulled out referring to which department is entered so if a different department was entered, for example if the Checkouts department was entered: All employees in that department will be located; it works the same on Query Search by Department ID. If the User of the Database needs any additional help using the Microsoft Products help is available in Microsoft Access: If the user requires any additional help he/she should visit:
Comments
Post a Comment