A basic overview of Microsoft’s standard database package Microsoft Access?.
This paper gives a brief insight into Microsoft Access??, the database program included in the Microsoft Office? pack, an easy way to manage or share data. It examines the concept of its design so that the entire database works together as a database application and how it intimately relational with the rest of the Office package. It describes how tables, relationships, forms, queries and macros may be created with ease and gives basic examples of how to build them.
There are three different ways to create tables in Access?. Tables can be created in design view, by using the wizard or by simply entering data. In design view, there are three columns to be filled in. They are field name, data type and description. The field name is simply the name of a field within that particular table. In the categories tables, a field name was also called categories. Its description could be simply categories of various products. Field names can be up to 64 characters long but the default is set at 50.