Access

Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Access 2013 web apps are great for collaborating around a common set of data. When people work together in this way, the changes that one person makes to the data often require the attention of someone else. In this article, we’ll describe a technique to build e-mail notifications into your Access 2013 web app using the power of SQL Server and a third-party service called Zapier. You can use this…

Access

Visualize your Access 2013 web app data in Excel

After you start organizing your data with Access 2013 web apps, you may find yourself wishing to visualize or summarize it. For example, imagine you are tracking your deal pipeline in Access, including when you expect to get paid and how much. Wouldn’t it be great if you could make a visual graph of these projections to help you make decisions? Read more to learn how you can do just…

Access

Filter Your Data with Access 2013

As you manage your business in an Access 2013 web app, the amount of information it holds will naturally grow over time. The default views and navigation are great for getting started quickly, but eventually, wading through all of that information by scrolling through lists may not be the most efficient setup. Is there an easier way to create a different view of the data? In Access 2013 web apps…

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…

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.…