Site menu
Search
Map

View Larger Map
Calendar
«  September 2017  »
SuMoTuWeThFrSa
     12
3456789
10111213141516
17181920212223
24252627282930
Site friends
  • Create a free website
  • Statistics

    Total online: 1
    Guests: 1
    Users: 0
    Ads
     Access Reports Object
    Microsoft Access - Reports

    From this hour you will be able to learn about below topic –

    What is Report
    How to Create Columnar Report with Report Wizard
    How to Create Tabular Report with Report Wizard
    How to Set Columnar Report Data in Two Columns or More
    How to Change Report Style
    How to Create Grouping Report with Report Wizard
    How to Create Report with Auto Form: Columnar
    How to Create Report with Auto Form: Tabular
    How to Create Report with Design View
    How to Create Multi-report

     
     
    Report:

    A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.

    To Create Columnar Report with Report Wizard:
    • Select Reports under Objects
    • Click New on the 'database window toolbar'
    • Double click on Form Wizard
    • Select Employee table from Tables/Queries list
    • Add fields from Available Fields: list to Selected Fields: list
    • Click Next button
    • Click Next button
    • Click Next button
    • Select Layout: Columnar > Click Next button
    • Select Style: Corporate (or your choose) > Click Next button
    • Type a title as EmployeeColumnar (or your choose) > Click Finish button
    • Close the report
    To Create Tabular Report with Report Wizard:
    • Select Reports under Objects
    • Click New on the 'database window toolbar'
    • Double click on Form Wizard
    • Select Employee table from Tables/Queries list
    • Add fields from Available Fields: list to Selected Fields: list
    • Click Next button
    • Click Next button
    • Click Next button
    • Select Layout: Tabular > Click Next button
    • Select Style: Corporate (or your choose) > Click Next button
    • Type a title as EmployeeColumnar (or your choose) > Click Finish button
    • Close the report
    To Set Columnar Report Data in Two Columns or More:
    • Select Reports under Objects
    • Select the report EmployeeColumnar from 'database window' > Open the report
    • On the File menu, click Page Setup…
    • Select Columns tab button > Type Number of Columns: 2 > Type Column Size Width: 3 or 3.5 > Click Ok button
    To Change Report Style:
    • Select Reports under Objects
    • Select the report EmployeeColumnar from 'database window'
    • Click Design on the 'database window toolbar'
    • On the Format menu, click AutoFormat…
    • Select a style > Click Ok button
    • Save the report > Close the report design window
    To Create Grouping Report with Report Wizard:
    • Select Reports under Objects
    • Click New on the 'database window toolbar'
    • Double click on Form Wizard
    • Select Employee table from Tables/Queries list
    • Select fields from Available Fields: to Selected Fields: by arrow buttons > Click Next button
    • Double click on EmpTitle (or your choose) for grouping > Click Next button
    • Select EmpName (or your choose) for sort > Click Next button
    • Select Layout: Stepped (or your choose) > Select Orientation: Landscape > Click Next button
    • Select Style: Corporate (or your choose) > Click Next button
    • Type a title as EmployeeReportStepped (or your choose) > Click Finish button
    • Close the report
    To Create Report with Auto Form: Columnar:
    • Select Forms under Objects
    • Click New on the 'database window toolbar'
    • Select Auto Form: Columnar > Choose a table/query: Employee (or your choose) > Click Ok button
    • Save the form with a unique name and close the form
    To Create Report with Auto Form: Tabular:
    • Select Forms under Objects
    • Click New on the 'database window toolbar'
    • Select Auto Form: Tabular > Choose a table/query: Employee (or your choose) > Click Ok button
    • Save the form with a unique name and close the form
    To Create Report with Design View:
    • Select Reports under Objects
    • Click New on the 'database window toolbar'
    • Select Design View > Choose a table/query: NewEmployee (or your choose) > Click Ok
    • Drag the fields from field list on the Detail area of report design grid > Then arrange and resize as you choose
    • Save the report with a unique name and close the report design window
    To Create Multi-report:
    • Select Reports under Objects
    • Click New on the 'database window toolbar'
    • Double click on Form Wizard
    • Select Authors table (or your choice) from Tables/Queries list > Select AuthorName field (or your choose) from Available Fields: list to Selected Fields: list > Select Books table (or your choice) from Tables/Queries list > Select all fields (or your choose) without BookID and AuthorID field from Available Fields: list to Selected Fields: list > Click Next button
    • Click Next button
    • Click Next button
    • Click Next button
    • Click Next button
    • Select a Style and click Next button
    • Type the title, and click Finish button
    ********************

    Copyright MyCorp © 2017