Advice 1: How to insert a picture in database

The contents of the databases (DB) stored in tables, but the user information is usually presented in a more convenient form - create forms and reports. For clarity, they include a variety of images: photos, pictures, emblems. Graphic information is easier to store in a special table fields. Microsoft Access supports several options for downloading images in database data.
How to insert a picture in database
You will need
  • - Microsoft Access;
  • graphic file containing picture.
Instruction
1
Add an OLE object field in a database table. In this application, Microsoft Access can store images. Open the desired database in the tab "Tables", select the item in which you want to place the image. Call the constructor for the table. Editing its structure, add another field with data type "OLE object Field". Give it a name and save the database changes (File - Save).
How to insert <b>image</b> <strong>database</strong> data
2
Place in the created cell of a field OLE object, i.e. the picture. To do this, open the table in view mode. You will see the added column. Place the cursor in the desired cell and click the right mouse button open the context menu. Click "Add object".
How to insert <b>image</b> <strong>database</strong> data
3
In the dialog box, select one of the options added. You can insert an existing graphic file or create it first in the appropriate editor, and then link from the current database. In the first case, select in the field "object Type" application in which you want to create a new image, for example, "Paintbrush picture". Click the OK button, and simultaneously start the program editor. The introduction of the object in the database the data will end after you created the image, close the graphics application.
How to insert <b>image</b> <strong>database</strong> data
4
To insert in the table field of the existing image, select the second option activate in the dialog box labeled "Create from file". Click on the "Browse..." and specify the path and name of the graphic image file. Preferably on a disk to have a picture format .bmp or .dib. You need to include in the window the checkbox "Link" – this will allow the DBMS to track changes to the graphic file and reload the image in the table.
How to insert <b>image</b> <strong>database</strong> data
5
Confirm the file download by pressing the OK button, and then save itself to database data. When you open the table in browse mode in the OLE object field to be displayed is not the picture itself, and the inscription "Bitmap". The graphic image will be loaded from the table when you create and work with forms and reports.

Advice 2 : How to insert image in html table

The html language is not perfect and has some significant drawbacks. To assign a picture to a specific place on the page, it is better to insert it in the table. In this case, the image is considered as background and on top of it you can put text.
How to insert image in html table
Instruction
1
You first need to create the table if it does not. This is the attribute of <body>. For this purpose, a tag (end tag required):
• <table> - table;
• <tr> - string;
• <td> the column.

The main extra attributes:
• Border – border;
• Align – horizontal alignment;
• Valign – vertical alignment;
• Bordercolor – the border color;
• Width – width;
• Height – the height.

The syntax of the 2X2 table with no border and a left/right alignment of the content:
<table border= "0">
<tr align="left">
<td>the Contents of the 1st cell</td>
<td> Content of the 2nd cell </td> </tr>
<tr align="right">
<td> the Contents of the 3rd cell </td>
<td> the Contents of the 4th cell </td> </tr>
</table>
2
The picture you need to register after the <td> tag. If you insert the image in the first cell of the table presented above, we get:
<table border= "0">
<tr align="left">
<td><img src="address of image format gif, png, jpeg"></td>
<td> Content of the 2nd cell </td> </tr>
<tr align="right">
<td> the Contents of the 3rd cell </td>
<td> the Contents of the 4th cell </td> </tr>
</table>

Additional attributes:
• Width – width;
• Height – height;
• Alt - alternative text to be displayed to a user if he disabled the feature of viewing images;
• Align – horizontal alignment;
• Valign – vertical alignment;
• Title – the caption of the image.
3
The image can be used as a reference. For this purpose it is sufficient to vest in the relevant tag: <a href="page that navigates"><img src="file name.png"></a>
In the context of the table it will look like this:
<table border= "0">
<tr align="left">
<td><a href="stranitsa.html"><img src="kartinka.png"></a></td>
<td> Content of the 2nd cell </td> </tr>
<tr align="right">
<td> the Contents of the 3rd cell </td>
<td> the Contents of the 4th cell </td> </tr>
</table>
4
Дополнительные возможности изображений.

1. Смена картинки на цвет при наведении на нее мышью и после смены местоположения курсора:
onMouseOver="this.style.background='#номер цвета'" onMouseOut="this.style.background='#номер цвета'"

2. Смена картинки на другое изображение при наведении мышью:
onmouseover="this.src='images/1.gif'" onmouseout="this.src='images/2.gif'"

3. Вставка вращающейся карусели из картинок в ячейку таблицы (значения можно менять):

<td align="left">
<BODY onload="Carousel()" background=>
<script type="text/javascript">
// 7 variables to control behavior
var Car_Image_Width=100;
var Car_Image_Height=100;
var Car_Border=true; // true or false
var Car_Border_Color="000000"; Border="0"
var Car_Speed=5;
var Car_Direction=true; // true or false
var Car_NoOfSides=6; // must be 4, 6, 8 or 12

