OLE object fields

MS Access allows you to save images and other data in tables (for example, an MS Excel spreadsheet, an MS Word document, a small sound recording). For these purposes, the type of data Field object OLE. The actual amount of data that you can enter in the field for this type is determined by the amount of hard disk space on your computer (up to 1 GB).

Type data master substations

The choice of this type of data is launched by the master of subsets, which creates a field, in which the selected value from the list is propagated, which is revealed, which is to avenge the typing of the postal values, or the value from the other table.

The size of this field is matched with the size of the key field, which is chosen as a substitution (sound, 4 bytes).

Table structure creation

If we looked at the types of data in Access and about the power of the fields in the tables, we can look at the structure of the tables. The creation of the table structure can be seen from the example of the table structure Zamovlennya base of data Borey, which is delivered at once with Access. The table is already in the Borei database, but looking at the process of creating these tables will be more difficult. In order not to destroy the structure of the Borei data base, it is necessary to create the initial data base and open it all the time.

At the window of the table constructor at the table Im'ya fields enter Code .

Press a key Tab or Enter , to go to Stovpets A type danich. To pay attention to the fact that in the lower part of the dialogue there is information in the "Power of the Field" section.

At the station A type danih Significance appeared Text. Press the button to open the list in the right part of the rectangle, and you can click on the list to clear all types of data. From this list, for the help of the mouse, or use the keys up and down to select the value Lichilnik and press the key Tab to go to Stovpets Description Stovpets Description Let me explain how you give your fields. If you are in the future timetable with this table, this description will appear in the lower part of the MS Access screen right away, if you lean in the field Code , she tells you the recognition of this field.

Enter explanatory text at the stovpets Description and press the key Tab or Enter , to go to the introduction of information about the attack field.

Similarly, enter a description of the fields in the tables.

After completing the introduction of the structure of the tables, save її, having finished the command File/Save.

OLE (Object Linking and Embedding)

OLE (Object Linking and Embedding) - a protocol for linking and building objects. Allows you to insert into the document either one program object (OLE client) or another program object (OLE-object) that supports the OLE protocol (OLE server). In Access, OLE objects can be inserted, for example, in a field, a form or a call.

OLE (Object Linking and Embedding) is a protocol for linking and implementing objects. Allows you to change the forms and colors of these different formats - for example, graphics and documents created in other programs.

OLE (eng. Object Linking and Embedding, looks like oh-lay [olіy]) is a technology for linking and implementing objects into other documents and objects, expanded by Microsoft Corporation.
OLE allows you to transfer part of the work to one program editing before and then turn the results back. For example, a visualization system installed on a personal computer can send some text to a text editor, or an image editor can use an additional OLE technology.
The main advantage of using OLE (change file size change) is that it allows you to create a head file, a card index of functions, before starting the program. This file can be operated by the data of the output program, so that after the files are rotated in the output document.
OLE wins when processing warehouse documents (eng. compound documents), can be beaten when transferring data between different systems that do not communicate with each other for an additional transfer interface (eng. drag-and-drop), as well as an hour of operation with an exchange buffer. The idea is to promote widely when working with multimedia on web-sides (for example, Web TV), to de-vigorate the transmission of images, sound, video, animation in HTML-sides (movie hypertext layout) or in other files, which also in text layout (text for example, XML and SGML). However, the OLE technology is based on the architecture of the "common client", so that PCs with overworld computing resources. Tse means that the file type of the program is, as it is supposed to be carried out, it can be present on the client's machine. For example, since OLE operates on Microsoft Excel spreadsheets, Excel can be installed on the host's machine.

