Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Access blogs

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012 | no comments
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!

This blog is part of our tutorial on writing SQL.

Why the Easter Bunny prefers SQL Server to Access

Posted by Andy Brown on 30 March 2012 | 1 comment
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

Changing Form Appearance in Access 2007 and 2010

Posted by Andrew Gould on 07 September 2011 | 4 comments
If you've upgraded from Access 2003 to either Access 2007 or 2010 you might be wondering why your forms don't look like forms any more. Read this blog to see how to change a simple setting that will return your forms to their normal state!
Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.
Tags:   SQL / Selecting data   |   Access / Forms and subforms   |   ASP.NET / ADO.NET and data

Access project ADP file extended properties error

Posted by Andy Brown on 21 December 2010 | 1 comment
When you try to view data for a table in an Access project with an ADP extension, Access can throw a wobbly. Here's why!