Assessor Checklist-For Teacher use
Task 1
Task 2-You need to plan the Database on paper before creating it in Microsoft Access. Use the links below to help you to do this. Ensure your field sizes and descriptions are different from those in the example.
Finally create a sketch of the 3 tables showing the relationships between them.
Task 5-Entering the Data. Now enter the data below into your Database in Datasheet view.
Task 6 Sorting Data. You need to show how to sort the category field in ascending order. Below is an example of how to do this. Take screenshots and annotate them like those below.
Task 7-Validation Rules. You need to show the validation rules you added to your tables. Below is an example of how to do this.
Task 8-Input Masks. You need to create an input mask so that the user cannot enter the Data incorrectly. Take screenshots and annotate them like those below.
Input Mask (Postcode)
Input Mask (Date Out)
Input Mask (Date released)
Task 9-Relationships. You need to create relationships between all your tables. This will allow you to create queries which gather data from all 3 tables. Take screenshots showing how to do this like those in the example below.
Task 10-Creating Forms. You now need to create forms to enable the user to enter new customers information into. Take screenshots like those below showing how to do this.
Task 11-Combo boxes. You need to create combo boxes to allow the user to locate information quickly and easily. Take screenshots like those below showing how to do this.
Task 12-Completed Forms and Tables. You now need to annotate your completed forms and tables explaining what your screenshots show.
Task 13-Queries. You now need to create the queries below to show how the Database can help the user search for useful information. Take screenshots like those below showing how to do this.
Explain the purpose of each query.
Query 1-Create a query that sorts a table into alphabetical order on 1 field
Query 2-Create a query that shows information from 1 month (LIKE)
Query 3-Created a new query that displays all the fields from at least two tables. Sort on 2 fields
Query 4-Created a query that uses at least two search criterion (two fields)
Query 6-Created a query that uses three fields. And uses at least two tables (BETWEEN)
Query 7-Created a query that combines two existing queries in order to obtain the information required.
For a distinction you must create a query using complex criteria (e.g.: NOT, BETWEEN, AND, LIKE etc)
Task 14-Reports. Access can create detailed reports which can be of use to the user. Create reports using the information from your queries and then annotate them like those below.
Create Customised reports for all seven queries.
Explain what the reports show.
Finally print out all your completed reports and put them in your folder.
Task 15-User Interface. You need to show how you have created a user interface. Take screenshots like those below showing how to do this.
The user interface must open all of your reports, forms, queries etc.
Task 16-Testing. It is now important to test that your Database works correctly. Below are some example test tables. You must however create your own tests and not use the ones in the example.
Task 17-Improvements. You now must fix any problems you found when testing your Database. Take screenshots like those below showing how to do this.
Functional Skills
(1.1) (1.1) (1.2i)