ECDL Courseware - ICDL Courseware

ECDL / ICDL Advanced AM5
Advanced Level Databases
Approved Courseware Training Resources

1. TABLE DESIGN

FIELDS, COLUMNS

To set column data types
To modify column data types
To format Text data type
To format Memo data type
To format Hyperlink data type
To format Currency data type
To format Date/Time data type
To choose appropriate data types
To convert between data types
To change a field to a different data type
To create a lookup in a field
To create a lookup from the values in a table or query
To create a lookup from the values you type in
To edit a lookup in a field
To create a validation rule in a field
To edit a validation rule in a field
To create an input mask in a field
To edit an input mask in a field
To apply default value in a field
To set required fields

RELATIONSHIPS/JOINS

To identify a related table
To create a relationship
To delete a relationship
To create one-to-one and one-to-many join types
To create a one-to-one relationship
To create a one-to-many relationship
To modify one-to-many join type
To create many-to-many relationship
To modify many-to-many join type
To apply inner join
To apply outer join
To apply self join
To set referential integrity
To set cascading options
To create a two-table join
To add another table to the query grid
To add fields from different tables to the query grid
To remove tables from the query builder

2. QUERY DESIGN

QUERY TYPES

To create an Update Query
To create a Delete Query
To create a Make-Table Query
To create an Append Query

QUERY FORMULAS

To calculate totals for a single group
To calculate totals for several groups
To count the values in a specified column using the COUNT function
To sum the values in a specified column using the SUM function
To average the values in a specified column using the AVG function
To find maximum value in a specified column using the MAX function
To find minimum value in a specified column using the MIN function
To create a crosstab query
To create a crosstab query using the Crosstab Query Wizard
To use Wildcards as parameters
To create a calculation in design view
To create an arithmetic expression in a query
To create a logical (conditional) expression in a query

REFINE A QUERY

To find duplicates using the Find Duplicates Query Wizard
To find unmatched values using the Find Unmatched Query Wizard
To find highest range of values in a query
To find lowest range of values in a query
To create a parameter query
To find Null values
To find NOT values

3. FORM DESIGN

CONTROLS

To choose an appropriate control
To place an unbound control
To place a bound control
To create a combo box
To create a list box
To create a check box
To create an option button
To create an option group
To create expression control
To create arithmetic expression control
To create logical (conditional) expression control
To set tab index for controls on a form
To create form headers and footers
To number form pages

SUBFORMS

To use a subform
To add a subform to a form
To bring a subtotal from a subform to a main form

4. REPORT DESIGN

CALCULATIONS

To place controls on a report
To create arithmetic expression control
To create logical (conditional) expression control
To calculate percentage calculation control in a report
To use common functions in calculated fields
To use calculated fields in a report
To concatenate (combine) values in an expression
To create a report with running summaries

PRESENTATION

To create Page Headers and Footers
To create Report Headers and Footers
To group records on a report
To force page breaks after each record
To force page breaks after each group of records

5. MACROS

RECORD & ASSIGN

To create a new macro
To run a macro
To use the Single Step method to run a macro
To attach macros to a form
To attach the macro to a control in the form
To attach macros to a report
To attach the macro to a report event
To attach the macro to a section of the report
To attach the macro to the selected form property

6. IMPORT, EXPORT AND LINK DATA

DATA MANAGEMENT

To import from text files
To import from Excel spreadsheet
To import from dBASE
To import from Paradox
To export data to a spreadsheet file
To export data to a text file
To export data to a dBASE file
To export data to a Paradox file
To link to an external text file
To link to Microsoft Excel spreadsheet

ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence

ECDL / ICDL Advanced AM5Advanced Level Databases Approved Courseware Training Resources

1. TABLE DESIGN

FIELDS, COLUMNS

RELATIONSHIPS/JOINS

2. QUERY DESIGN

QUERY TYPES

QUERY FORMULAS

REFINE A QUERY

3. FORM DESIGN

CONTROLS

SUBFORMS

4. REPORT DESIGN

CALCULATIONS

PRESENTATION

5. MACROS

RECORD & ASSIGN

6. IMPORT, EXPORT AND LINK DATA

DATA MANAGEMENT

Other ECDL / ICDL Courseware Training materials

ECDL / ICDL Advanced AM5
Advanced Level Databases
Approved Courseware Training Resources