Ole data entry

The OLE field called Foto can be filling even without displaying the object (image) on the screen. The following objects can be stored in the OLE field.

Raster images.

Sound files

Graphs and (diagrams)

Word or Excel

so that they can be seen, hear or use. When placing an OLE-object in the table, you will see text with a description of an object (for example, in the OLE field you can see the inscription PaintBrush Picture). Enter the object in two ways.

Insert from buffer

Insert from the Insert Insert Command -\u003e Object (INSERT-\u003e OBJECT)

MEMO type data entry

The Recenzia field contains MEMO data. This type allows you to enter up to 64000 bytes of text for each record. The table displays only part of the text entered. Press , You can display the dialogue input (zoom) with a scroll bar, which allows you to see to 1,000 bytes of text at once.

Moving by posts in the table

As a rule, after entering data, it is often necessary to make some changes to this may be the following reasons.

Received new information

Errors were detected

Need to add new records

To change the data, first of all, open the table in the Database window, open the table in the table mode, double-clicking on the line with its name in the table list. Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.

If you are in the Constructor mode (Table Design), click the Table View button to go to the table mode to make changes to the data.

Moving on the records

To go to any record, you can simply put the cursor on it or click on it with the mouse, but if the tables are very high, the problem of rapid movement to the desired entry acquires special sharpness

You can use the vertical scroll bar for moving. The arrow buttons on the scroll bar allow you to move the recording marker only for one position in one click so for a faster movement (through several entries immediately) it is better to use the scroll bar runner, you can also click on the area between the slider and the button on the scroll bar to move onto Many positions ahead.

The Edit Team\u003e Go (Edit-\u003e GO) provides several options for quick movement on the table.

Five buttons of transition located at the bottom of the window in the table mode can also be used to move on the records click on these buttons, you can go to any record If you know the recording number (row number for the specified record), click on the recording number field, enter Entry number and press To move in the recording number field, press the key .

When moving on the table, pay attention to the scroll bars. Access will not update the recording number field until you click on any recording field.

Search for a specified value

Although, knowing the record number, you can go to it and find a specific field, in most cases it will be necessary to find in the record a certain value this can be done in three ways:

Select the Edit Team\u003e Find (EDRT-\u003e FIND)

Click on the Find button (Find Specified Text) located on the toolbar (binoculars are depicted on it).

Take advantage of key combination

When using any of these methods, a dialog box appears. To execute the search only on a specific field, place the cursor in it (and do it before opening the dialog box). Install in the Search Only Current Field) in the Checkbox dialog box, and Access will search only in the specified field.

In this dialog box, you can set various search options. In a text field, a sample (Find What) Enter the desired value to be entered in the form in which it is presented in the field, or using the following special characters:

* - corresponds to any number of characters

Corresponds to one symbol

# - corresponds to one digit

To figure out how these characters work, suppose you need to find all the values \u200b\u200bthat begin with AB for this enter AV *

And now assume that you want to find the values \u200b\u200bthat end with the characters 001 in this case, enter * 001. To search for any value that begins with AB characters, ends with characters 001 and contains only two characters between them, you need to enter av ?? 001. If you need to find all the names ending in "KO", then to search for Broadsky and Tchaikovsky values, enter * ko.

In the matching list, the match (Match) contains three options:

With any part of the field (ANY PART OF FIELD)

Fields whole (Whole field)

From the beginning of the field (Start Of Field)

