Microsoft Access 2010 Web Sample Database

Does anyone know how to create the Report Center From from the 2010 Access Sample database. It's the Northwind Traders database. The report center form has command buttons on the right that disply the report in the form, not a separate report, but the report shows up on the form.

Sponsored Links:

Related Topics

Access Web Database
I have downloaded a sample invoice database from templates of Access 2010.

However its in Web Access format. Can I not edit the fields in this in Design View?

How is best way to go about customising it to my liking?

Also does anyone know if I should use Web DB or Desktop DB for a client who will have database on a PC but could host it on server in the future. Would using Web DB make it sort of future proof?


Access 2000 coded forms to Access 2010 web database
Developed an application in A2K need to move it to an Access 2010 web database and in turn publish it to Microsoft Sharepoint live 365.

The Forms contain hundreds of Controls w/thousands of lines of Event code.

Tried import into *.accdb then Save & Publish. In 2010 keep getting: "Forms are Coded" error. Have already tried removing the Events code from the Forms and then pasting it back. NO Go.

Have also tried to import the *.accdb objects into a Blank Web Dbase. Still no go.

Talked w/Microsoft. Told the tech at Microsoft it took a few years to develop the original in A2K and I could probably do it again in half as many years BUT don't have years, have days.

Don't think I'm the only one that has encountered this.

The question: How do You get of the Objects and Code from earlier versions of Access into an Access 2010 Web Dbase?


Where can I see some sample Microsoft Access Database forms/reports/queries etc?
Looking for some ideas or insperation, stuck on something you just can't work out, there are tons of Access/VBA samples on the web, here are some of the ones offered by Microsoft.


Has Microsoft replaced Data Access Pages in Access 2010 with something else ?
Has Microsoft replaced Data Access Pages in Access 2010 with something else ? I have spent considerable time building a large application in Access 2003 which entails Data Access Pages to graphically display my trend line data.

I have installed MS OFFICE 2010. Now those DAP hyperlinks embedded in my application don't work because ACCESS 2010 does not support DAP so I have heard by coming across that fact by chance on TechNet.

I understand that it may force me to go to Web Services. With Web Services, it sounds like I will now have to build a Web site or at least install IIS.

I don't know much about Web Services. I want to keep it simple without purchasing additional software if possible.


Introduction to Data Sheets
Many techniques allow you to create a database, the fastest of which consists of using one of the provided examples. Microsoft Access 97 shipped with 22 sample databases while Microsoft Access 2000 ships with 10. Furthermore, the 97 version allowed to provide sample data into the database. This is not available with the 2000 release. The databases that ship with Microsoft Access can help you in two main ways: they provide a fast means of creating a database and you can learn from their structure.


Whats the difference between a Access Web Database and Access Database?
If I had a sample of Access Web Database using the templates within Access, what problems will I encounter when trying to host it and use it on a desktop computer? Not the web or a server.?


Web Compatibility Checker
The Web Compatibility checker is a cool feature of Microsoft Office Access 2010 which lets you check your database for web compatibility issues. This tool can be really helpful if you want to migrate existing applications to the Web.


