Databases

Numbering forms in Access 2007

How to put page numbers on forms in Access 2007

How to set your Access display preferences

Make documents open in windows rather than tabs

The link between databases and developers

Delve into the link between database designers and application developers

Inside databases

We look at how valuable information can be – and how to add curious characters to your data

Why does Access treat a phone number as text?

Find out why databases see numbers as text

Using compound primary keys

Discover what compound primary keys can do for your and your data

Hands on: From Access to SQL Server

How upsizing can affect VB code in forms, and using Access to manipulate SQL Server

Hands On: Dates and databases

How to use the Datevalue function to solve data migration woes

Filemaker Pro 10 database software

A streamlined interface makes this database easier to use

Hands on: Connect Access and SQL Server

Just how exactly do you start using a database server?

The art of databases

Mark Whitehorn demystifies the storage and manipulation of data and shows how even the most disorganised among us can learn to love databases

Hands on: Understanding SQL queries

Discover how SQL queries are executed and decide whether to upgrade to SQL Server

Hands On: Link your database to a map

How to make the grid references in a database show up on a map

Hands on: Database normalisation

A discussion about database normalisation and your preferred version of Microsoft Access

Hands on: How to solve a speed-critical problem

We test a mobile broadband USB stick and find a solution to a speed-critical problem

Hands on: Data Basic

Investigate the different ways of handling databases in Visual Basic

Hands on: Getting attached to Access 2007

Take a look at some of the features and the new user interface for this Office package

Hands on: Using SQL sub-queries

Fine-tune your database queries, choose your Access version, and code maps

Hands on: Trawling engines

Just how does a database engine work? Plus a query about organising fishing data

Hands on: Blasts from the past

Time doesn’t necessarily lessen the relevance of database solutions

Hands on: SQL conditions and operators

We continue a tour of SQL querying and look at a solution to the HMRC’s woes

Hands on: Relationships in databases

We explain some of the basics of creating a database and planning relationships

Hands on: Access all images

A picture is worth a thousand words, but takes up considerably more storage space

Hands on: Taking a structured approach

Learn how a little SQL can go a very long way

Hands on: Database values

Discover how to overcome problems when you don’t know what value to enter