Introduction To Tables

Introduction:
The Table is the central point of your database. That's why you should and will spend some time planning, organizing and tuning your tables.

Start Microsoft Access and open the Books database that you created last time.

Creating A Table From Scratch:
You obtain a table from three ways in Microsoft Access: a table can be created from a template database; you can also use a wizard to create a table; or you can create a table from scratch. Still, you can use any combination of features and techniques to design your table(s).
The database window is a little different from Microsoft Access 97 to MS Access 2000.

From the Database Window, click the Tables button if necessary.

The Database Window offers three ways of creating a table. The first option allows you to create a table from the Design view. If you need help from a wizard, you use the second button. The third button is used to create a table from the Datasheet view.

From the Database Window, click New.

You receive a dialog box offering various ways of creating a table.

The Datasheet View allows you to work in a spreadsheet environment with a window made of rows and columns. The Design View is a little more explicit and detailed, it offers more control while you are designing your table. Since Microsoft Access comes with a host of sample tables, you can use the wizard to design and customize your table to suit your needs.

On the other hand, you might have a good existing table somewhere either in your computer, on the network or somewhere else; then you have the choice of importing it or linking to it. Click Datasheet View and click OK.

You are presented with a window document that looks like a spreadsheet. This is your first table.


Source : Microsoft Access Tutorial - Function-X