Access 2010 and Web Services (not using Sharepoint)
We need to install a database and make data accessible across the internet (via XML/txt or linked tables - can someone give me pointers on this ?

Microsoft's website has a page 'Creating a Web Service data connection' where Access 2010 can create a web service to a source and apparently link tables: the ribbon should have the path 'External Data tab > Import group > Web Service' but my 2010 has External Data > Import & Link > and no web service icon. So I cannot even investigate.

We would like a remote site to ask a question of the server, have the Access database run some selects and transmit to the remote client an XML /txt file etc.


2010 Sample Database Required
I have just started using 2010 and would like to study a sample database
but something with quite a bit of sophistication about it. There are many simple ones out there but something using one or more Navigation Forms, if that is advisable, reports, calender date picker and data validation methods and techniques.

I think that I will learn more this way than ploughing through the guides and help etc


Access 2010 Web
I wish to explore the new web capabilities of Access 2010.

I have search almost everywhere but cannot get the answers.

I understand that Microsoft may be providing hosting services, can someone provide me the URL so I can register / sign-up.
After publishing to Sharepoint with Access Services, how do I set to make it public ie. anyone can use a browser to view without the need to login


Access SOAP Web Service in MS Access 2010
I tried to used information from the following link to access the Web Service and received this Error: The Microsoft Access database engine encountered an error while connecting to DataServices: 'The Model contains Lob System [External System] of Type 'WebService' which is not supported.'

In the screen they show Dialog to Create Link to Web Service which I am not able to find in MS Access 2010. I see a similar screen in Create Link to Data Services and I used that to accessthe Web Service that gave me error specified above.

Do I have to download any add-in to see 'Create Link to Web Service'?


Access 2010 does not display installed Sample Templates
My title says it all. I've found the sample templates at c:\Program Files\Microsoft Office\Templates\1033 (along with the other templates shipped with Office 2010 Pro).

However, I can't find anywhere to ensure that Access is looking there.

I hesitate to Repair Office -- I then have a hundred or so little things that I have to re-tweak. I recently did so to correct something else and I'm still picking settings out of my hair.

Is there a registry setting, or one in the program? What am I missing?!


exposing Access / web services
We need to install a database and make data accessible across the internet (via XML/txt or linked tables - can someone give me pointers on this ?

Microsoft's website has a page 'Creating a Web Service data connection' where Access 2010 can create a web service to a source and apparently link tables: the ribbon should have the path 'External Data tab > Import group > Web Service' but my 2010 has External Data > Import & Link > and no web service icon. So I cannot even investigate.
We would like a remote site to ask a question of the server, have the Access database run some selects and transmit to the remote client an XML /txt file etc.


Microsoft Access Datbase Engine 2010
I have an application that requires Microsoft Access Database Engine 2010. The application tries to install it but fails, I downloaded the .exe from Microsoft and tried running and failed. The message states "The installation of this package failed".

I have Microsoft Office 2003. I even deleted the Microsoft Access Database Engine 2007 from the Contral Panel and tried it but it again failed. Is it a permissions issue?


When web users use 'client' database objects?
I am designing a web database in Access 2010 so that company employees and managers can enter and manage data. As it grows (as databases seem to do), I increasingly want to make some 'client' features available to branch managers - like providing them with detailed financial reports with charts and queries that allow date selection criteria.

Because I'm finding it hard to find an Access Services host, I've not yet been able to trial it.

In the Access help I read that: "People can open the web database in Access, and then use the client objects.

Can anyone who has published a web database assure me that this means that a user who has Access 2010 installed can log in to the web-database - and use 'client' functions? This is what I'dlike to believe from the above,

(and bearing in mind how user permissions are organised in Sharepoint), can I then organise it so that employees have access to one level of data on their web browsers,and managers use their logins to be able to use the more flexible 'client' functions - also by logging on to the web? then MSAccess 2010 really does rock!


Access 2010 User Groups
I have recently started to build a new database using Access 2010 and have now found that the UserGroups have been taken away, and I was wondering if there is a way to set permissions from a table to allow certain users access to certain parts of the database, mostly all form access and then run reports.

Does anyone have an ideas and possible sample they might share to get me going.


Microsoft Access Introduction
Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works.
This tutorial will help you get started with Microsoft Access and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Access, or go to Microsoft's web site located at for further assistance.


Migrating from 2003 to 2010 question
We are about to update to Access 2010 but I saw a note on the Microsoft Web site that said Excel 2010 is required for data import. There was no additional information. Can anyone tell me if I can make Access 2010 work with Office 2003? Or do I need to update to Office 2010 also?

Is there any general advice that you can offer about migrating from 2003 to 2010? Learning curve time? Issues I may need to watch out for? Etc


What's a Web Database?
I am trying to learn something about Access and I have Access 2010. I notice the Web Database choices in the templates. I think they are new since my last look at Access a number of years ago.

I've done some searches to learn more about them but I haven't found answers to my most basic questions.

How do they differ from non-web databases? Are they of any use in a non-Sharepoint context? If made available via the web are they updateable? Via the web?


Secured Database
Can someone provide me with a sample database that is secured in access 2010? The databases that I made with older versions aren't secure in access 2010 The user can go behind the scenes and view tables, queries, etc.