A table is a collection of data about a specific
topic, such as students or contacts. Using a separate table for each topic means
that you store that data only once, which makes your database more efficient,
and reduces data-entry errors.
Tables organize data into columns (called fields) and rows (called
Create a Table from scratch in Design view
If you haven't already done so, switch to
the Database Window You can press F11 to switch to the Database window from
any other window.
Double-Click on "Create table in Design
view". (DESIGN VIEW)
Define each of the fields in your table.
Under the Field Name column, enter the categories of your table.
Under Data Type column, enter the type you want for you categories.
The attribute of a variable or field that determines
what kind of data it can hold. For example, in a Microsoft
Access database, the Text and Memo field data types allow
the field to store either text or numbers, but the Number
data type will allow the field to store numbers only. Number
data type fields store numerical data that will be used in
mathematical calculations. Use the Currency data type to
display or calculate currency values. Other data types are
Date/Time, Yes/No, Auto Number, and OLE object (Picture).
Under the Description column, enter the text that describes what you
field is. (This field is optional).
No Microsoft Access Articles could be found as of now.
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Introduction into Microsoft Access,Creating New, and Opening Existing Databases,Creating a database using a wizard,Creating a database without using a wizard,Tables - What they are and how they work,Create a table from scratch in Design view,Primary Keys,Switching Views,Entering Data,Manipulating Data