Access News and Insights | Microsoft 365 Blog

Published February 4, 2013

1 min read

Download our free Office 2013 Quick Start Guides

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.

Published October 19, 2012

2 min read

Office 365 University for Higher-Education Students

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.

Published September 14, 2012

3 min read

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.

Published August 30, 2012

3 min read

Connect your Access 2013 Web Apps to SharePoint Lists

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. Lois Wang, a Program Manager on the Access team explains how your Access apps can connect to and display real-time data from SharePoint lists.

Published August 14, 2012

2 min read

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.

Published August 13, 2012

5 min read

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.

Published August 8, 2012

4 min read

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.

Published August 3, 2012

4 min read

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.

Published July 30, 2012

3 min read

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.

Published July 10, 2012

2 min read

5 tips to make your Access database super-fast

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.

Published May 23, 2012

2 min read

Using crosstab queries in reports

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.

Published May 3, 2012

2 min read

Using a Combo Box to search as you type

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.

Product: Access

Download our free Office 2013 Quick Start Guides

Office 365 University for Higher-Education Students

3 awesome Access 2013 Web Apps you can build right now

Connect your Access 2013 Web Apps to SharePoint Lists

Plug into your data: Connecting Excel to an Access database

Data entry made easy

Access 2013 and SQL Server

Automatically relink Microsoft Access tables

Get started with Access 2013 Web Apps

5 tips to make your Access database super-fast

Using crosstab queries in reports

Using a Combo Box to search as you type

Get started with Microsoft 365