background preloader

Access

Facebook Twitter

Changes in Access 2010. Published: May 12, 2010 IT Pros can learn about the new, changed, and deprecated features of Microsoft Access 2010 and how these changes can impact migration plans.

Changes in Access 2010

If you are migrating from Microsoft Office Access 2003, we suggest that you review Changes in Access 2007 ( and Migration considerations for Access 2007 ( In this article: This section highlights new features in Access 2010 that might be of more interest to IT administrators. You can find additional resources in the Access 2010 Resource Center on TechNet Share a database on the Web In Office Access 2007, there was limited support in sharing a database to the Web, where you could only publish your lists and move the database to document libraries.

Export to .pdf and .xps In Access 2010, you can export data to a .pdf file format (Portable Document Format) or an .xps file format (XML Paper Specification) to print, post, and distribute e-mail. Connect to a Web service as an external data source Backstage view Enhanced security. Microsoft Access 2010 - Lesson : You will usually not provide tables to the users for data entry. Instead, you will use objects called forms. A form appears in a view friendlier than that of a table. Here is an example of a form presented to a user: For you as the database developer, a form only serves as a relay between the source of data, which can be a table, and the user who looks at it. Of course, in order to have a form in your application, you must first create it. When it comes to data of a database, there are two broad types of form: data-unrelated and data-related. Although most of the forms you will use in a database are meant to display data from a table, you can create an independent form whose functionality and behavior do not depend on the data from a database.

To create a blank form, on the Ribbon, click Create and, in the forms section, click Blank Form. The other category of form involves those used to display data to the user. To launch the Form Wizard, on the Ribbon, click Create. Examples of query criteria - Access. When you want to limit the results of a query based on the values in a field, you use query criteria.

Examples of query criteria - Access

A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query. If the value for that field in a given record is "Chicago", Access includes the record in the query results. This topic lists several examples of query criteria. It assumes that you are familiar with designing simple select queries. To learn more about creating select queries, see the article Select data by using a query. In this topic Introduction to query criteria A criterion is similar to a formula — it is a string that may consist of field references, operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression.

The following tables shows some sample criteria and explains how they work. Tips and Techniques for Queries in Access 2007. Summary: Learn about queries and their uses in Microsoft Office Access 2007. (29 printed pages) Luke Chung, President of FMS Inc August 2009 Apples to: 2007 Microsoft Office System, Microsoft Office Access 2007 Contents Download the Sample Access Database Microsoft Office Access 2007 is the most popular Windows database program.

Tips and Techniques for Queries in Access 2007

The visual representation of tables and the graphical links between them makes Microsoft Access queries extremely easy to use. Knowing the many features of Microsoft Access queries allows you to perform advanced analysis quickly without programming. Microsoft Access supports many types of queries. Select Queries Retrieve records or summaries (totals) across records. Select queries are the most common queries and can be used for viewing and a data source for forms, reports, controls, and other queries.

The most basic Select queries retrieve the records you specify from a table. Selecting Tables and Fields Sorting and Reordering Fields Renaming Fields Figure 1. Top Values.