OLE 1.*
OLE 1.0 was released in 1990 on the basis of DDE (Dynamic Data Exchange) technology, as it was successful in previous versions of the Microsoft Windows operating system. At the same time, the DDE technology was strongly limited in terms of methods of transferring data between two working programs, OLE was able to operate with active data between two documents or transfer a document of one type to a document of another type.
OLE servers and clients interact with system libraries for additional virtual function tables (VTBL). The number of tables can be used as indicators of the function, as the system library can be changed in interaction with the server and the client. Libraries OLESVR.DLL (on the server) and OLECLI.DLL (on the client) were split up for interoperability with each other for additional support WM_DDE_EXECUTE, which is expected by the operating system.
OLE 1.1 later expanded from the COM (component object model) architecture to work with software components. Later, the COM architecture was redesigned and became known as DCOM.
If the OLE object is located in the clipboard, the files are saved in the original Windows formats (such as bitmap or metafile), and also saved in their own format. The authoritative format allows programs that support OLE to transfer a portion of another document copied to the buffer, and save it in the document's copy.

OLE 2.0
OLE 2.0 is the coming evolutionary rock, which saves you the very goal that is the previous version. Ale OLE 2.0 becoming over the architecture of COM instead of VTBL. New features are the automation of drag-and-drop technology, in-place activation and structured storage.

Keywords: database access 2010; db access; subd access; base data access; access butt; programming access; data base is ready; creation of bazi danih; DBMS database; access coursework; data base butt; access program; access description; access abstract; access ask; access apply; zavantageti db access; objects access; db for access; download subd access; database ms access 2003; subd access abstract; subd ms access; gains access; data base; grab the database for access; bazi danih; relational data base; data base systems; course data base; capture the database; database access cost; bazi danih access profitability; data base; creation of a DBMS; download the passport data base; data base; normalization of data; apply DBMS; data base butt; course work with DBMS; normalization; database; database structure; butt DB; database of requests; initial data base; database design; danih; description of the database; subd abstract; create a database; data base; DB wiki; course work; data base; ready; DBMS wiki; database table; database 2008; base

Logical format

penny format

Number format

Text format

tipi danih

The text field size can be from 1 to 255 characters.

The type of the numeric field can be set to the value from the drop-down list:

byte- Numbers in the range of 0 to 4255;

whole- Numbers of numbers in - 32768 to 32767;

dovge tіle - tіlі of number vіd - 2147483648 to 2147483647;

floating point (4 bytes)- Numbers in the borders of the views - 3.402823E38 to 3.402823E38;

floating point (8 bytes) - numbers between minus 1.79769313486232E308 to plus 1.79769313486232E308.

Date/Hour Format

For data type date hour Use a set of field formats, pointing below at once with butts:

New format (for lock) 04/15/94 05:30:10 PM

Short date format 04/15/94

Long hour 17:30:10

Average hour format 05:30 PM

Short format hour 17:30

For zamovchuvannyam penny format є numbers written with two characters after Komi "R." in kіntsi. Koristuvach can be written in a row Field Format template for your format. It is permissible, it is necessary to enter sumi in dollars. Then you need to insert the cursor on the word penny and replace it with a template format, for example, like this: # ###$ .

Format "lichilnik"

Fields of the type "Lichilnik" have a single function - automatic identification of table records. To that authority, if it could be changed, such a field is not rich. First, lichilnik - zavzhd number. In a different way, the growth of yoga meaning is automatically recognized. Access offers two options for changing the licensor: lastі vipadkovy. The first option is manual, which allows you to number records. Another variant can be twisted, as if it is necessary to create a system for coding records in tables, protected from the unsafe operator's entries.

The middle of a polylogical type can take only one or two values: So or Ni. Access suggests two more options for naming a boolean type: Truth / Nonsenseі Upvoted/Retracted. Regardless of which format of the field you choose, the logical table will have the field represented by a set of paraportions. If you click on the ensign of the mouse, you should bring it up to the fact that the square has an image of a check mark, which confirms the logical meaning So. Skip the standard means assigning the middle of the field of a logical value Ni. The choice of logical fields can be changed, for example, in questionnaires or the creation of management elements.

OLE object field(Object Linking and Embedding) - the remaining field type to be selected from the list. Vіn maє there are only two powers: the signature is the parameter "obov'yazykove field". Fields of this type do not store information, but instead of being sent to objects, they can be included in the database using the OLE protocol for exchanging data. Such objects can be, for example, graphic files.

