Tables   -    Inputting data

Tables     What is a table?     Table design     Field properties     Inputting data     Relationships     Tutorial  Queries  Forms  Reports  Macros  Modules

The manual input of data into a table is very simple. While your table is in Table View, type the data in the correct field. Follow by inputting the related data for that item in the appropriate fields within the same row entry. It is important to maintain the same row entry for related information, and you'll see why in the Queries topic. Looking ahead, the Forms section will illustrate an example of how to even further simplify the input of in data into a table. IMPORTING/LINKING TABLES Data can also be inputted into an Access database by importing or linking information. Importing information into Access creates a table that will reside within your database, while linking a table provides a link within your database to a table outside of your database. The great thing about Access is that it will accept multiple format types as imported or linked tables. Such acceptable formats are delimited text files, tables from other databases (dBase, FoxPro, etc.), and even Excel spreadsheets. The process for importing or linking tables of information are similar because of the wizard interface. The key in importing or linking information is bringing it in correctly--the clearer definition you provide within the wizard interface, the better your data will work within the database.

Access is a copyright of Microsoft, Inc. No infringement of those rights is intended. Questions or comments -- Contact the author