/* array to specify images and optional links.
For 4 sided carousel specify at least 2 images
For 6 sided carousel specify at least 3
For 8 sided carousel specify at least 4
For 12 sided carousel specify at least 6
If Link is not needed keep it ""
*/
Car_Image_Sources=new Array(
"images/1.gif","",
"images/2.gif","",
"images/3.gif","",
"images/4.gif","",
"images/5.gif","",
"images/6.gif",""

// NOTE No comma after last line
);

/***************** DO NOT EDIT BELOW **********************************/
CW_I=new Array(Car_NoOfSides/2+1);C_ClcW=new Array(Car_NoOfSides/2);
C_Coef=new Array(
3*Math.PI/2,0,3*Math.PI/2,11*Math.PI/6,Math.PI/6,3*Math.PI/2,7*Math.PI/4, 0,
Math.PI/4,3*Math.PI/2,5*Math.PI/3,11*Math.PI/6,0,Math.PI/6,Math.PI/3);
var C_CoefOf=Car_NoOfSides==4?0:Car_NoOfSides==6?2:Car_NoOfSides==8?5:9;
C_Pre_Img=new Array(Car_Image_Sources.length);
var C_Angle=Car_Direction?Math.PI/(Car_NoOfSides/2):0,C_CrImg=Car_NoOfSides,C_MaxW,C_TotalW,
C_Stppd=false,i,C_LeftOffset,C_HalfNo=Car_NoOfSides/2;

function Carousel(){
if(document.getElementById){
for(i=0;i<Car_Image_Sources.length;i+=2){
C_Pre_Img[i]=new Image();C_Pre_Img[i].src=Car_Image_Sources[i]}
C_MaxW=Car_Image_Width/Math.sin(Math.PI/Car_NoOfSides)+C_HalfNo+1;
Car_Div=document.getElementById("Carousel");
for(i=0;i<C_HalfNo;i++){
CW_I[i]=document.createElement("img");Car_Div.appendChild(CW_I[i]);
CW_I[i].style.position="absolute";
CW_I[i].style.top=0+"px";
CW_I[i].style.height=Car_Image_Height+"px";
if(Car_Border){
CW_I[i].style.borderStyle="solid";
CW_I[i].style.borderWidth=1+"px";
CW_I[i].style.borderColor=Car_Border_Color}
CW_I[i].src=Car_Image_Sources[2*i];
CW_I[i].lnk=Car_Image_Sources[2*i+1];
CW_I[i].onclick=C_LdLnk;
CW_I[i].onmouseover=C_Stp;
CW_I[i].onmouseout=C_Rstrt}
CarImages()}}

function CarImages(){
if(!C_Stppd){
C_TotalW=0;
for(i=0;i<C_HalfNo;i++){
C_ClcW[i]=Math.round(Math.cos(Math.abs(C_Coef[C_CoefOf+i]+C_Angle))*Car_Image_Width);
C_TotalW+=C_ClcW[i]}
C_LeftOffset=(C_MaxW-C_TotalW)/2;
for(i=0;i<C_HalfNo;i++){
CW_I[i].style.left=C_LeftOffset+"px";
CW_I[i].style.width=C_ClcW[i]+"px";
C_LeftOffset+=C_ClcW[i]}
C_Angle+=Car_Speed/720*Math.PI*(Car_Direction?-1:1);
if((Car_Direction&&C_Angle<=0)||(!Car_Direction&&C_Angle>=Math.PI/C_HalfNo)){
if(C_CrImg==Car_Image_Sources.length)C_CrImg=0;
if(Car_Direction){
CW_I[C_HalfNo]=CW_I[0];
for(i=0;i<C_HalfNo;i++)CW_I[i]=CW_I[i+1];
CW_I[C_HalfNo-1].src=Car_Image_Sources[C_CrImg];
CW_I[C_HalfNo-1].lnk=Car_Image_Sources[C_CrImg+1]}
else{ for(i=C_HalfNo;i>0;i--)CW_I[i]=CW_I[i-1];
CW_I[0]=CW_I[C_HalfNo];
CW_I[0].src=Car_Image_Sources[C_CrImg];
CW_I[0].lnk=Car_Image_Sources[C_CrImg+1]}
C_Angle=Car_Direction?Math.PI/C_HalfNo:0;C_CrImg+=2}}
setTimeout("CarImages()",50)}

function C_LdLnk(){if(this.lnk)window.location.href=this.lnk}
function C_Stp(){this.style.cursor=this.lnk?"pointer":"default";C_Stppd=true;}
function C_Rstrt(){C_Stppd=false}
</script><div id="Carousel" style="position:relative; width:130; height:21">