In order to transfer an OLE-object field into the box, you need to place the cursor on it and right-click the mouse button to open the context menu. Have a new team to choose Insert object. The program opens a dialogue box for selecting the type of object. The object at a time is identified with an addendum, for which a number of redactions can be created.

Another option for inserting an object is to choose a jumper Create from file at the vikni Inserted object. At If you have a problem with getting away, that the file is already available, and you need to install a link with it. Access opens the window for opening the document and after selecting the required file, assign it to the program that needs to be opened to work with it.

OLE object field(Object Linking and Embedding) – the remaining field type to be selected from the list. Vіn maє there are only two powers: the signature is the parameter "obov'yazykove field". Fields of this type do not store information, but instead of being sent to objects, they can be included in the database using the OLE protocol for exchanging data. Such objects can be, for example, graphic files. Navit a better DBMS cannot ensure the preservation of all relevant data for the current day. That is not necessary. It is enough to add a link from an addendum that works with this or that other type of files. For which one use the OLE protocol.

In order to transfer an OLE-object field into the box, you need to place the cursor on it and right-click the mouse button to open the context menu. Have a new team to choose Insert object. The program opens a dialogue box for selecting the type of object. The object at a time is identified with an addendum, for which a number of redactions can be created. As a matter of fact, a jumper Create new. So, the file can't be opened as a necessary file in order to create an object. For example, if a Word document is selected and the prepared document is already on the disk, you can enter it in the editor OK, copy it to the clipboard, and then go to the window of the document linked to Access, and paste it into the buffer. If the object is being created, as if it seems, “from scratch”, then the robot at the chosen appendage is given a great rank. The command to exit the program can also be changed. In this way, it is no longer possible, having closed the program, to open in Windows, but you can no longer turn to Access.

Another option for inserting an object is to choose a jumper Create from file at the vikni Insert object. If you have a problem with getting away, that the file is already available, and it is necessary to install a link to it. Access opens the window for opening the document and after selecting the required file, assign it to the program that needs to be opened to work with it. It is necessary for mothers on the uvazi, that one type of files can be supported by a program. For example, files with BMP extensions are edited by different graphic editors. Selected program Access is launched, and in it the selected file is selected. The listing of the object ends after the closing of the program.

Introduction and editing of data in the "Table" mode

The DBMS switches to the Table mode when the button is pressed. At the top of the table there are special symbols for displaying a new and streaming edited record.

Fig.5. Table window in Table mode