The standard is the entire field option (Whole field), for example, the PET value will be found if the value is equal to Pet. If an option with any part of the field (Any Part of Field) is selected, then the search will be retrieved by Petrov, Petrovsky. Potty, etc, as a result of searching with the installation from the beginning of the field (Start of o, Petrov, Petrovsky will be found.

In the View drop-down list (Search), you can choose one or more options from the set all, up, down (Up, Down, All)

When you select the Options button only in the current field (Search Only Current Field), the search will be kept only in one field checkbox (Match Case) determines whether capital and lowercase letters will differ. By default, they do not differ when searching by Pet value will be found Petr, Peter and Petrov. When installing the check box, you must enter the search bar, taking into account the capital and lowercase letters.

Obviously, for data type (Number), cash (Currency) and date / time (Date / Time), the register of the register does not make sense.) When selecting the check box, Access ignores the checkbox based on the field format (SEARCH Fields as formatted) (If you format the table fields, select this check box) for example, you need to find in the field of the recording of all who born in April 1982 To do this, check the options checkbox (Search Fields As Formatted) and enter APR 92. If you do not install this check box, the search will have to perform at the exact date of birth, for example, search 4/8/92

Using the fields based on the format of fields (Search Fields AS Formatted) can significantly slow down the search.

The search will start after clicking on the Find button (Find First) or find further (Find Next) finding the value, Access highlights it to search for the first suitable value. Click the Find button. To search the following value you need to click on the Find button on the entire search process, the dialog box remains open. Therefore, finding the desired value, click on the Close button to close the dialog box

OLE (Object Linking and Embedding)

OLE (Object Linking and Embedding) - Protocol for binding and embedding objects. Allows you to insert to a document or object of one application (OLE client) Objects (OLE objects) of other applications that support OLE (OLE servers). In Access OLE objects can be inserted, for example, in the field, form or report.

OLE (Object Linking and Embedding) is a protocol for binding and implementing objects. Allows you to use various formats in forms and reports - for example, graphics or documents created in other programs.

OLE (eng. Object Linking and Embedding, pronounced Oh-Lay [Olya]) - Technology of binding and implementing objects to other documents and objects developed by Microsoft.
OLE allows you to transmit part of the work from one editing program to another and return the results. For example, installed on personal Computer Publishing system can send some text for processing in text editorOr some image to image editor with OLE-technology.
The main advantage of using OLE (except to reduce the file size) is that it allows you to create the main file, the functions file to which the program is drawn. This file can operate with data from the source program, which are returned to the source document after processing.
OLE is used in the processing of composite documents (eng. Compound Documents), can be used when transmitting data between different unrelated systems by means of a transfer interface (eng. DRAG-AND-DROP), as well as when performing operations with the exchange buffer. The idea of \u200b\u200bimplementing is widely used when working with multimedia content on web pages (example - web-TV), where the image, sound, video, animation is used in the HTML (Hypertext Marking Language) or in other files, also using text markup (for example , XML and SGML). However, OLE technology uses the architecture of the "Tolstoy Client", that is, a network PC with excess computing resources. This means that the type of file is either a program that is trying to implement must be present on the client's machine. For example, if OLE operates with tables Microsoft Excel.T. excel program Must be installed on the user's machine.

OLE 1. *
OLE 1.0 was released in 1990 based on DDE (Dynamic Data Exchange) technology used in earlier versions. operating system Microsoft Windows.. While the DDE technology was strongly limited in the amount and methods of data transfer between two working programs, OLE had the ability to operate with active connections between two documents or even implement a document of one type into another type of document.
OLE Servers and customers interact with system libraries using virtual function tables (eng. Virtual Function Tables, VTBL). These tables contain pointers to the functions that the system library can use to interact with the server or client. Olesvr.dll libraries (on the server) and olecli.dll (on the client) were originally designed to interact with each other using the WM_DEE_EXECUTE message provided by the operating system.
OLE 1.1 Later developed into the COM architecture (Component Object Model) to work with components software. Later, the COM architecture was converted and became known as DCOM.
When OLE object is placed in the information clipboard, it is saved in the original windows formats (such as Bitmap or MetaFile), and also stored in its own format. Own format Allows you to support the OLE program to implement a portion of another document copied to the buffer and save it in the user's document.

OLE 2.0
The next evolutionary step was OLE 2.0, which preserved the same goals and objectives as previous version. But Ole 2.0 has become an add-in over the COM architecture instead of using VTBL. The new features of the DRAG-AND-DROP, IN-PLACE Activation and Structured Storage technology.

