What Is Access?
Access is a pretty versatile product. It can be used as either a database or an application development tool.
Access Is a Database
Database
It is simply a storage place of data. A database has to use some form of logical construct to represent the data within a database (e.g. tables).
Relation or Table
A table or relation is a matrix of row/column intersections where each intersection contains a specific piece of data. Each column represents a specific characteristic of the main table.
Relational Database
A relational database uses the concept of tables to organize the data in a database. Each table usually has some way to relate to other tables. Although the tables are completely independent of one another, they can easily connect data between tables.
SQL
SQL, or Structured Query Language, is a powerful query language that can retrieve collections of related data from a relational database. SQL uses relatively easy syntax to retrieve data while hiding the underlying complex details of the retrieval process.
Data Integrity
Data Integrity is the process of making sure the stored data is reliable and accurate. Using key, table relationships, and field constraints are some ways of making sure the data has integrity.
Access Is a Development Platform
Forms can be created to give a user-friendly face to the underlying data. Reports can be created to represent printable views of the data. Code modules can be used to create reusable sets of instructions for the Access application. Access macro can be used as an alternative to VBA code. Macros allow you to define a variety of actions to specific tasks. Data access pages also exists and are a type of web page that allows you to view and manipulate data in an Access database.
Types of Database Objects
- Tables
- Queries
- Forms
- Reports
- Pages
- Macros
- Modules
Post a Comment