CREATING ADVANCED FORMS
Creating And Customizing Effective Forms
- Using The Form Wizard
- How To View Form Design
- Show / Hide Field List
- Show / Hide Toolbox
- How To Resize Form Control
- How To Reposition Controls And Labels
- Separate Control And Label
- Delete A Field Control
- How To Add A Field Control
- Control Cursor With Tab Order
- Changing Control Properties
- How To Change Form Properties
- Selecting Multiple Controls
- How To Make Form Header/Footer Visible
- Using Windows Themes In Forms
Creating User Friendly And Powerful Controls On A Form
- Creating A Form From Scratch
- How To Create Form Header And Footer
- Insert Label
- Formatting Text Properties
- Changing Form Background Colour
- How To Apply Special Effects
- Change The Form Background Image
- Adding A Text Box Field Control
- How To Add Unbound Text Box Control
- Rename Controls
- How To Insert Function In Control
- Inserting Calculated Control
- How To Insert Option Group Control
- Inserting Combo Box Control
- How To Insert List Box Control
- Insert Command Button
Integrating Main And Subform
- How To Create Subform
- Create A Main Form
- Integrating Subform Into Main Form
- Hide Record Navigator Buttons In Subform
- How To Hide Selected Information In Subform
- Changing The Subform Size
|
CREATING ADVANCED REPORTS
Working With Report Sections
- Creating A Report Using Wizard
- How To Reorganise Labels And Controls In Sections
- Inserting Calculated Control
- Change Format In Control Properties
Customising Report Sections
- Creating A Report From Scratch
- Inserting Report Header And Footer Section
- How To Insert Group Header And Footer Sections
- Inserting Controls And Labels Into Sections
- How To Customise The Format Of A Control
- Changing Group Properties
- How To Change Section Properties
- Inserting Analytical Values To Sections
- How To Insert Page Numbers
Creating Chart Report
- Create A Chart Report Using Wizard
- How To Select Chart Type And Layout
AUTOMATING DATABASE WITH MACROS
Working With Macros
- Creating Macros
- How To Run Macros
- How To Edit And Rename Macro
- Grouping Macro
- Insert A Button To Run Macro
- Filtering A Record Using Macro
- Creating Conditional Macro
- Secure Database With Autoexec Macro
Macro Security
- Setting Macro Security
- How To Enable Macros
|