|
|
|
|
|
|
|
The session focuses on more advanced skills for developing advanced
databases that use subforms, subreports, and macros. Also included are some basic
administrative considerations involving passwords, linking to other databases, splitting a
database into front-end and back-end components, and compacting. |
|
|
|
Course Outline Advanced
Form and Report Design
Main forms and subforms
Main reports and subreports
Nesting subforms and subreports
Referring to controls on a main form or report from a subform or report
Referring to controls on a subform or subreport from a main form or report |
Macros
Discussion about what Access macros really are
Creating macros
Using event properties of controls on forms and reports
Linking macros to event properties
Group macros
Autoexec macro and when it does not activate
|
|
|
Toolbars
Creating custom toolbars and shortcut menus
Assigning toolbars and shortcut menus to forms and reports |
|
|
Database Features
Compacting strategies
Passwords
Linking to other databases
Importing objects from other databases
ODBC overview
|
|