Keywords: ACCESS 2010 database; DB ACCESS; DBMS Access; Access database; Access example; ACCESS programming; Ready database; Creating a database; Database DBMS; Access Courses; Database example; Access program; Access description; Access essay; Access requests; Access examples; Download database Access; Access objects; database in access; Download DBMS Access; MS Access 2003 database; DBMS ACCESS abstract; DBMS MS Access; Advantages Access; database; download the database on Access; Database; relational database; database management systems; Course database; download database; Access database download; Access database download; abstract database; Creating a DBMS; Download passport database; database; Normalization of data; examples of DBMS; Database examples; coursework on DBMS; normalization; database; database structure; example of database; databases; training base data; DB Design; data; database description; DBMS essay; create database; Database of software; the use of database; course work database; ready; Using DBMS; database table; 2008 database download; Base

Cell in the field logical type May contain only one of two values: Yes, or not. Access offers two more logical type names: truth / lies and enabled / off. Regardless which field format you select, the logical field will be presented in the table as a set of flags. When you click the mouse checkbox, it leads to the fact that the box appears in the square, which corresponds to the logical value yes

Reset flag means assigning a logical value to the field of a logical value. Using logic fields may be different, for example, in questionnaires or to create controls.

Field of Ole object

The OLE object field (Object Linking and Embedding) is the latter of the field type selected from the list. It has only two properties: signature and parameter "Required field". Field this type Do not store information as such, but contain references to objects that can be included in the database using the OLE-data exchange protocol. Such objects can be, for example, graphic files.

In order to implement an OLE-object field into the cell, you need to install the cursor and by pressing the right mouse button, call context menu. In it, select Insert Object. The program will reveal the dialog box to select the object type. The object in this case is identified with the application in which it can be created or edited.

The second option insertion of the object - select the Create a switch from the File in the Insert object window. In this case, it is understood that the file already exists, and you need to establish a connection with it. Access will open the window opening window and after selecting the right file Determine what application must be opened to work with it.

Text or combination of text and numbers used as a hyperlink address.

The address is the text specifying the path and file name for the document being opened. The path can be a path to the file written on the hard disk, to be an UNC format address or an URL address on the Internet.

To insert the address in the field, you can use the Hypersdler command in the Insert menu.

Multi-flash databases. Relationship between tables

Relational base Data consists of several tables, the relationship between which is set using matching fields. Each entry in the tables identifies one object. The relationship between objects determines the relationship between the tables. There are 4 types of relationships:

1. The "one to one" ratio means that each entry in the same table corresponds to only one entry in another table. One citizen of the country corresponds to only one passport number, at the same time as one passport number corresponds to only one person.

2. The ratio "one to many" means that each entry in one table corresponds to one or more records in another table. One applicant can act in many universities and at the same time in one university can flow many applicants.

3. The ratio "many to many" occurs between the two tables in cases where:

One entry from the first table may be associated with more than one recording from the second table;

One entry from the second table can be associated with more than one recording from the first table.

For example, the relationship between teachers and students groups. Several teachers lead classes in several groups, and several groups are engaged in several teachers.

In most cases, any two tables are associated with the relation "one - to many".

Creating connections between tables

In order to consider the creation of links between the tables, we will build two tables in the "Consult" database:

1. Table Tabiturients:

Kodab is a key field.

2. Table intersection TSvyazabvuz:

The first two fields are key, and they are other people's keys for the Tsvyaz-Abuza table.

Figure 12.6. Data scheme

To determine connections, you must use the service-\u003e data schema command (button

). If the connection is defined for the first time in the database, the Access will open empty window Data diagram, and then displays the dialog window to add a table. In this window, select the desired tables and click the Add button. In our case, the data schema window needs to add all three tables. Button Close Closes the Dialog Window Add Table (This window can be called by pressing the button.

). After that, the data schema window should look something like that, as shown in Fig. 3 (except connections). To establish a link between TVUS tables and tsvyazabvuz, it is necessary to highlight the code of the code in the twusion table (right-click the "mouse"), drag and omit it on the Code of Code of Code in the TSvyazabvuz table. Similarly, the connection between two other tables is established.

