MS Access Reports - Thinking Outside the Text Box - PowerPoint by fzk93926

VIEWS: 0 PAGES: 11

									                   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
                Detail reports
rpt Types
                Summary reports
rpt Controls    Cross-tab reports
rpt Events      Sub-reports
rpt Formats     Reports with forms
rpt Data        Reports with labels
rpt Other       Reports with graphics
rpt Output      Reports with charts
rpt Examples
Conclusion
Questions

June 12, 2003      MS Access Reports - Thinking Outside the Text Box      2
                                                      Report Controls
                Labels
rpt Types
                Text Boxes
rpt Controls    Lines
rpt Events      Rectangles
rpt Formats     Bound Object Frames
rpt Data        Unbound Object Frames
rpt Other       Image Controls
rpt Output      Page Breaks
rpt Examples    Sub-reports
Conclusion
Questions

June 12, 2003     MS Access Reports - Thinking Outside the Text Box   3
                                                              Report Events
                On   Open
                                                                           Open
rpt Types
                On   Close
rpt Controls    On   Activate                                             Activate
rpt Events      On   Deactivate
rpt Formats     On   No Data                                              Format
rpt Data        On   Page
rpt Other       On   Error                                                 Print
rpt Output      On   Format
rpt Examples    On   Print                                                 Close
Conclusion      On   Retreat
Questions                                                                Deactivate

June 12, 2003        MS Access Reports - Thinking Outside the Text Box                4
                     Report Format Properties
                Caption
rpt Types
                Page Header/Footer
rpt Controls    Group Keep Together
rpt Events      Width
rpt Formats     Picture …
rpt Data        Grid X / Grid Y
rpt Other       Layout for Print
rpt Output      Palette Source
rpt Examples
Conclusion
Questions

June 12, 2003      MS Access Reports - Thinking Outside the Text Box   5
                              Report Data Properties
                Record Source
rpt Types
                Filter
rpt Controls    Filter On
rpt Events      Order By
rpt Formats     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
                Record Locks
                Date Grouping
rpt Types
                Menu Bar, Toolbar & Shortcut Menu Bar
rpt Controls    Help File & Help Context ID
rpt Events      Tag
rpt Formats     Has Module
rpt Data        MoveLayout
rpt Other       NextRecord
                PrintSection
rpt Output
                FormatCount
rpt Examples
                PrintCount
Conclusion
                HasContinued
Questions       WillContinue
June 12, 2003      MS Access Reports - Thinking Outside the Text Box   7
                             Report Output Formats
                Screen
rpt Types
                File
rpt Controls    Text
rpt Events      Rich Text Format
rpt Formats     Print
rpt Data        Fax
rpt Other       Acrobat
rpt Output      Snapshot
rpt Examples    HTML
Conclusion      Word
Questions       Excel
June 12, 2003      MS Access Reports - Thinking Outside the Text Box   8
                                                  Report Examples
                Access as word processor - 22 inches
                Graphics in reports
rpt Types
                Page borders around reports
rpt Controls
                Alternate color of rows in report
rpt Events
                Numbering records in a report
rpt Formats
                Sub-reports & sub-sub reports
rpt Data
                Sorting & grouping – not in query
rpt Other       Immediate IF statements in controls
rpt Output      Height of controls to 0
rpt Examples    Print, preview or cancel
Conclusion      Multicolumn report
Questions

June 12, 2003      MS Access Reports - Thinking Outside the Text Box   9
                                                                       Conclusion
                Access reports are very powerful
rpt Types
                Control almost every aspect
rpt Controls    Incorporates all data types
rpt Events      Outputs to many file types
rpt Formats     Adhere to naming convention
rpt Data        Use reports to generate documents
rpt Other       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
                Ofer Shimrat
rpt Examples    (858) 484-0400
Conclusion      ofer@soundoffcomputing.com
Questions

June 12, 2003   MS Access Reports - Thinking Outside the Text Box           11

								
To top