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.
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.
Also We Can Offer!
- Argumentative essay
- Best college essays
- Buy custom essays online
- Buy essay online
- Cheap essay
- Cheap essay writing service
- Cheap writing service
- College essay
- College essay introduction
- College essay writing service
- Compare and contrast essay
- Custom essay
- Custom essay writing service
- Custom essays writing services
- Death penalty essay
- Do my essay
- Essay about love
- Essay about yourself
- Essay help
- Essay writing help
- Essay writing service reviews
- Essays online
- Fast food essay
- George orwell essays
- Human rights essay
- Narrative essay
- Pay to write essay
- Personal essay for college
- Personal narrative essay
- Persuasive writing
- Write my essay
- Write my essay for me cheap
- Writing a scholarship essay