RTL Skills Demonstration 3 - 35%
Date RTL: Thursday 24th March 2021 from 10.00 am to 12.00 pm
Instructions for Skills Demonstration
1. First create a new OpenOffice or Access database file and save it in the form ForeNameSurnameRTL.odb e.g. if your name is Joe Bloggs then your file should be named JoeBloggsRTL.odb. Save this to your documents folder.
2. Next create a new table in Design View with the following fields and data types:
Instructions for Skills Demonstration
1. First create a new OpenOffice or Access database file and save it in the form ForeNameSurnameRTL.odb e.g. if your name is Joe Bloggs then your file should be named JoeBloggsRTL.odb. Save this to your documents folder.
2. Next create a new table in Design View with the following fields and data types:
- Forename , Surname, Address in Ireland all in text data type
- Resident of Ireland in Yes/No data type
- Booking Number in Number data type (Integer field size no decimal places)
- Arriving Flight Number, Departing Flight Number and Profession in text data type
4.Add in your own name, address, residency and profession as a new record with the following values for the other fields: Booking No: 12000, Arriving Flight: EI122 and Departing Flight: EI123
5. Go into the tables design view and add the following fields:
- Gender in Yes/No data type
- Date of Birth in Date/Time data type
- Salary in Decimal data type (Euro format 1 decimal place)
7. Next enter in the missing data for your record (from 4 above) and then sort the table in decreasing order of Salary. Then print your sorted table as ForeNameSurnameRTL1.pdf using Print >> Print to PDF into your documents folder.
8. Now click on Queries on the main Objects dialog and select Create Query by using Wizard. Select the fields Forename, Surname, Booking No, Residents of Ireland and Salary as fields in this Query. Save your Query as Residents and Salaries.
9. Then open the Query in Design view and adjust the query so that it only shows salaries greater than 50000 by writing an expression in the criteria box under the Salary field. Finally under the Residents of Ireland write another expression in the criteria box that selects only residents of Ireland. Your Query should now only show residents of Ireland who have salaries greater than 50000.
10. Now print a your database by selecting File >> Print >> Microsoft Print to PDF. Save your final printout as ForeNameSurnameRTL2.pdf and upload both your database file and both print pdfs to the RTL 2021 team Computer Applications channel. In this channel, select the Files tab and then the Skills Demonstration 3 folder. Select the folder with your name and then click on the 'Upload' button to navigate to your files and upload.
Mark Allocation
This Skills Demonstration will be worth 35% of the overall course mark.
8. Now click on Queries on the main Objects dialog and select Create Query by using Wizard. Select the fields Forename, Surname, Booking No, Residents of Ireland and Salary as fields in this Query. Save your Query as Residents and Salaries.
9. Then open the Query in Design view and adjust the query so that it only shows salaries greater than 50000 by writing an expression in the criteria box under the Salary field. Finally under the Residents of Ireland write another expression in the criteria box that selects only residents of Ireland. Your Query should now only show residents of Ireland who have salaries greater than 50000.
10. Now print a your database by selecting File >> Print >> Microsoft Print to PDF. Save your final printout as ForeNameSurnameRTL2.pdf and upload both your database file and both print pdfs to the RTL 2021 team Computer Applications channel. In this channel, select the Files tab and then the Skills Demonstration 3 folder. Select the folder with your name and then click on the 'Upload' button to navigate to your files and upload.
Mark Allocation
This Skills Demonstration will be worth 35% of the overall course mark.