|
|
ECDL / ICDL AM5 Courseware Training Materials
Advanced Databases
ECDL | ICDL Courseware Training Manual
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
Other ECDL / ICDL Courseware Training materials
|
