This tutorial demonstrates how to import an Excel file into an Access database. You can also follow these same steps to import other data tables into Access, such as dbf files or txt files, with some minor variation. This document uses some standard database terminology, referring to columns as fields and rows as records.
Read the rest of this entry »

• 0 Comments

Basic Database Terminology Many relational database concepts are really quite simple. In fact, much of the appeal of relational databases stems from the simplicity of their foundational concepts. Structural Terminology Within the database world, MySQL is classified as a relational database management system (RDBMS). That phrase breaks down as follows:
• The database (the “DB” in RDBMS) is the repository for the information you want to store, structured in a simple, regular fashion: o The collection of data in a database is organized into tables. o Each table is organized into rows and columns. o Each row in a table is a record. o Records can contain several pieces of information; each column in a table corresponds to one of those pieces.
Read the rest of this entry »

• 0 Comments

Definition Index entries are maintained by documentation developers in the Knowledge Warehouse [Ext.] (KW) in order to help users find information more easily by means of an index. Use Index entries created from the Knowledge Warehouse are now stored in SAPterm and can be changed there as well. Index entries can only be created in info object maintenance in the Knowledge Warehouse. For more information, see Creating Index Entries in the Terminology Database [Ext.]. You can, however, change index entries in SAPterm by selecting an index entry from the results list [Page 13] and choosing Maintain entry.
Read the rest of this entry »

• 0 Comments