1.ADO(Active data object):
This new data access technology features a simpler object model, better integration with other Microsoft and non –Microsoft technologies, a common interface for both local and remote data access, remote and disconnected record sets, a user accessible data binding interface and hierarchical record sets.
OLEDB is a set of COM interface that provides application with uniform access to data stored in diverse information sources both relational and non-relational. These interfaces support the amount of DBMS functionality appropriate to the data source, enabling it to share its data. ADO (Active data control) is the way that programmers access OLEDB.
3. Interactive development:
The traditional application development process can be broken into distinct steps: a. Creating a user interface by placing control on forms.
b. Setting attribute for the forms and control displayed on the forms. c. Writing code
d. Testing the program and running it. Visual Basic has powerful debugging tools for this purpose. e. Visual basic interprets the code as it being entered, catching and highlighting most syntax error. It’s almost like an expert watching over your shoulder as the code is being entered. Visual basic also partially compiles the code as it is being entered.
4. Visual basic database tools integration:
Enterprises edition visually create and modify database schemas and queries, create SQL servers and MS-Access database tables,drag and drop to create views, and automatically exchange column data types.
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other Access databases, Excel, HTML, XML, Outlook etc. Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Features-: Users can create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control. The original concept of Access was for end users to be able to “access” data from any source Uses-: Microsoft Access is used to create simple database solutions. Access tables support a variety of standard field types, indices, and referential integrity. Access also includes a query interface, forms to display and enter data, and reports for printing. It is also easy to place a database on a network and have multiple users share and update data without overwriting each other’s work. Data is locked at the record level which is significantly different...