When you release the mouse button, Microsoft Access will open the communication dialog box shown in Fig. 12.7.

Figure 12.7. Configuring links between table fields

After installing the Checking the Integrity of Data, Access makes two more checkbox available two more: Cascade Related Fields and Cascade Removing Related Records. When the Cascade update of the related Microsoft Access fields is installed, updates all the values \u200b\u200bof foreign keys in child tables (that is, in the tables on the side of the relationship "Many" when "one to many" relationship) when changing the primary key value in the parent table, which is on the side of the relationship "One" when communicating "one to many". If you check the Cascade Removal Record Checkbox checkbox, Microsoft Access will delete child strings (related lines in child tables) when removing the parent string (the associated string in the parent table). Check the Cascading Refresh Fields check box so that when changing the Access university code, you automatically updated the entries in the TSvyazabvuz table.

After pressing the Create Access button, will create a connection and draws a line between the two tables indicating the presence of a connection between them. Note: When you ask to ensure the integrity of the data, Access depicts at the end of the line at the table located on the side of the "one" ratio, number 1, and at the other end of the table from the side of the relationship "Many" - an infinity symbol. To delete communication, click on its line and press the DEL key. If you want to edit or change an existing link, double-click on the corresponding line to open the communication dialog window again.

Logic fields

Logical fields are used to store data that can take one of two possible values. Property Field format The logic field allows you to use special formats or one of the three built-in: truth / lies, yes / no or on / off. In this case, the values \u200b\u200bof the truth, and on and on are equivalent to the logical value of TRUE, and the values \u200b\u200bof the lie, no and off are equivalent to the logical value of False.

If you choose the built-in format, and then you will enter an equivalent logical value, the entered value will be displayed in the selected format. For example, if true or ON is entered into the field control item, for which the field in the field is specified yes / no, then the entered value is immediately converted to yes.

When creating a special format, delete the current value from the format property and enter your own format.

Text fields of arbitrary length

Text fields of arbitrary length (Memo fields) may contain the same data types as simple text fields. The difference between these fields is that the length of the MEMO fields can be very large compared to the size of text fields. It may contain a long text or a combination of text and numbers.

Ole field fields

MS Access allows you to store in the image tables and other binary data (for example, MS Excel spreadsheet, MS Word document, sound recording), connected or embedded in Microsoft Access table. For these purposes, the type of data is the OLE object field. The actual amount of data that you can enter in the field of this type is determined by the volume hard disk Your computer (up to 1 gigabyte).

Data Type Wizard

Selecting this data type launches a substitution wizard that creates the field in which the choice of values \u200b\u200bfrom the drop-down list containing a set of constant values \u200b\u200bor values \u200b\u200bfrom another table. Selecting this parameter in the list in the cell starts the wizard wizard that defines the field type.

ACCESS 2010 has the ability to add objects in the field with OLE data type. In the case when the data type is specified as OLE (Object Linking and Embedding- binding and implementing an object), then DBMS Access saves external an objectin shared file Databases, reducing to its storage as much space, how much this object takes in the form of a separate file. Under objectsyou should understand the files created as applications in graphic editors, video clips, in MS Office applications, etc. When filling out the table of data that are objects, in the appropriate field position with the OLE data type, a program is generated by which you can open this object. Displaying an object will be implemented only in forms and reports.

For embedding object In the field C. type of data OLE. You must open a table in "Designer" mode.Add a new field, for example "Photo of goods."Select data type "OLE object field", then save the table.

Then in the "Table" mode In the line for entering data, click the right-hand mouse button, in the menu that opens, select a string with a command, which will open the dialog box (Fig. 3.38, Fig. 3.39).

Fig. 3.38 Insert object

