Apr 23

Microsoft Access versus Microsoft Excel for Data Analysis and Reporting

Microsoft ExcelMicrosoft AccessChoosing Between
Spreadsheets and Databases

We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. We’ve written a new paper that describes the issues in detail:

  • How Microsoft Access and Excel Empower Information Workers
  • Advantages of Microsoft Excel Spreadsheets
  • Disadvantages of Microsoft Excel Spreadsheets
  • Advantages of Microsoft Access and Databases
  • Disadvantages of Microsoft Access
  • How they Should Work Together

Paper: Microsoft Access versus Microsoft Excel for Data Analysis and Reporting (Spreadsheets vs. Databases)

Mar 26

Microsoft Access Form Selecting the First Item in a ComboBox or ListBox

When working with ComboBoxes and ListBoxes, we often find the need to select the first item in the list by default. This can be done when the form loads, or when the rowsource values of the ListBox or ComboBox are changed.

We’ve written a new paper containing an explanation and sample database of how to do this with the ItemData(0) property.

Our example database contains a form with a ComboBox containing ProductCategoties, and a ListBox containing Products.

Select the first item in a Microsoft Access combo box

When the form loads, it selects the first Category in the list. When the Category is changed, the Products list is updated, and the first product is selected.

To learn more, read our tip on Microsoft Access Forms: Selecting the First Item in a ComboBox or ListBox and download our sample database.

Mar 23

Microsoft Access Forms with Cascading Combo Boxes and List Boxes

Microsoft Access
In Microsoft Access, a common need is to have multiple combo boxes or list boxes on a form, and to have the selection in one combo box limit the choices in a second combo box or listbox. For example, consider an Address form containing State and City lookups. When you select a state, you want the list of cities list to be limited the selected state.

This is known as cascading combo boxes or synchronized combo boxes

We recently posted a tip and demo database containing a sample of species, both plants and animals, categorized by their taxonomic rank (kingdom, phylum, class, order, family, and genus). When you select the value “Animal” from the Kingdom combo box, the Phylum combo box is updated to only show Animal phylum. The Species list box is also filtered by your selection.

To learn more, read our Microsoft Access Cascading Combo Boxes tip and download our sample database demonstrating how to create cascading combo boxes and list boxes.

Feb 16

Linked In Communities for the Microsoft Access, Azure, SQL Server and Visual Studio .NET Communities


LinkedIn
LinkedIn offers many opportunities for professionals to interact with each other. There are many groups available for the Microsoft Access, Azure, SQL Server, and Visual Studio .NET communities. Here are some of the vibrant groups we’ve discovered:

Microsoft Access, Excel and VBA

Microsoft AzureMicrosoft Azure and SQL Server


Visual Studio .NET