Topics Search

Access 2010 Creating Reports

Access 2010 Creating Reports
Views: 52
If you need to share information from your database with someone, but don't want them actually working with your database, you should consider creating a Report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access 2010 makes it easy to create and customize a report using data from any query or table in your database.
In this lesson, you will learn how to create, modify, and print reports.
Sponsored Links:

More topics

 

New Features of Reports in Access 2010

Preview
Creating a report in Access 2010 is a very similar process to creating a report in Access 2007. However, in Access 2010 there are a few new features that pertain to reports...
 

Create Access 2010 Reports

Preview
Access 2010 Report helps user to understand and view records pertaining to the needs. It facilitates users to view the printable version of the records and makes database look fascinating with different colors, charts, themes and fonts. With different themes included in Access 2010, you can choose different styles and designs to apply them over. This post elaborates the basics of creating Access reports.
 

Access 2010 Advanced Report Options

Preview
Access 2010 offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report, whether through the Report Wizard or the Report command, you can then format it to make it look exactly how you want.
In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use Access's formatting options to format text, change report colors and fonts, and add a logo.
 

Access 2010 how to use a navagation form to collect parameters run reports

Preview
Access 2010 how to use a navagation form to collect parameters run reports?
I have created a db and I want to use a tab on the navagation form to show about 5 titles of reports (command buttons). I want the end user to be able to set Start Date and End Date, and use a combo box to select the event and view one of the reports
 

Secure Access Reports

Preview
I have developed 3 small Access 2010 reports that the users can call up, but the users can also modify/change any field in those reports. How do I secure the reports such that the user can view the contents , but will be unable to change any of it's values.
 

How to save a report as a pdf file - 2010

Preview
Just updating our database following conversion from 2000 to 2010.

Used Stephen Lebans code to save reports as .pdf in 2000 but doesn't work well with 2010.

I know 2010 allows reports to be saved as .pdf files but just having a mental blank on how this is done
 

Can't publish Access 2010 reports to SharePoint 2010 site

Preview
I have a 2010 Access database that contains data fueled from a 2010 SharePoint list. From this data, I have created several reports that I would like to make available on the same 2010 SharePoint site in which the data came from.

I'm attempting to do this via Save & Publish>Publish to Access Services. After I enter my SharePoint site's URL and Site Name (I have also run the compatibility checker with no issue), I am asked to verify my credentials. I then receive this error message from Access:

(URL) did not respond. Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older version of Microsoft Access Services that isnot compatible with Access 2010.

According to our IT department "The SharePoint 2010 Central Farm is configured for Access Services. The feature has to be enabled at both the Site Collection and Site level."

I also noticed if I right click on a report, and select Export, "sharepoint" is greyed out.
 

What is switchboard

Preview
A Switchboard is a type of form that displays a menu of items that a user can click on to launch data entry forms, reports, queries and other actions in the database. A switchboard is typically created after all of the forms and reports for a database application have been completed. It can be used to guide the user to an appropriate set of forms and reports.
Note that starting with Access 2010, Switchboards are not available by default (you will need to add this to the ribbon bar manually using the Options). Access 2010 now makes use of the Navigation Forms
 

Save Form In PDF Format

Preview
Unlike previous versions, Access 2010 offers a direct way to publish reports and forms in widely used document publishing format – PDF. Once you’ve done creating your forms in Access 2010, you can export the form into PDF and XPS format
 

Managing headers across forms and reports

Preview
I am creating a DB with several forms and reports and would like all the forms to have the same header section with a logo and nearly all the reports to have another one.)

I’m using Access 2003 and have not found anyway of creating master template to do this and am thinking the best way would be to define a common Word object and paste the same object to each form/ report.

Is there a better way?