Database ECDL ICDL Advanced
Microsoft Access 2003 Edition for ECDL Advanced
Oluline
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
• Using Aggregate Functions
• 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
• o 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
Check back soon there are more topics