![Best games for mac os 2016](https://knopkazmeya.com/6.png)
![microsoft access 2013 tutorial 5 case 1 microsoft access 2013 tutorial 5 case 1](https://venturebeat.com/wp-content/uploads/2020/05/a100.jpg)
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. Create another query showing all fields of those students born after 1987 3. 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. 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. Delete the last Record you have entered 5. 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. Open the “Students Table” and enter 5 complete records. Make the “ID Number” Field as the Primary Key. 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. Next we're going to modify our query so we can look at some of the other things we can do with queries.© TCTC Practical Work Module 5 Practical Exercises Microsoft Access Exercise 1 1. MS Access 2013: Creating a query - step 1. We didn't want to see a big list of customers that haven't ordered anything yet. For example, if your Orders table contains a CustomerId of 5, you will need to make sure theres an actual. But that didn't stop the pesky sales person from adding her name into the database! She simply expressed interest in buying a space ship. Well actually, Marge is only a potential customer. she doesn't have a corresponding record in the Orders table). If you look back at the Customers table (near the top of this page), you'll see that Marge Simpson is a customer but she hasn't ordered any products yet (i.e. If a customer is in the Customers table but does not order a product, that customer's record will not be displayed in the results of this query.
![microsoft access 2013 tutorial 5 case 1 microsoft access 2013 tutorial 5 case 1](https://venturebeat.com/wp-content/uploads/2020/05/hp-spring-5.jpg)
This query will only return those customers who have ordered at least one product. The query has automatically joined the three tables using the relationship that we created and returned the matching data. You can also see that some customers have ordered more than one product.
![microsoft access 2013 tutorial 5 case 1 microsoft access 2013 tutorial 5 case 1](https://cloud.netlifyusercontent.com/assets/344dbf88-fdf9-42bb-adb4-46f01eedd629/c7800541-236a-41cb-97ac-98fd43644c7f/interactive-weather-dashboard-image4.png)
Our query successfully returns a all customers who ordered at least one product and it includes the product and its price next to their name.
![microsoft access 2013 tutorial 5 case 1 microsoft access 2013 tutorial 5 case 1](https://venturebeat.com/wp-content/uploads/2018/06/IMG_9354.jpeg)
![Best games for mac os 2016](https://knopkazmeya.com/6.png)