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…

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

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

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

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.

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…

Access

Introducing Access 2013

The Access team is proud to introduce the Access 2013 public preview, which will make it easier than ever for everyday people to organize the data in their lives and businesses using Access apps. This release focuses on bringing Access databases to the web through Office 365. We’ve made lots of improvements to help you build professional apps more quickly than ever. In addition, your data is now stored in a…

Access

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. However, when creating reports based on crosstab queries, we need to control the specific column names that are returned by the query. Otherwise, the report…