The objective of this tutorial is to learn how to establish a link between a Microsoft Access database and an application written in Visual Basic. Create a suitable user interface for the database in Visual Basic. Establish a link between MS Access tables and fields and appropriate interface controls in Visual Basic. A table is a collection of records which are all of the same type and structure.
Fields are the smallest unit of data addressable in Access.
Each patient would have one record. A single doctor s set of patient records would then form a table. The overall medical database would then hold tables for all the doctors working in the current practice. MS Access is a very powerful database with its own Basic language built in. However, this language is only a subset of Visual Basic, therefore sometimes a system may require a VB solution but still be handling large amounts of structured information.