</td>
Note
This is a lesson on how to insert a picture in HTML how to make how to make a flow of images with text, etc. it is known that images make the site more attractive and different from other resources, so the ability to use the tag "IMG" and its attributes are very useful in today's Internet. But, the main thing — sense of proportion! An overabundance of graphics will cause the weighting of the html page and hence increase the load time.
Useful advice
If the area is not match the actual size of the image you want to insert, then the picture will be stretched or narrowed to a specified in the html Img tag size. However, you should not use this method, for example, to reduce the size of inserted in the Html document pattern. It is better to resize the images in a graphic editor and then embed images in a Html document using a Html code editor.

Advice 3 : How to make database in access

The program MS Access is very easy to use because it has simple user interface. It is also possible not just important information, but also data processing, including creating forms, reports, various charts.
How to make database in access
You will need
  • computer;
  • program MS Access.
Instruction
1
Run the program and Access via the menu under "File" click on "Create". Then select "Database" and click OK. A window will appear in which you will need to specify the database name or accept the proposed db1, and you will also need to select the location of the base.
2
After the database is created, a window appears with the functions for further work. To the left is a column with a list of topics. The item "Table" must be selected by default. The right of the column is a list of options to create database tables: "Create table in design view, Creating table with wizard, Creating table by entering data".
3
Click on "Create table in design view" to create a new table in the database. On the screen a new window will appear with the mesh in its upper part for entering the parameters of the table: field, field type and description. In the bottom of the window appear the properties of each new field.
4
Create a table with four fields:
1. Code. The field type is numeric.
2. Name. The field type is text.
3. Name. Field type - text
4. Phone. The field type is text.
Highlight the first field and clicking the right mouse button, select "Key field". Close and save the table under convenient for you, e.g. "Agent". Open the table and enter the information of two agents.
5
Create another table with three fields:
1. Position. The field type is text.
2. Wages. The field type is money.
Close and save the table under a name such as "Employee". Open the table and enter the data for two employees.
6
Click on the tab "Queries" and then "Create query in design view". A window will open with the list created in the program tables. Select both the already created table. In the lower part of the query in the first column, select the field "Employee.Last name", and the second column "Organization.Position." Close and save the query to "Post". If you open this query, you will see only two columns "Name" and "Position". Here is displayed only the information of interest, what is the position held by a specific person.
7
For ease of populating the database click on the tab "Form" and then "Create form by using wizard". In the opened window select the table "Agent", and then from the "Available fields" using the button with the arrow, move to the "Selected field" fields "Surname", "Name", "Phone". Click "Next" and select a convenient format, such as "Ribbon". Click "Next" and select the desired style, for example, "Standard". Click Next and name the form "Agent". Click "Finish". A form will appear with two fields that already have information about the two agents. Below is a blank field into which you can enter information about the third agent, and so on.
8
In the database window, select "Reports" and click on the "Create report by using wizard". In the opened window select "employee". From the left window to the right move "last Name" and "Position", click "Next" and then click "Finish". The screen will display the form with information from the selected query. The report gives an opportunity to choose the necessary information from the database for better perception. Reports can be printed.
9
Macros allow you to automate actions on database objects. Click on the tab "Macros" and then click "Create". Open the designer window. From the drop-down list, select the macro "Otkrytiye", and then select the name of the request "employee". Close the window and save the macro. Click twice on the created macro, and open the query "Post".

Advice 4 : As in the image to insert the text box

To carry out various manipulations with images allow many office applications, even a word processor Microsoft Word. However, it is better to use a graphic editor - it does more the picture changes, and the interface is designed to work precisely with graphics and therefore is not overloaded with unnecessary features. In Windows operating system such program is MS Paint installed by default.
As in the image to insert the text box
You will need
  • Graphical editor MS Paint.
Instruction
1
Run the GUI editor. In Windows 7 or Vista for this you can press Win, type paint and press Enter. In Windows XP have to look for the link to run the application in the subsection "Standard" under "All programs" in the main menu system.
2
Download to photoshop the original picture. This is done in the dialog called by Ctrl+O or choosing in the application menu command "Open".
3
Turn on the Text tool - click on the icon with the image of the letter "A" in the section "Tools" on the Home tab. Click the place images where they should be the first letter of the generated labels, and on the image of the dotted frame will appear with a blinking cursor inside the input. Paint will add to the menu another tab of tools - Text.
4
Type the label text. If it is already created in any text editor or copied from another document, instead of manually dialing, you can use the "Insert" tab on the "Text" or Ctrl+V. When the input text will no longer fit in the width of the frame editor will take the word to the next line. You can change the width of the column with the text by dragging the node on the dashed frame.
5
If you want to change the color, size, lettering labels, highlight it or only the desired portion and use the controls in the sections "Font", "Background" and "Color" in the menu of the graphic editor. After these changes, adjust the final position of the text relative to the image with anchor points on the frame around the inscription.
6
Click image outside of the frame to turn off the text edit mode and save the picture with an inscription - the corresponding dialog is invoked by selecting "Save" or "Save as" menu in Paint.
Is the advice useful?
Search