Transcript Access 2000 Reports - Tips & Tricks

Microsoft Access 2000
Report Primer, Tips & Tricks
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
1
Report Types
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
Detail reports
Summary reports
Cross-tab reports
Sub-reports
Reports with forms
Reports with labels
Reports with graphics
Reports with charts
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
2
Report Controls
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Labels
Text Boxes
Lines
Rectangles
Bound Object Frames
Unbound Object Frames
Image Controls
Page Breaks
Sub-reports
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
3
Report Events
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
On
On
On
On
On
On
On
On
On
On
Open
Close
Activate
Deactivate
No Data
Page
Error
Format
Print
Retreat
Activate
Format
Print
Close
Deactivate
Questions
March 14, 2002
Open
Microsoft Access 2000 - Reports Tips & Tricks
4
Report Format Properties
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
Caption
Page Header/Footer
Group Keep Together
Width
Picture ….
Grid X / Grid Y
Layout for Print
Palette Source
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
5
Report Data Properties
rpt Types
rpt Controls
rpt Events
rpt Formats
Record Source
Filter
Filter On
Order By
Order By On
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
6
Other Report Settings
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Record Locks
Date Grouping
Menu Bar, Toolbar & Shortcut Menu Bar
Help File & Help Context ID
Tag
Has Module
MoveLayout
NextRecord
PrintSection
FormatCount
PrintCount
HasContinued
WillContinue
Microsoft Access 2000 - Reports Tips & Tricks
7
Report Output Formats
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Screen
File
Text
Rich Text Format
Print
Fax
Acrobat
Snapshot
HTML
Word
Excel
Microsoft Access 2000 - Reports Tips & Tricks
8
Report Tips & Tricks
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Tips/Tricks
Conclusion
Naming convention for controls/objects
Base report on unsorted query - faster
Alternate color of rows in long reports
Sub-reports & sub-sub reports
Sorting & grouping – not in query
Immediate IF statements in controls
Access as word processor - 22 inches
Page borders around reports
Height of controls to 0
Graphics in reports
Print, preview or cancel
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
9
Conclusion
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
Access reports are very powerful
Control almost every aspect
Incorporates all data types
Outputs to many file types
Adhere to naming convention
Use reports to generate documents
Base reports on stored queries
rpt Output
rpt Tips/Tricks
Conclusion
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
10
Questions
rpt Types
rpt Controls
rpt Events
rpt Formats
Ofer Shimrat
Soundoff Computing
(858) 484-0400
rpt Data
rpt Other
rpt Output
[email protected]
rpt Tips/Tricks
Conclusion
Thank You
Questions
March 14, 2002
Microsoft Access 2000 - Reports Tips & Tricks
11