microsoft access 2013 tutorial 5 case problem 1

You can even customize the report’s look and feel.

A report is an object in desktop databases primarily used for formatting, calculating, printing, and summarizing selected data.

It mainly used to ease the process of data entry or editing.

Forms help you to display live data from the table.

A form is a database object that you can use to create a user interface for a database application.Types of Query can be SELECT, INSERT, UPDATE, DELETE.Queries can pull from one or more related Tables and other Queries.Queries show a selection of data based on criteria (limitations) you provide.Queries answer a question by selecting and sorting and filtering data based on search criteria.

We can also define Primary Key in a table.A Table is usually related to other tables in the database file.A Table is an object which stores data in Row & Column format to store data.Every field has one datatype like text, number, date, etc. 2 PDF created with pdfFactory Pro trial version are the properties of each field. 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.

Microsoft access 2013 tutorial 5 case problem 1