Page 261 - Open Soource Technologies 304.indd

Unit 11: Data Base Access

Version History

• 1992 – Access 1.1
• 1993 – Access 2.0
• 1995 – Access 95
• 1997 – Access 97
• 1999 – Access 2000
• 2001 – Access 2002

• 2003 – Access 2003
• 2007 – Access 2007
Questions
1. Explain the concept of data base access.
2. Give the all some description of MS access 2007.

11.6 Summary

• ADO provides a new and powerful means of accessing data stored in database.
• ADO’s object model is simpler than data access objects.
• The remote data control also simplifies, automates, or even eliminates some data
programming tasks.
• Data environment and ADO control expose a recordset to the programmer.
• ADOCE provides a subset to ADO for the windows CE operating system that include
implementation of the recordset and field objects.

11.7 Keywords

Connection string: A connection string is a string version of the initialization properties needed
to connect to a data store and enables you to easily store connection information within your
application or to pass it between applications. Without a connection string, you would be
required to store or pass a complex array of structures to access data. When accessing OLE DB
directly, using IDataInitialize, the connection string is passed as a parameter to create an OLE
DB data source object.
Data source: A data source is a readily accessible object that provides data to any data consumer
(any class or control that can be bound to a source of external data).
RecordSource :The RecordSource property is useful if you want to create a reusable form or report.
For example, you could create a form that incorporates a standard design, then copy the form and
change the RecordSource property to display data from a different table, query, or SQL statement.
SQL: SQL is short for Structured Query Language and is a widely used database language,
providing means of data manipulation (store, retrieve, update, delete) and database creation.
Value property: The Value property makes it easy to access the value of the first element in a
collection of XElement objects. This property first checks whether the collection contains at least
one object. If the collection is empty, this property returns Nothing.

LOVELY PROFESSIONAL UNIVERSITY 255