Database Management System MS Access, MS Access Architecture...

MS Access Database Management System

MS Access is a relational database service system.

Before starting practical work with MS Access, it is useful to get a general idea of ​​this program, to try to understand the interconnection of the main components of MS Access, in order to navigate within the DBMS.

MS Access Architecture

In MS Access, everything that a name can have (in the sense of Access) is called objects. In the Access database, the main objects are tables, queries, forms, reports, a data access page, macros and modules.

Table is an object that is defined by the user and used to store data. Each table contains information about subjects of a certain type (for example, students). The fields (columns) of the table serve to store various characteristics of subjects (for example, names, addresses of students), and each record (line) contains information about a particular subject (for example, data

about the student but the names of Ivanov). For each table, you can define primary key (one or more fields that have unique values ​​for each record) and one or more indexes that accelerate access to data.

Inquiry - An object that allows the user to retrieve the required data from one or more tables. To define a query, you can use the QBE (Query By Example) form or write an instruction in the SQL language. You can create select requests, update, delete, or add data. Using queries, you can also create new tables using data from one or more existing tables.

Form is an object intended primarily for data entry and editing. The form is a form to be filled in, or a mask-form that allows you to limit the amount of information available to the user.

Report - an object for calculating totals and printing the selected data.

The tables store data that can be retrieved using queries. Using forms, you can display the data on the screen or change them. Forms and reports receive data both directly from tables and through queries. To perform the necessary calculations and data formatting, queries can use built-in functions or functions created with VBA

Events occurring in forms or reports can run VBA macros or procedures

Using macros and modules, you can change the progress of the application; open, filter and modify data in forms and reports; perform queries and create new tables.

Importing data

Although it is possible to use MS Access as a closed system, one of the main advantages of this product (which is clear from the 100th name: Access - access) is the ability to work with a wide variety of other databases, spreadsheets or text files.

Working with your own database, you can import or link data stored in other MS Access databases, in dBASE files and in any other databases that support the ODBC standard. You can also export data from Access tables to databases, spreadsheets or text files.

In MS Access, the SQL (Structured Query Language) is used to read, insert, update, and delete data. This language was created in the 1970s. in IBM for relational databases and is subsequently approved as their official standard.

Ideally, any software product that uses the SQL language should be able to communicate with any program that understands the same language. For various reasons, different dialects or extensions of the SQL language appeared, which differ from the official standard.

In the 1990's. The Common Language Interface (CLI, standard language interface) interface for all major dialects of the SQL language has been developed. The formalized interface is called ODBC.

Importing MS Access objects

To import an object from another Access DB, follow these steps:

Open the Access database into which you want to import the object.

On the External Data tab in the Import group (Figure 10.3), select one of the available data sources.

Then follow the instructions in the dialog boxes.

External Data/Import group tab>> </p>

<p> <i> <strong> Fig. 10.3. </Strong> </i> <strong> The External Data/Import Group tab</strong> </p>

thematic pictures

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)