wildcard A special character used in criteria to find, filter, and query data. SQL (Structured Query Language) A language that provides a standardized way to request information from a relational database system. Simple Query Wizard An Access wizard that prompts you for information it needs to create a new query.
Save As command A command on the FILE tab that saves the open file in a new location and/or with a new name in Access, used to save the entire database (and all objects it contains) or only the current object with a new name. Query Design View The window in which you develop queries by specifying the fields, sort order, and limiting criteria that determine which fields and records are displayed in the resulting datasheet. query design grid The bottom pane of the Query Design View window in which you specify the fields, sort order, and limiting criteria for the query. Queries are created when the user has a "question" about the data in the database. It may provide the user with a subset of fields and/or records from one or more tables. query An Access object that provides a spreadsheet-like view of the data, similar to that in tables. A record will appear in the resulting datasheet if it is true for any single row. OR criteria Criteria placed on different rows of the query design grid. logical view The datasheet of a query is sometimes called a logical view of the data because it is not a copy of the data, but rather, a selected view of data from the underlying tables. Like operator An operator used in a query to find values in a field that match the pattern you specify. Join line The line identifying which fields establish the relationship between two related tables.
0 kommentar(er)
