ADM 1370 Lecture Notes - Lecture 30: Database Application, Portable Document Format, Select Records

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Umar Ruhi

Document Summary

Overal, you;ve gained some rst hand experience with databse design as well as datable application design. Ms access is a great tool for database application design & deployment. A set of instructions used for working with data. Creating a query is like asking the datable a question. Running a query performs these instructions and provides the answers. The results that a query returns can be sorted, grouped, or ltered. A query can get its data from one or more tables, from existing queries, or from a combination of the two. The tables or queries from which a query gets its data are referred to as it"s record source. A select query is the most basic type of database query. It creates subsets of data that you can use to answer speci c questions or to supply data to other datable objects. A criterion query users rules to identify records to be included in the query results.