Access

Feral Cats: Managing Access databases in your organization

It’s every IT manager’s worst nightmare: thousands of Access databases are running wild in your organization and you don’t know how to manage them. One CTO described compared the situation to feral cats wreaking havoc. Fortunately, Access 2013 features some great improvements that will increase the manageability of your desktop databases. Plus, moving forward, you’ll be able to take advantage of Access 2013 Web Apps, which take manageability to a…

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…