Vbcodes in Timer
Visual Basic and Databases
1. Introducing Visual Basic and Databases
Preview
In this first chapter, we will do a quick overview of what the course entails. We will discuss what you need to complete the course. We’ll take a brief look at what databases are, where they are used, and how Visual Basic is used with databases. And, we’ll review the Visual Basic development environment and the steps followed to build an application in Visual Basic.
Course Objectives
1. Understand the benefits of using Microsoft Visual Basic to build a ‘front-end’ interface as a database programming tool
2. Learn database structure, terminology, and proper database design
3. Learn how to connect to a database using the Visual Basic DAO (data access object) control
4. Use the ADO (ActiveX data object) data control and data environment to connect to a database (Visual Basic 6 only)
5. Learn the use of Visual Basic data bound controls
6. Learn to make database queries using SQL (structured query language)
7. Understand proper database search techniques
8. Learn how to use the Visual Basic Data Manager to create a database
9. Learn database management techniques
10. Learn to create and produce database reports
11. Learn how to distribute a Visual Basic database application
12. Understand connection to remote databases
13. Introduce multiple-user and database security concepts
Course Requirements
An obvious requirement is a Windows-based computer with Windows 95, Windows 98, or Windows NT installed, as well as Visual Basic. The student should be familiar with the basics of using the Windows operating system.
Visual Basic and Databases requires some edition of Visual Basic 5 or Visual Basic 6. There are two controls used by Visual Basic to interact with databases: the DAO (data access object) control and the ADO (ActiveX data object) control. Both controls will be discussed in this course. You should be aware, however, that the ADO control
1. Introducing Visual Basic and Databases
Preview
In this first chapter, we will do a quick overview of what the course entails. We will discuss what you need to complete the course. We’ll take a brief look at what databases are, where they are used, and how Visual Basic is used with databases. And, we’ll review the Visual Basic development environment and the steps followed to build an application in Visual Basic.
Course Objectives
1. Understand the benefits of using Microsoft Visual Basic to build a ‘front-end’ interface as a database programming tool
2. Learn database structure, terminology, and proper database design
3. Learn how to connect to a database using the Visual Basic DAO (data access object) control
4. Use the ADO (ActiveX data object) data control and data environment to connect to a database (Visual Basic 6 only)
5. Learn the use of Visual Basic data bound controls
6. Learn to make database queries using SQL (structured query language)
7. Understand proper database search techniques
8. Learn how to use the Visual Basic Data Manager to create a database
9. Learn database management techniques
10. Learn to create and produce database reports
11. Learn how to distribute a Visual Basic database application
12. Understand connection to remote databases
13. Introduce multiple-user and database security concepts
Course Requirements
An obvious requirement is a Windows-based computer with Windows 95, Windows 98, or Windows NT installed, as well as Visual Basic. The student should be familiar with the basics of using the Windows operating system.
Visual Basic and Databases requires some edition of Visual Basic 5 or Visual Basic 6. There are two controls used by Visual Basic to interact with databases: the DAO (data access object) control and the ADO (ActiveX data object) control. Both controls will be discussed in this course. You should be aware, however, that the ADO control