Home

Microsoft Access

Microsoft Access 2010: Saving a Datasheet Filter

Thu, 03/15/2012 - 14:14 — Dawn VanBramer

When you create a filter on the Datasheet view of your query, you may notice that the next time you run the query, the datasheet does not maintain the filter even if you saved the query with the fi

Microsoft Access 2010: Report Layouts

Fri, 07/08/2011 - 11:02 — Dawn VanBramer

Microsoft Access Report Layouts are guides that align controls horizontally and vertically on your report.

Microsoft Access: Union Queries

Tue, 12/21/2010 - 09:35 — Dawn VanBramer

Union Queries are used to combine multiple select queries and return a single result set.

Microsoft Access 2007: Using the Navigation Options to Create Custom Categories and Groups

Fri, 05/14/2010 - 12:02 — Dawn VanBramer

In past posts to the Technology Training Community, you will find information on changing the view of the Navigation Pane as well as information on searching and sorting the objects displayed on the N

Microsoft Access: Replacing null with a zero.

Fri, 10/02/2009 - 15:18 — Dawn VanBramer

If you use a field that contains a null in a mathematical expression, you might get unexpected results. For example, you have a field named cost, which contains the cost of an item.

Microsoft Access: What is null and how do you locate it in your database?

Fri, 09/25/2009 - 15:20 — Dawn VanBramer

Today, I am going to examine Null when associated with text fields.  I will continue this subject in my next post by looking at Null associated with number fields.  A Null value is data that is

Microsoft Access 2007: Exporting a Report to Excel

Mon, 08/10/2009 - 07:32 — Dawn VanBramer

I have been asked a number of times if it is possible to export a report created using Microsoft Access 2007 to Excel.

Microsoft Access: Using a Literal Wildcard as Criteria in a Microsoft Access Query

Thu, 07/09/2009 - 16:49 — Dawn VanBramer

A wildcard is a special character that can represent any character that may appear in the same position in the file.

Microsoft Access: How to Change Text Case to Upper, Lower and Proper

Mon, 06/15/2009 - 12:02 — Dawn VanBramer

I was recently asked if it is possible to change the case of the text in an Access database. The answer is yes.

Microsoft Access 2007:ControlTip Text Property

Fri, 02/20/2009 - 09:08 — Dawn VanBramer

We have all seen ToolTips while viewing a web page or when working within an application. They magically appear to provide us with helpful information.

Syndicate content