Partial preview of the text
Download Access 2016 exercise and more Exercises Computer science in PDF only on Docsity!
FETAC Level 5 Database Methods Sample Exam 4 Paul Kelly, the college librarian has recently updated a report on the number of books in the library. He has noticed that there are some books missing. He checked the paper based filing system and discovered that these books went missing between June and August. He has decided to set up a database to help him track down the missing books. N.B. Candidates must complete all tasks Task 1 1.1 Create a database called College Library. Create a table named Books on Loan to store the following data. Name Room | Book Author Bar Code | Issue Date Susan Smith 12 Training for ECDL Syllabus 3 John Brennan 0023788 | 07/08/06 Jason Byrne 16 Java in a Nutshell John R Levine 0054677 LO/06/06 Leo Kell 12. Build your own PC Morris Rosenthal 0058551 26/07/06 Joe Mortis 10 Step by Step Spreadsheets Alan Dillon 0045778 23/07/06 Lisa Howl 16 Upgrading and Fixing PCs Andy Rathbone 0065982 02/06/06 Carol Tierney 13 Easy Web Graphics Julie King 0054869 14/06/06 Paul Keogh 10 Teach yourself HTML visuall: Moran Graphics 0096582 11/08/06 Evan Smith 14 ECDL the Complete Course Brendan Munnelly 0069582 02/06/06 Shane Ryan i Learning HTML Ray T Erik 0045621 14/06/06 Mandy Harris 12 Introducing Computers Robert H Blissmer 0069823 12/07/06 Jane Walsh 10 Step by Step Databases Alan Dillon 0023687 07/08/06 Mike Carey 17 Testing Computer Software Cam Kaner 0062598 18/07/06 Set up a validation rule which ensures that the Bar Code must be in the range 23000 “ 99000 inclusive. If the user attempts to enter a number outside of this range, the error message “Bar Code must be in the range 23000 - 99000” should be displayed. 1.2 Complete the Data Structure Form provided to show the Field Names, Data Types and Field Sizes Task 2 Design and create a form to allow the user to input the data shown above. The format of the form should be as follows: Insert the title Details of Books on Loan centrally on the form Display two fields on each line Place a label beside each field Create a combo box for the Room field. Each room number should appear once in the combo box eoeee 
