Excel

Plug into your data: Connecting Excel to an Access database

Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But…

Access

Data entry made easy

In Access 2013, we’ve made a lot of changes so that you can quickly make a great user interface for your web databases. First, Access 2013 will automatically generate useful views based on your data. Second, you’ll be able to use special controls for dealing with related data—the related items control and the autocomplete control. With this interface, the people who use your app will have easy time entering data.…

Access

Automatically relink Microsoft Access tables

Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables. In this…

Access

Recommended Reading

We’re wrapping up another outstanding week of the Office Preview release. We are getting a lot of great feedback, and hope to get much more. Please continue to help us by sending us your smiles and frowns, and forums feedback on Microsoft Answers, TechNet and MSDN coming. This week many teams across the division have begun blogging about their specific investments. There is a ton of great information out there…

Access

Introducing Access 2013

The Access team is proud to introduce the Access 2013 public preview, which will make it easier than ever for everyday people to organize the data in their lives and businesses using Access apps. This release focuses on bringing Access databases to the web through Office 365. We’ve made lots of improvements to help you build professional apps more quickly than ever. In addition, your data is now stored in a…

OneDrive

Office and the Cloud

  The transitions that organizations and people are making to the cloud enable many new opportunities for sharing with others.  We believe that the best way to leverage the cloud is to connect the best-of-breed applications to feature-rich services.  We do not believe that a one-size-fits-all browser based solution is suitable to meet the needs of both work and personal computing because it misses so many opportunities to leverage the…