Access

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

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…

Access

Access 2010: How to write expressions for Web queries, forms, and reports

Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where…

Access

Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory’s large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the…