Database Introduction

If we look up the definition of a database we get the following answers:

1. An organized body of related information.

2. A Database is a structured collection of records or data that is store in a computer system. The structure is achieve by organizing the data… more

Here are some examples of relational database designs.

In the first example, we are making a database for tasks that need to be done. There is a table of task which will list in a company or the different task for the day or the week this will be done after a meeting and each task is given a priority so we have another table showing the priorities… more

The main advantages of a database are as follows:

Less Inconsistancy

A database is designed so that each piece of information is held just once. If that record is changed then it is changed for all reports… more

If you have lots of data and you’re not sure whether to use excel or access then hopefully this will help you. They are very similar and the main difference is that excel is good for having one list, for example list of people, list of customers, a list of songs and access is good when you have 2 or more lists and they need to be joined together… more

Default values – This is a value that will be entered automatically if the user doesn’t enter a value. For example, if they’re making an order and the number of item is not specified then probably you would use a default of one so that one item will be ordered… more

Free Database Tutorials From VTC:

Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97

Database Optimization
Data Modeling
Visual Basic for Access

For more free database, programming or software tutorials click here and do a search or click one of the categories.