One of the two sample databases that comes with Visual Basic is called BIBLIO. The BIBLIO database has a simple structure, almost trivial, but it demonstrates many of the topics we have covered 80 far. You can open the BIBLIO database With the Visual Data Manager and explore its structure. The BIBLIO database contains book’ titles, authors, and publishers, and…

Read More →

The Visual Data Manager is a Visual Basic tool for designing databases. Although it’s rather crude, you can use the Visual Data Manager to create and modify tables, to implement security, and to experiment with SQL. When you open an existing database, the Visual Data Manager displays a database window listing the tables and properties of that database. Figure…

Read More →

The databases described and used so far are relational because they are based on relations among the tables. The foundation of a relational database system is to break the data into multiple tables that are related by common information (keys). Suppose you are designing a database for storing invoices. This database should have a table with customer names,…

Read More →

RecordSets are the foundation of database programming. Let’s look at an example that will help you visualize RecordSets and explore the Data control. The Datal application, shown in Figure 17.3, is nothing less than a frorv end for an existing table in a database. VB6 at Work: The Data1 Project To build this application, follow these…

Read More →

Nearly all business applications need to store large volumes of data, organized in a format retrieval. This is’accomplished with a .da.tabasemanagement system (DBMS), a mechanism for manipulating tabular data with high-level commands. The.database management system hides low-level details, such as how data are stored in a database, and frees the programmer to concentrate on managing…

Read More →

If there is one topic that’s too big to fit in a single chapter, it’s database programming. This chapter, therefore, is an introduction to the basic concepts of database programming with VISual Basic. It’s primarily for those who want to set up small databases and for those familiar with other database management systems, such as…

Read More →