Relational database design theory is an enormous topic, but you can learn a few principles that can get help you design an efficient travel database for your website. Jot down your database's purpose.

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema.

Before you start creating your database tables you should spend a few minutes with paper and pencil to design each table. Yeah, I know, just jump into Access and starting up table designer. I've done ...

On the navigation pane on the left, click the table that contains the field size you want to change. Then click the Design view.. By default, Access will add a Primary key to your table, but in ...