Access

Thinking about making the change to Office 2013? Changes bring exciting new features, but new versions of your favorite software can take a bit of getting used to.

Today, we’re introducing a new offering for university and college students called Office 365 University. Available in the first quarter of 2013, Office 365 University will be offered online, at retail locations and at Microsoft Stores in 52 markets worldwide.

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.

Access 2013 web apps are great places to centralize your data. You can easily combine data from different external sources with the things that your app unique tracks.

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.

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.

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.

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

You fire up Access and load your favorite app only to see its performance drag like molasses in winter. Access MVP Juan Soto and founder of IT Impact, Inc. shares five performance tips that will tune up your database.

A well designed database stores data in a normalized format with dates defined in a field so that new data is simply added as additional records. However, people want to see data with dates grouped by columns. This can be done by using a crosstab query.

Here’s a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. As the user types, the form filter updates to display full or partial matches for the value entered.