Flashcards
chapter 8
Cards in this deck (10)
- 1calculated fieldsnot all data needed in a report may be present in the database. e.g. someone's age because it changes. If you use it in a report it would need to be calculated. this is known as a calculated field.
- 2uses of a database-add change or delete records.
-search for a particular rec ord.
-sort the records into a given order.
-print reports about some aspect of the database. - 3updating records.records don't stay the same forever, they need updating. you can add, edit or delete records.
- 4searching for datato search for information you use a query. a query specifies what records you are searching for and what fields from the record you like to display.
- 5simple query searchlooks for data in one field
- 6complex query searchlooks at data with multiple criteria.
- 7operators.= equals
greater than
<>not equal to
AND data listed if conditions true(both)
OR either or both conditions true
LIKE perfect match not needed - 8wildcardyou use wildcard searches in queries for data that you only know part of.
- 9wildcard characters.* any number of characters
? any character
[] any character in the brackets
[-] any character within a range of characters
! any character not in the brackets - 10soting dataresults of queries can be presented in a sorted order e.g. alphabetical.
Information
- Description
- Flashcards on chapter 8, created by vanquish on 09/02/2015.
- Created by
- vanquish
- Views
- 0
- Rating