Competency 703 Demonstrate Advanced Database Concepts 能力的703个示范先进的数据库概念.pptVIP

DatabasesCompetency 7.00 Objective 7.02 Explain advanced database concepts and functions. Retrieving Data Open a Table in a Database File Displaying Database Tables Use Filters to Select Data Filter: Displays records in a database that match specified criteria. Advantages of using filters Easier to use than query Fast Disadvantages of filters All fields are displayed when using a filter Cannot save filters like queries Types of filters By Form (key criteria into a form; more flexible because criteria can be set for more than one field) By Selection (quick/easy option by highlighting a cell as criteria) Excluding Selection (excludes data highlighted in cell) Advanced Filter/Sort (works like a query) Advanced Filter/Sort Menu Build a Query Query: A database object that allows the user to select records/data from a database using multiple criteria (comparison operators) and arrangement (sorting) standards. Advantages Queries can be saved Each table can be associated with multiple queries Set Conditions for Query Comparison Operators for Queries and Filters Equals = Does not equal Between and between and Less than Greater than Equal to or less than = Equal to or greater than = Query: Advanced Criteria AND Condition: Uses the same row in the Query Design window The AND condition reduces the number of records because both conditions must be met. OR Condition: Uses different rows in the Query Design window The OR condition increases the number of records because records are selected if either condition is met. Query: AND Condition Query: OR Condition Search Records To search for specific records, select Find command from the Edit menu. Key the search string (data) in the dialog box. Key “where” to find the records (which table). Similar to Find/Replace commands in other programs Not case sensitive Sorting To sort is to arrange data in a specific order. Ascending sort: Alphabetical order (A to Z) or numerical order (1 to 9) Descending s