Fig. 3.39 Dialog box for adding a new object in the Access table

It should be remembered that there are two possibilities to embed objects in the form of data. The first opportunity provides the use of standard applications for creating a file that support Access, the second possibility of inserting an object, which allows you to use any file as a data source (Fig. 3.40).

Fig. 3.40 Add a new object in Access Table from File

1. Creating an object from the file.

When it comes to data that is the objects for the database, and are external files, you must have these files. Therefore, you will need to create multiple files in order to further see their display in the database, as well as try changing these files. For example, if you have a photo of an object in the file Monitor.jpg. (JPG - universal photo format). In order for this file to be preserved in the database, it follows in the window (Fig. 3.40) to put a mark "Create from the file" After which the window appears, which is presented in Figure 3.41. Use the button "Overview" You should select the desired file.

Fig. 3.41 File search when creating an object in the database

In the appropriate line for the field, for example, "Photo of goods" Word will appear Package (Package)This means that the file is attached to the application with which it has been created. Therefore, when viewing a database, it will be a request, form or report, the user will see the image of the file in the form of a icon, and when double-clicking this image, the system will first find the application, and then the contents of the file will appear in it (in this example this photo). Exceptions are image files stored with extension .bmp Bit Map Format). However, it should be reminded that the files created in microsoft applicationswill be displayed immediately in forms and reports. Conclusion Simple, photos can be inserted into applications such as Paint, Word, Power Point, save in the form of individual files, and then connect as an object to the database. Try to create multiple files with photos and text using different Windows editors. For example, you can open document Word., insert a photo from the file, add text, and then save as: Monitor.docx(Fig. 3.42).

Fig. 3.42 Photo file created in Word

2. Creating new objects.

Under the creation of new objects in the database, you should imply the use of an application in which the file is created and then connected to the field with a description of the type of this OLE. To start the creation of new objects, you must open the table in "Table" mode, Select option "Create new" In the dialog box (Fig. 3.39), and then in the list allocate "Object type" (necessary app). The list of applications that Access supports to create an object are in the list (Fig. 3.43), which will open after the command is started "Insert the object" .

Fig. 3.43 List of types of Access objects that can be used to create files

For convenience of using applications for creating objects in the form of files, it is that in the future these files can be used to autonomously or implement them in the database.

Consider object creation option for the database using with paint applications.

For example, you need to create an object with an image of an enterprise and text, which in the future user database can be replaced or fixed. To do this, select from the list bitmap Image objectThe further technology for creating an object is shown in Figure 3.44.

1. Open paint.

2. Insert photos from the file.

3. Add text (if necessary).

4. Save how the file.

5. Close the application.

Fig. 3.44 TECHNOLOGY OF THE OBJECT IN PAINT

The task 3.11

1. In the table " Products"In mode "Constructor" Add a new column named "Photo of goods", data type " Field OLE object », Save the changes.

2. In mode "Table" in field "Photo of goods" Choose a string "Insert an object from the file", Select (Point) "Create new" and from the drop-down list indicate document Microsoft Word. . This opens text editor MS Word.Here it is necessary to insert the drawing corresponding to the product in this line. Pictures Select from the list that is stored directly in the editor ("Insert tab", "Picture" icon, in the start dialog box on the start button), or insert the drawing from other programs. You can use the PAINT application (Bitmap Image object), where you draw the goods yourself. Created file Close, it will automatically be tied to your database, to the string in which it inserted.

3. Do this procedure for all rows you tables "Goods".

4. Save the changes.

Control questions

1. What objects can be pasted into the database with OLE data type?

2. How can I insert a photo in the table in the "Table" mode?

3. Where in the database photography will be displayed?

4. What is the difference between the method "Create a new object" from the "Create File" method?

5. How to place the file of the product photos in the database if it has an extension .png.?

6. Is it possible to carry out the edit of the file that is inserted as an object in the database directly in file System Computer?

7. How to insert a presentation to the database?

8. What applications can be inserted into the database?