Databases

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

Hands on: Memos are made of this

Access may not have an XML data type but that doesn’t mean you can’t use it

Hands on: A fraction more on fractions

We bring you a distillation of fractional arithmetic

Hands on: Ordering database information

Back to basics with a look at how information is – or isn’t – ordered in your database

Hands on: Organise your website's information

Make your site easy to navigate with any browser, and confound overseas spammers

Hands on: Joined in perfect harmony

Cartesian joins can bite, unless you know how to tame them

Separating data in spreadsheets

Why relational databases separate data and interface; Psion tools and more uses of ‘&’

Hands on: Solving a storage and usabililty problem

How one-to-one relationships can help optimise storage without causing problems for users

Hands on: Organisation in databases

Organise your data by creating many-to-many relationships between multiple fields

Hands on: Importing text into Access

Import data as text strings into a database; plus why MVFs are a pain

Hands on: Inside tables and queries

Make-table and Union queries explained, plus an update on Update queries

Hands on: Slave to your database

Create a telephone extensions database to organise call priorities

Hands on: The future of Access revealed

Jet becomes Ace, and Access breaks a basic rule of relational databases

Backing up an Access database

How complex is it?

Hands on: Tidy up your text in Access

Using text handling functions in Access to manipulate how data strings appear

Ordering data in Access

Building an order database

Hands on: Delete and Append action queries for your database

Delete and Append queries explained

Hands on: Using update queries in a database

Make changes to your data; and a relational database speed fallacy exposed