Wise Owl Training - Access blogs

Showing blogs 1-7 (out of 7)

Access 2013 - an overview of the new web app feature

Posted by Andy Brown on 09 January 2014

Access 2013 will still look familiar to existing Access users, but it now includes the facility to develop and publish web applications. This blog explains the thinking behind Microsoft's radical move.

Link SQL Views to MS Access using VBA

Posted by David Wakefield on 26 June 2012

How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.

Tags:   SQL | Views    |    Access | Importing and linking    |    T-SQL | Other

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012

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!

Tags:   Access | Designing databases    |    SQL | Tables and columns    |    T-SQL | SQL Tutorial

Why the Easter Bunny prefers SQL Server to Access

Posted by Andy Brown on 30 March 2012

The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

Tags:   Musings | Random musings    |    Access | Designing databases

Changing Form Appearance in Access 2007 and 2010

Posted by Andrew Gould on 07 September 2011

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!

Using SQL UNION queries to populate the first Item in a list type control

Posted by David Wakefield on 31 May 2011

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 webforms | ADO.NET and data    |    T-SQL | Other

Access project ADP file extended properties error

Posted by Andy Brown on 21 December 2010

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!

Tags:   Access | Tables and fields    |    SQL | General    |    T-SQL | Other
This page has 0 threads Add post