ITFM+LO3+Databases

=ITFM LO3= =Databases=

♦ working with databases: — use primary and foreign keys — create one to many relationships — enforce referential integrity — cascade updates and deletes — edit and delete relationships — print database relationships

♦ queries: — query on minimum of two fields from multiple tables on full or partial text or values within fields — This will involve use of wildcards, ie asterisk and question mark — use AND, OR or NOT to join query criteria together to create more complex conditions — use aggregate functions in queries: sum, average, maximum and minimum — use a calculated field — sort on minimum of two fields from multiple tables within query — create a graph from query

♦ forms: — design fields — establish order of data entry — set style and alignment — apply decorative enhancement — insert header and footer — modify properties — move, align, delete and edit components of form — insert graphic

♦ reports: — create report from table or query — use calculation within report as required from the following: sum, average, minimum, maximum — modify report layout to ensure visibility of data — insert report header — insert page header or footer

♦ exporting data: — export data to spreadsheet, word processing and presentation software document

♦ print: — extract/s from database — queries, forms and reports