2 PDF created with pdfFactory Pro trial version www.pdffactory. Create a query showing only the Student’s Name, Student’s Surname and Student’s Date of birth. ![]() Move the Date of Birth and Telephone Number fields so that the Date of Birth field is now directly after the Surname field. Sort the table in ascending order by surname 3. Create another query showing all fields of those students born after 1987 3. Open the Students Table and enter 5 complete records. Create a query, showing all fields of those students who have a particular surname of your Choice. Insert a picture in the report Header Exercise 5 1. Real-time insights into student understanding through interactive lessons, interactive videos, gamified learning, formative assessment, and activities. Create a report based on the Student’s Table showing the Fields Name, Surname, and Telephone Number. Insert a Picture in the form in way that all text is visible. Make the ID Number of Each student in the form, Red 4. Create a Form with all fields on the Student’s Table. Change the field size of the Surname to 20 1 PDF created with pdfFactory Pro trial version © TCTC Practical Work Module 5 Exercise 3 1. All ryanmcfalls Items > Hope College CSCI 140 > Tutorial 3 Review Assignment. Delete the last Record you have entered 5. Workbook located in the Excel5 Case1 folder included with your Data Files and then save the workbook as. Sort the table in ascending order by surname 3. Free Access 2013 Tutorial at GCFGlobal Access 2013 is the database application in the Microsoft Office 2013 suite. Open the “Students Table” and enter 5 complete records. Make the “ID Number” Field as the Primary Key. Introductions All about JOC Expectations Criteria Brief Overview of Assignment Process Questions / Discussion. Create a Table in the School Database with the following: Field Name Data Type Field Size or Format ID Number Text 10 Name Text 15 Surname Text 15 Telephone Number Number Long Integer Date of Birth Date/Time Medium Date Stipend Currency Currency Foreigner Yes/No Yes/No 3. ![]() Create a new database, save it on the desktop and name it “School Database” 2. © TCTC Practical Work Module 5 Practical Exercises Microsoft Access Exercise 1 1.
0 Comments
Leave a Reply. |