Wednesday, June 22, 2011

Microsoft Access Terminology

 Here we will see what are the different terms that we use in Microsoft Access 2003. These terms will help us in understanding the Access and maintaining the database perfectly.

Terms In Access:

Form: 
 An Access database object is the one on which we place controls for taking actions or for entering, displaying, and editing data in fields. 


Query: 
  A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.


Data Access Page: 
  A Web page designed for viewing and working with data from the Internet or an intranet. Its data is typically stored in an Access database. 

Data Sheet View: 
  A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, we can edit fields, add and delete data, and search for data. 

Sub Form: 
 A form contained within another form or a report.


Hyperlink Field

 A field that stores hyperlink addresses. In an Access database (.mdb), it's a field with a Hyperlink data type. In an Access project (.adp), it's a field that has the IsHyperlink property set to True.


Design view:
 A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.

2 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More