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:

Similar posts...


New Features of Reports in Access 2010

New Features of Reports in Access 2010 Icon
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

Create Access 2010 Reports Icon
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

Access 2010 Advanced Report Options Icon
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.

Can't publish Access 2010 reports to SharePoint 2010 site

Can't publish Access 2010 reports to SharePoint 2010 site Icon
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

What is switchboard Icon
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

How to save a report as a pdf file - 2010

How to save a report as a pdf file - 2010 Icon
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

Create Backup Of Access 2010 Database

Create Backup Of Access 2010 Database Icon
Creating backup of databases is the most important thing and must not be overlooked. Access 2010 offers a simple and easy way of creating backup of database you’re working on. To begin, open the Access 2010 database and close down all table fields. Now on File menu, click Save & Publish.

Save Form In PDF Format

Save Form In PDF Format Icon
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

Need to only allow users to use forms/reports in 2010 Access database

Need to only allow users to use forms/reports in 2010 Access database Icon
I have been all over the internet reading about Access 2010 security and how user-level security is not in this latest version of Access.

I have built a database of our clients' contracts and other information. I have coworkers that are seriously technologically challenged. I want them to be able to use the database to lookup information on their particular clients that they manage by using reports and forms that I've created.

I do not want them to be able to manipulate the data in any way because they would do something, click somewhere and not know what they did or where they clicked.

I split my database but there is still access to the tables and they can be changed so that's not the answer. I was hoping there was a way to only allow them to see reports and forms sothey wouldn't be able to inadvertently mess up the database.

report filter not working in Access 2010 SP1

report filter not working in Access 2010 SP1 Icon
Windows auto installed Office 2010 SP 1 and now my Access 2010 reports no longer work. It is a Access 2003 mdb file running in Access 2010. It was working fine till SP 1 was installed.

DoCmd.OpenReport strReportName, acViewPreview, , strSQL

the report opens fine, but no longer filters like it used to. (In my case I am filtering dates, using the # characters.)