Transcript MS Access Reports - Thinking Outside the Text Box

Microsoft Access Reports
ab|
Thinking Outside The Text Box
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
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 Examples
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
2
Report Controls
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Labels
Text Boxes
Lines
Rectangles
Bound Object Frames
Unbound Object Frames
Image Controls
Page Breaks
Sub-reports
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
3
Report Events
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
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
June 12, 2003
Open
MS Access Reports - Thinking Outside the Text Box
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 Examples
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
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 Examples
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
6
Other Report Settings
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Conclusion
Questions
June 12, 2003
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
MS Access Reports - Thinking Outside the Text Box
7
Report Output Formats
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Conclusion
Questions
June 12, 2003
Screen
File
Text
Rich Text Format
Print
Fax
Acrobat
Snapshot
HTML
Word
Excel
MS Access Reports - Thinking Outside the Text Box
8
Report Examples
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Conclusion
Access as word processor - 22 inches
Graphics in reports
Page borders around reports
Alternate color of rows in report
Numbering records in a report
Sub-reports & sub-sub reports
Sorting & grouping – not in query
Immediate IF statements in controls
Height of controls to 0
Print, preview or cancel
Multicolumn report
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
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 Examples
Conclusion
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
10
Questions
rpt Types
rpt Controls
rpt Events
rpt Formats
rpt Data
rpt Other
rpt Output
rpt Examples
Conclusion
Ofer Shimrat
(858) 484-0400
[email protected]
Questions
June 12, 2003
MS Access Reports - Thinking Outside the Text Box
11