Databases 0.0 / 5 ? ICTDatabasesGCSEAll boards Created by: mobywardCreated on: 09-05-16 10:07 Database an organised collection of data (held in records) 1 of 21 Fields categories of data in a record, e.g names, addresses, phone numbers 2 of 21 unique identifier a field containing data that is different for each record e.s. ID number 3 of 21 difference between databases and spreadsheets? databases: better tools for searching and displaying data; search for data using 'queries'; create 'reports' showing only data needed. 4 of 21 query search for particular data in a database; find records that fit certain criteria 5 of 21 report create a list of certain data selected from a database 6 of 21 Access system for setting up a database 7 of 21 setting up fields done in 'design view' 8 of 21 primary key the unique identifier 9 of 21 validation rule a rule to limit what data goes in a field e.g. #01/01/2000# 10 of 21 importing data use the extenal data tab 11 of 21 sorting puts records in order 12 of 21 names ascending A - z 13 of 21 names descending Z - A 14 of 21 numbers ascending small to large 15 of 21 numbers descending large to small 16 of 21 dates ascending oldest to newest 17 of 21 dates descending newest to oldest 18 of 21 filtering allows you to find records that contain certain bits of data 19 of 21 query design - how to search for a word or letter type it within double quotes 20 of 21 to bring up results on a query press the 'run' button on the 'query tools' tab 21 of 21
Comments
No comments have yet been made