Access

Moving and backing up your Access 2013 web apps

When files live on your computer’s hard drive, there’s a risk that they could be damaged, lost, corrupted or deleted. To protect against this, most savvy businesses make copies of important files in separate locations. In a similar way, Microsoft takes many precautions to make sure your Access 2013 Web Apps on Office 365 are backed up and always available. However, making your own backups is still a good idea.…

Access

Moving data forward into Access 2013

Access 2013 is all about enabling you to build data-centric business apps on the web. Frequently, the data you care about—a customer list, a product spreadsheet, or a legacy Access database—already exists somewhere else. How can you get this data into your Access web app?  Obviously, copying each record would take a long time. That’s where data import can be a huge time saver. Doug Taylor, a Program Manager on the Access…

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…