Skin table to replace an empty entry, which follows the remaining essential entry and appointments for the introduction of new data. To enter, move the cursor near the table field and type data on the keyboard. To move to the forward field, press the TAB key, to the forward field - SHIFT + TAB. The entry is automatically saved every hour before the transition to the next entry (the entry marker is left between the tables, changing the form: zamіst olіvtsya z'yavlyaєtsya trikutnik), so there is no need for special data savings for the table. To move between records, you can scroll through the screen buttons at the bottom of the table window (to the first, next, last record).

The active fields cannot be changed: "Lichilniki" fields, the fields that are counted, are blocked by other coristuvachy in collective work with one table. Since the database was entered in the "Read only" mode, entering data is also not available.

Redaguvannya danikh includes the following main operations: changing data values, deleting records, adding records. To correct data in the "Table" mode, there are "manual" methods: move the mouse cursor to the place that is being changed in the table, see the fragment (except for the field, record or step) and end the entry of new data, insert data from the buffer or delete data with the DELETE key .

Ways to see fragments:

Field seen under the clatter of the mouse,

Record(row) see the clapping on the empty syrian klitiny white of the left mezhі vіkna,

Stovpets you can see the clicks on the heading of the column,

Rectangular fragment: see the field in one corner, press the SHIFT key and do not let it in, see the field in the opposite corner (or stretch the mouse).

Whole table you can see the clapping on the gray rectangle near the upper left corner of the table.

For copying data From one table to another (or to the same table), the Windows buffer is drawn:

· See the required data in one table;

· press the "Copy" button on the toolbar;

· Go to the destination field (by pointing to a new mouse or by moving the cursor with the TAB keys),

· Press the "Insert" button on the toolbar.

Variable Data Type OLE Object Field (OLE Object)

The OLE object field is optional, which allows you to link to the objects of another addendum, or to transfer the object to the database. Objects can be simple formatted text, thumbnails, diagrams, sound recording files (.WAV), music in MIDI format (Music and Instrument Digital Interface), animation files (.FLI, .MMM), video clips (.AVI), electronic tables with other additions, yak Software supplement access, supporting OLE, re-integrating with other programs to the package Microsoft office .

Conveyance object is saved from the database file and is available. Let's move the clicks of the mouse on the commission, which to avenge the object, it shows the possibility of editing the object with the help of the program, for which the object was created.

tying object taken from the object file. The object file can be updated independently from the data base. The rest of the changes will be displayed on the screen at the next hour of the next table review. Under an hour of work with the data base, you can also look over that edit object. To display an OLE object in the form or name, it is necessary to create the key element. An object frame has been received.

For example, the LEM FREQUENCY table has the SOUND field added to it, so that it can store the words in the format (.WAV). If there is a sound file on the disk with vim other words for the LEMM_FREQUENCY table, you can link such a sound file with the Sound table field. For this view, the table FREQUENCY_LEM and sort by the field Lema in the order that grows (press the arrow next to the name of the LEMA field and then select Sort from A to Z). Sorting is carried out for the clarity of the search for the necessary word. Let's choose a word, check it out an audio file, for example "grandmother". Next, put the cursor on the field SOUND record z LEMA = granny and press the mouse button to the right. A menu is displayed, in which it is necessary to select Insert object. Vіdkriєtsya vіkno, in which it is necessary to press the button Create from the file, and then select the sound file on the disk with the name of the word "grandmother". At the SOUND field, write package. Now, if you press this file, the program will create sound files (as a rule, the program will Windows Media) that sound the word "grandmother". Takі dії sіd vіkonati z usіma words, kotrim є zvukovі files. As a result of the vikonan operation, the words of the table, for which it is possible to listen to their sound, will be recognized as an appropriate rank (Fig. 14.9).

Mal. 14.9.

Vykoristannya danikh type Hyperpower

Special type of data Hyperposition (eng. hyperlink ) allows you to save hyperspace in the fields of the database table access. Fields with the Hyperposition type are selected for the transition to the objects of the same or the same database access, to documents created by other supplements Microsoft Office and distributions on local or local disks, to Web servers and documents from other resources on the Internet. When you click on the mouse on the hyperspace, a transition is made to the document, which is shown by an addendum that having created yoga.

To attach hyperposilan to the database, it is necessary to add such a sequence to the database. Added to the table FREQUENCY_LEMM field WORDBOOK, as a place of hyperposition on the lexicon articles in the Internet with definitions for this token.

In the Constructor mode, set the type of the field = Hyperforce.

Shukatimemo on the Internet the meanings of the old and not familiar to the modern reader of the words from the fairy tale, for example "zhernovets", "boyar", "kochetok".

For the first word ("millstone") on the Internet, it was far away to know only little ones from the images of the details of hand-made clay, among them there are two small millstones, for example, that tse and є "millstone" (club- kaup.narod.ru/rec/arcussr/tablell2 .jpg). The word "zhornіvtsі" is made as a diminutive of the word zhornіv zgіdno with the tradition of Russian word creation. For another word, "boyar" is the dictionary entry in Wiktionary (ru.wiktionary.org/wiki/boyar). The third word, kochetok, was found on the site "Dictionaries and Encyclopedia Akademik" in the electronic version of Ushakov's Dictionary (dic.academic.ru/dic.nsf/ushakov/842550).

It is necessary to copy in the field the DICTIONARY of the table FREQUENCY. Every year, when pressed against force in this field, the program of the Internet browser is launched, as if opening a web page in a different window of the browser. The appearance of the Access database tables with inserted hyperspaces is shown in fig. 14.10.