In this chapter, you will complete these projects and practice these skills.
To convert data into meaningful information, you must manipulate the data in a way that you can answer questions. For example, what are the names and addresses of students who are enrolled in the Computer Information Technology program and who have a grade point average of 3.5 or higher? With such information, you could send the selected students information about scholarships that might be available to them. Questions concerning the data in database tables can be answered by sorting the data, by applying a filter to limit the records that display, or by creating a query. Access queries enable you to isolate specific data in database tables by limiting the fields that display and by setting conditions that limit the records to those that match specified conditions. You can also use a query to create calculations. In this chapter, you will sort and filter Access database tables. You will also create and modify queries for an Access database. |