4 Databases and spreadsheets A. What is a spreadsheet? B. Spreadsheet design and creation: cells; rows and columns; workbooks, worksheets and templates, cell format (number, text, values, formulas, functions, calculation, date, currency); replication. C. Advanced spreadsheet design: absolute and relative cell referencing; cell ranges and labels; macros. D. What if? questions E. Accessing spreadsheet data - sorting (ascending and descending) and searching (filtering) using the Boolean (logical) operators (AND, OR, NOT) F. Presenting spreadsheet data: selecting print and display area and use of appropriate graphs or charts G. Special purpose spreadsheets e.g. inventory, budget H. What is a database? I. Paper versus electronic files J. Designing databases: fields, key field, records, sorts, searches (filters) using Boolean (logical) operators (AND, OR, NOT) and queries K. Data transfer between a database and a spreadsheet (import and export) L. Database presentation in forms and reports M. Mail merge N. Database management systems (DBMS) O. Flat file versus relational databases P. Updating data, data redundancy and data integrity Q. Data mining and data matching R. Special purpose databases e.g. personal information managers, encyclopaedias, library systems, GIS's