How to create a database:

• Before creating a database, first think about what kind of information you'll want to store about each asset, person, project or image. If you want to creat a customer information database, you might want to store a name, contact information, address, map, product purchased, meeting dates, notes and a photo.
• Design one or more on-screen forms where you'll enter and view your information. To create a database, you can just drag the mouse to draw a rectangle, name the field and indicate what type of information it will contain: text, number, date, time, media file, etc.
• Select a look you like. When creating a database, you can select fonts and colours for your forms and fields and also add a logo. Some easy database management systems let you apply a professionally designed colour-and-font theme with one click to create a database that looks great.
• Add your information. After you've created a database, simply enter or import your information into the fields.

Creating a database from a template

You can create a database on your own or create a database using a pre-designed template for uses such as contact management, stock control and expense records. These templates have been designed using the most commonly-requested fields, so you may not need to make any changes. If your needs are different, you can easily modify the template by adding or deleting fields and changing the fonts and colours.

Creating a database from an existing spreadsheet

When creating databases, it's very easy to start with lists stored in an existing spreadsheet. The database management system creates fields with the same name as your spreadsheet column names, and then creates one database record for each row in the spreadsheet.