Query 1 To create a using Gender & Instead of having all the passenger details Town fields in the table and only having the show, the ones first name and selected whilst surname, along with the creating the query gender post code, date are to display of payment, price and flight ID being selected to be shown in the table Query 2 To have the Terminal & All customers’ show only customers’ Class details that live in details living in the London are shown on town of London the table appear on the table With the mask Date Of Once on the datasheet Input Mask the format has been Birth & Date view all DOB are set for 00/00/0000 written out in the (dd/mm/yyyy) to 00/00/0000 format. display the DOB of customers. Also once being typed in it should only accept that format. Drop Down To have details Gender Once clicked the preview in a list option to choose M List instead of having it or F for gender will typed in appear in a drop down list
Query 1 To create a using the passenger details and only having the first name and surname, along with the gender post code, date of payment, price and flight ID being selected to be shown in the table Gender & Town Instead of having all fields in the table show, the ones selected whilst creating the query are to display Query 2 To have the show only customers’ details living in the town of London appear on the table Terminal & Class All customers’ details that live in London are shown on the table Input Mask With the mask the format has been set for 00/00/0000 (dd/mm/yyyy) to display the DOB of customers. Also once being typed in it should only accept that format. Date Of Birth & Date Once on the datasheet view all DOB are written out in the 00/00/0000 format. Drop Down List To have details preview in a list instead of having it typed in Gender Once clicked the option to choose M or F for gender will appear in a drop down list
p7_test_plan.docx