Database Basics

Short Text

Long Text

String

Text Type

Short Text

Long Text

String

Paragraph

Integer

Real Number

Number

Whole Number

Number

Price

Currency

Expenses

Date

Date of Birth

Date/Time

Calendar

Yes/No

Maybe

True/False

Question

Generate

NewNumber

Autonumber

Automatic

Short text, Long text, Date/Time, Long Text, Yes/No

Short text, Short text, Date/Time, Long Text, Yes/No

Short text, Short text, Date, Long Text, Yes/No

Short text, Short text, Date/Time, Short Text, Yes/No

Add a field called ID of datatype Number and type in data for the ID's. Make this field the Primary Key

Add a field and make it an Autonumber and Primary Key

Set the Date of Birth as the Primary Key

Set the First Name and Surname as a combined Primary Key

You can query it and obtain specific data that is relevant to your requirements

You can enter lots and lots of data and never run out of space

Anybody can access the data and use it

It's easy to use and you never need to worry about it again