Recent Posts

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

3 awesome Access 2013 Web Apps you can build right now

Juan Soto and Ben Clothier, Access MVPs, share some of their ideas on how Access 2013 web apps can be used to solve real-world business problems. They outline how Access 2013 can be used to create mobile dashboards, track inspection reports, or manage work crew scheduling on the road. Take a look for some inspiration to get your creative juices flowing.

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

4 ways to create business apps with Access 2013

There are many ways to build useful apps to run your business with Access 2013. You can download an app via the Office Store, build an app using a Web App Template, or create a Custom Web App. You also have the ability to make a desktop database, just like you always have in Access. Each method offers a fast and easy way to get started. Several members of the…

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

Access 2013 and SQL Server

Access 2013 web apps feature a new, deep integration with SQL Server and SQL Azure. In Access 2010, when you created a web application on SharePoint, the tables in your database were stored as SharePoint lists on the site that housed the application. When you use Access 2013 to create a web app on SharePoint, Access Services will create a SQL Server or SQL Azure database that houses all of…

Access

Get started with Access 2013 Web Apps

You can use Access 2013 and the Office 365 Preview to build a web app almost immediately and start using it to track the things you care about. There’s no need to set up expensive or complicated servers, but you can still take advantage of the speed, security and simplicity that comes with server-based apps. Follow these steps to get started in minutes.