|
|
Advanced Module 5
Advanced Database
Table Design
-
To set fields data types
-
To format fields
-
To create a lookup in a field
-
To create a validation rule in a field
-
To create 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 apply inner/ outer/ 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
Query Design
-
Query types
-
Query formulas
-
Refine a query
Form Design
-
To choose an appropriate control
-
To place an unbound/ bound control
-
To create expression control
-
To create arithmetic expression control
-
To set tab index for controls on a form
-
To create form headers and footers
-
To number form pages
-
Sub forms
Report Design
-
To place controls on a report
-
To create arithmetic expression control
-
To create logical (conditional) expression control
-
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
-
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
Macros
-
To create a new 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 the macro to a report event
-
To attach the macro to the selected form property
Import, Export And Link Data
-
To import from text files
-
To import from Excel spreadsheet
-
To import from Dbase
-
To export data to a spreadsheet file
-
To export data to a text file
-
To link to an external text file
-
To link to Microsoft Excel spreadsheet
|
|