Creating and editing tables
In his work with text editors You often have to deal with ordered information. The best way to store such information in documents is tables. In fig. 13.1 As an example of using the table, a phragment of a telephone-address book is shown. In addition, you can use tables for presenting a variety of lists, lists, financial information and solving a large number of other tasks. Tables may even contain illustrations to improve the perception of information contained in the table. For example, a list of products In addition to product names and prices may contain a graphic image of goods - very clearly (see Fig. 13.2).
MS Word provides at your disposal a wide range of tools to work with tables that simplify the implementation of most practical tasks. Commands designed to work with tables allow you to simplify the creation and editing of the table, as well as streamline and format the data contained in it.
In most cases, the tables give your solutions flexibility and elegance that you lacked so much when ordering information using one Tab key alone. In this chapter, you will get acquainted with the creation, editing and formatting table. In addition, you will learn to sort and calculate directly in the table.
If you have to work with spreadsheets (such as Quattro Pro or MS Excel), you will find a lot in common in working with tables in MS Word and spreadsheets. The table represents a grid formed by columns and rows. Crossing columns and rows form table cells. Each cell is independent of other table items, for it you can set the desired size and format.
Cells may contain text, numbers, graphic images or formulas. If you enter the text into the cell, when the right edge is reached, the text will be automatically transferred to the next line according to the cell width. When the column width change, the text will automatically be transferred to the next string (with a decrease in the width) or return to the previous line (with an increase in the width) so as to completely fill the cell of the new size.
Creating Tables
The table can be inserted into an arbitrary place of the document. The size of the table may exceed the page size, so it can be placed on one or more subsequent pages. In this case, you can define headers for the table in such a way that if the table is posted on several pages, the headers will be displayed automatically at the top of each page.
To create a table, you can use the Table Team | Insert a table or button insert a table on standard panel Tools. When using the menu command, you can determine the column width during the insertion of the table.
If you do not have enough skill in working with tables, the master will be an indispensable assistant for you when creating tables. To call the wizard, select Table | Insert a table. A wizard step by step will spend through all stages of creating a table. After creating a table, you can use the Table Team | AutoFormat tables to select the desired format from the proposed set standard formats. This approach can significantly simplify the process of formatting tables.
If the information you want to put in the table is already present in your document in the form of text, you can convert text to the table. About how to do it, you will learn in the "Text Convert Table" section.
Before proceeding directly to the creation of a table, you must have at least an approximate view of how many columns and rows should have a table. At this stage, you do not necessarily specify the table parameters. After creating, you can add and / or delete columns and lines at your discretion.
Creating a table using the Table Team | Insert table
Team Table | Insert the table allows you to determine the column width when creating a table.
Example 13.2. Inserting tables and setting the required column width
· Install the cursor to the point in which the left top of the table should be located.
· Select Table | Insert the table, with the result that the "Insert Table" dialog box appears on the screen.
· Specify the number of the required number of columns and rows. You can select a number or print it in the appropriate input row. At this stage, it is enough to specify approximate values. In the future, you can always change the number of rows and columns in the table.
· If you are a clear idea of \u200b\u200bthe width of the columns, specify the desired value in the "Column Width" input row. If you do not know which width should have columns, leave the default value. In accordance with this Word value, create a table to the entire width of the document and installs the same width for all columns. In the future, you can individually configure the width of each of the columns in the table.
· Select the AutoFormat button if you want to apply one of the standard formats to the table being created.
· Click OK. As a result, the table you defines will appear in your document. In this case, the cursor will be located in the first cell.
It may turn out that the table you created will be invisible. This situation is possible if the mesh option is turned off. About the action of this option you will learn in the section "Display and masking the lines of the grid and markers of the end of cells and lines."
Creating a table using the Insert Table button
The easiest way to create a table involves the use of a button to insert a table. In this case, the column width is installed automatically based on the width of the document and the number of columns. If necessary, in the future you can change the width of each of the columns.
Example 13.3. Creating a table using the Insert Table button
· Install the cursor to the point in which you want to place the table.
· Click the Insert table button, as a result of which a miniature table image appears on the screen (Fig. 13.9). Click any of the cells in the table image and do not release the mouse button. At the bottom of the image, the current number of rows and columns will be displayed (for example: 3x4 table). Move the mouse pointer to the cell that will match the desired table size. If you move the pointer for the right or lower boundaries, the grid size will be increased accordingly.
· In conclusion, let go of the mouse button. The specified place of the document will appear the table of the desired size.
If you pressed the insert table button and indicated the cell in the table image, and then changed your mind and decided not to create a table, move the mouse pointer outside the table so that the cancel message appears at the bottom of the image. Now you can release the button, the table creation operation will be canceled.
Similar to the text you can save the table using the Auto Text command. With repeated use of the table of this type, this approach will allow you to save considerable time. To save the table, select the table completely and execute the Edit command | Avtotext, as a result, the dialogue window will be opened "
Avtotext. " Next, enter the name in the element name line and select Add. To insert the saved table, you need to open the AUTOTExt dialog window, specify the name of the desired table and select Paste. More detailed information about using the Avtotext command is given in Chapter 5, "Editing Document".
Displaying and masking the lines of the mesh, markers of the cells and lines
Mesh lines are designed to identify cells and tables. The end of the cell is designed to indicate the end of the contents of the cell, and the end of the line marker is the end of the string. These tools simplify work with the table. However, in some cases, you may need to remove these elements from the screen, which are auxiliary.
Auxiliary characters present in Fig. 13.10 On print is not displayed.
Team Table | The grid allows you to display (hide) mesh lines. This command is a switch, that is, if as a result of the first command, the line has been deleted from the screen, then when you re-execute this command, the grid line will appear again on the screen. The end markers are displayed to the right of the line, and the position of the end markers of the cell is determined by the alignment method installed for each cell. Manage the display of these special characters is carried out using the button.
Unprintable characters located on the toolbar, orShift + Ctrl +8 - on the keyboard. Both of these means are also switches.
Similar to the Button Non-Shaped Symbols, you can add your own button to the toolbar, controlling the display of the mesh lines.
Data entry and movement on the table
If you have created a new table, the cursor will be located in the first cell located in the left upper corner Tables. To enter data into this cell, you must use the desired text or numbers using the keyboard.
Since the text entry (or numbers) is carried out in the table cell, you can enter more characters than it can fit in one line.Word. Automatically transfer characters that did not fit in the current line to the next line in the same cell. The number of rows in the table of the table will be increased so that all entered characters fit in it. The same wayWord. Reacts to pressingENTER . The cursor moves to the string below the same cell. As a result, the height of the string increases.
The easiest way to move the table cells is to use the mouse. In order to go to the desired cell, it is enough to install a mouse pointer on it and press the left button.
If you prefer to use the keyboard in your work, the key is used to move to the next cellTab. . To go to the previous cell, clickSHIFT + TAB. If TAB key will be pressed at the moment when the cursor is located in the last table of the table,Word. Insert a new string and move the cursor to its first cell.
In tab. 13.1 The keys are presented to move on the table. In order to leave the table, you must use the mouse or the arrows keys to move the cursor beyond the table.
Keys that allow you to move on the table
Key | Purpose |
Moves the cursor to the right to one cell. Inserts a new string if the cursor is located in the last cell |
|
Shif + Tab. | Moves the cursor to the left per cell |
Moves the cursor to the subsequent or previous line, respectively. Pressing when the cursor is located in the last line, or when the cursor is located in the first line, will lead to the output beyond the table |
|
Moves the cursor to one character within the cell. Press these keys, respectively, at the beginning and end of the cell will move to the previous or subsequent cell |
|
ALT + HOME and ALT + END | Moves the cursor in the first or last cell line, respectively |
Alt + PGUP and ALT + PGDN | Moves the cursor in the first or last string of the column, respectively |
Formatting the contents of the cell
The contents of the cell is similar to the usual paragraph. To format the contents of the cell, you can use the same tools that used to format a paragraph.
Setting tables
In practice, it is often necessary to change the parameters of the table in which the data contains.MS Word. Provides at your disposal the widest opportunities for editing tables, including inserting and removing cells, rows and columns, moving and copying cells, changing the height and width of cells and much more. In the following sections, you will get acquainted with the means designed to edit the tables.
Choosing cells
Before you execute the edit command, you need to select strings, columns or cells that will be performed in the future.MS Word. Allows you to select one or more lines and columns. To display the selected cells, an inverse image is used (see Fig. 13.14).
Using Menu
The menu commands allow you to select lines, columns, as well as entire table.
Example 13.6. Selection of cells, rows and columns
· Install the cursor in the cell belonging to the string or the column you want to choose. If you want to choose a whole table, the cursor can be installed in any of the cells.
· Select a table. Then, depending on whether you want to select a deadline, column or entire table, select one of the commands: Select the string, select the column or highlight the table.
Use of mouse
If you want to choose with a mouse one cell, set the mouse pointer between the left mesh line, which limits the cell, and the cell marker. The mouse pointer will take the shape of the arrow directed from left to right. In conclusion, click the mouse button. If you press the mouse button twice, the entire string will be highlighted.
When choosing a table fragment using a mouse mouse pointer can also be located outside the table. In this case, the selected fragment depends on the position of the mouse cursor. In tab. 13.2 Various options for selecting table fragments using a mouse.
Use the mouse to select table fragments
For selected table | Follow these steps |
Symbols | Install the mouse pointer before the first character, click the mouse button and, without releasing it, move the mouse pointer to the last symbol |
For selected table | Follow these steps |
Cell | Set the mouse pointer between the left line of the mesh, limiting the cell, and the marker of the cell end. After that click the mouse button |
Group of cells | Select the first cell or content of the cell. Next, not releasing the mouse button, move the pointer to the last cell |
Line | Perform the actions similar to the selection of one cell, but click the mouse button not one, but twice. Alternative way: click the mouse to the left of the selected line (outside the table); To highlight multiple lines, not releasing the mouse button, move the mouse pointer to the desired number of rows down or up |
Column | Press the mouse space from above from the selected column (outside the table); To highlight multiple columns, without releasing the mouse button, move the mouse pointer to the desired number of columns to the right or left |
Table | Highlight all rows or columns. Alternative way: Highlight the first line, then press the key.Shift. and highlight the last string |
Using the keyboard
Word. Provides at your disposal a few operational keys to highlight the fragments of the table, which are shown in Table. 13.3.
Keyboard to highlight table fragments
Key combination | Selection |
Shift + or | Symbol behind the symbol in the current cell, then the cell itself |
F 8, or | Current cell along with above or below. To complete the selection, clickESC |
F 8, or | Symbol behind the symbol in the current cell, then the cell itself. To complete the selection, clickESC |
Alt. +5 (on the digital part of the keyboard) | Table |
When you choose using the arrows keys, first you choose the characters in the cell. When you go beyond the borders of the cell, you start choosing the cells themselves.
If you are usingSHIFT + or F 8, + Select several adjacent cells in a row (for example, four cells), and then press several timesShift. +, then extend the choice of four cells in the following lines.
Moving and copying cells
After you have created a table and filled it with data you may need to change the location of the data in the table.Word. Provides you with the ability to move and copy the cells in the table together with the text contained in them.
Example 13.7. Use the mouse to move cells, rows and columns
In order to move or copy one or more cells along with their contents, follow these steps:
· Move the mouse pointer within the selected cells so that it takes the appearance of the arrow directed to the right left.
· Further your actions depend on whether you want to move or copy the selected items. In order to move the items of the table, press the left mouse button. If you need to copy items, press the key.Ctrl After that, press the left mouse button. Depending on the actions you produced, a corresponding message will appear in the status bar.
· Move the cursor to the cell located to the left and above the place in which displaced or copied cells should appear.
· Release the mouse button.
If the selection is included in the cell end label, the cell contents will be moved or copied together with the format.
Using the Edit Menu commands
When working with the table, the action commands cut, copy and paste from the Edit menu fully similar to working with the text. Using these commands, you can move or copy cells within the table or copy the table to another location. This means Allows you to move and copy one or more cells or entirely the entire table.
If you select the contents of the cell, copying is completely similar to copying text or graphic image in the document. However, when choosing one or more cells, along with their contents, lines that limit cells will be copied.
As a result of selection editing | Copy cell content is copied to the clipboard, and edit | Cut - Content moves to the clipboard. Lines restricting cells remain unchanged. When inserting a cell from the buffer to the current cell, the first cell of the buffer is placed. The source contents of the table cells is replaced by the contents of the cells from the clipboard. An example of copying a column illustrate Fig. 13.15 and 13.16.
The name of the insert option is determined by the content of the clipboard. If a cell is in the exchange buffer, the insert command is replaced with insert cells. As a result, you can insert the contents of the buffer as a table cell. When placing a string and column in the clipboard, the command will have the name insert lines and insert columns, respectively.
If you insert cells outside the table, they will still save the table structure. When inserting a group of cells to an existing table, its dimensions will increase so as to enable insert cells in the table.
In addition, you can insert the text located outside the table into the table cell. To do this, you need to select the desired text and move it to the cell as you did when working with the text in the document. You can also use the clipboard. In this case, place the text in the buffer, then move the cursor to the desired cell and execute the Edit command | Insert.
Example 13.8. Moving and copying cells
· Select cells, strings or columns that you intend to move or copy.
· To move cells, select Edit | Cut or clickSHIFT + DEL. As alternative way You can select the Delete button to the buffer on the standard toolbar. If you need to copy cells Select Edit | Copy or clickCtrl + Insert. . Alternatively, you can select the Copy button to the buffer on the standard toolbar.
· Select the area in the table, the size of which corresponds to the area selected in step 1. If the size of the copied cells do not correspond to the size of the cells in which copying is performed,Word. Warning you about the inconsistency.
· Choose Edit | Insert cells or clickSHIFT + INSERT. Alternatively, you can select the insert button from the buffer on the standard toolbar.
Changing column width
If you do not specify the exact values \u200b\u200bfor the column width, as a result, the columns will have the same width defined by the width of the document page and the number of columns. The borders of the table and the document pages coincide. In the process of working with the table you may need to change the column width or separate cell. To do this, you can move the right border of the cell or column in the table, move the column marker on the horizontal line or use the Table Team | Height and width of the cell.
Moving the boundaries of the cells and using the horizontal line
To change the column width using the mouse, install the mouse pointer to the right column border. As a result, the pointer will take the type of vertical dual line with arrows directed to the right and left. In this case, the view of the pointer does not depend on whether the grid lines are displayed or hidden. Click the mouse button and move this column marker before installing the required column width, and then release the mouse button.
If you select the entire column or not select any cell before moving, as a result, the column width is changed. However, if you first select one or more cells (but not the entire column), the width will be changed only for selected cells.
You can expand the action this method By using extra keys. This will allow you to change the width of other columns (different from the current), as well as the table as a whole. In tab. 13.4 Possible combinations are presented when the column width changes.
Tools for changing columns width
Act | Result |
Moving the border without pressing any additional keys | |
Shift. | The width of only two columns, located on the left and right of the moved border |
Moving the border when the key is pressedCtrl | The width of all columns to the right will be changed according to their initial width. |
Moving the border while pressedShift + Ctrl | The width of all columns remains unchanged. The width of the column located on the left of the moved boundary and, accordingly, the width of the table itself |
If you want to change the column width to see their exact value, simultaneously with the displacement of the boundary, press the key Alt.. As a result, their exact values \u200b\u200bwill be displayed on the horizontal line.
Similarly, you can use table markers located on the horizontal line. Your actions and the result in this case will fully coincide with the column width changed above.
If the rules are not displayed on the screen, select View | Line.
Using Team Table | Height and Width Cell
The height command and the cell width from the Table menu allows you within one command to change the width of several columns at once, as well as set the width of each column equal to a certain value. In addition, with this command you can change the distance between columns.
Example 13.9. Changes in column width using the command Ishigina Cell
· Choose columns or cells whose width you want to change.
· Select Table | Height and width of the cell, as a result of which the dialog window appears on the screen.
· Click the Column tab.
· Select or enter the width value in the column width field.
· If you want to install a new width for other columns, click the previous or next button, which will allow you to move to the desired column, without closing the "Height and Width of the Cell" dialog box. When you move around the columns in the field header, the column width displays the number of the current column, facilitating you to identify the item with which you are currently working.
· After completing the width setting for all columns, click OK.
Example 13.10. Changing the distance between columns
The "Height and Width of the Cell" dialog box allows you to set the distance between columns. By default, this distance is set to 0.25 cm. The day to change the interval between the columns, follow these steps:
· Select the columns between which you want to change distances. If you assume to make changes for all table columns, select the string.
· Select Table | The height and width of the cell, as a result of which the "Height and Width of the Cell" dialog box appears on the screen. Next Go to the Column tab. Suppose that your column width is 5 cm.
· Specify the interval between the columns the required value in the string. The value you specifies determines the width of the left and right indentation for the cell. As an example, set the interval equal to 1 cm.
· Click OK. As a result of your actions from 5 cm, which constitute the column width, only 4 cm will be available to you.
Automatic column width setting
MS Word. Provides at your disposal tool with which you can automatically change the width of the table column in accordance with the contents of columns. This tool may be very useful when working with large tables. After entering the data in such a table you do not need to view the contents of the entire table to determine the longest string of the text. Instead, you have enough to give a teamMS Word. , and the width of the table columns will be changed accordingly.
Example 13.11. Automatic table column width
· Select columns whose width you assume to change. If you select the columns not completely (for example, one or more lines)Word. Change columns widths only in the specified lines.
· Select Table | Height and width of the cell. In the dialog box "Height and Width of the Cells", go to the "Column" tab.
· Press the Auto Blood button. As a result, the dialog window will be closed, and the columns of the table will be aligned according to their contents.
Management of table rows
In the newly created table, all lines have the same height. When you enter the text, the line height varies in accordance with the number of entered lines. The "Height and Width of the Cell Width" window provides at your disposal to the means to set the height of the rows, left retreat and align the lines relative to the page fields. In addition, to change the height of the rows, you can use the vertical ruler.
Changing the height of string
To change the width of the strings, you can use the vertical line or the dialog box and the height and width of the cells. If you need to quickly configure only one line, in this case it is preferable to use a ruler. To simultaneously adjust multiple lines, it is advisable to resort to the means provided by the "Height and Width of the Cell" dialog box. This tool has another advantage - you can set precise values \u200b\u200bto the height of the rows, which cannot be made using the ruler.
Example 13.12. Changing the height of rows using
the windows of the dialogue "Height and the Width of the Cells"
To simultaneously change the height of several strings, follow these steps:
· Select the lines whose height you want to change.
· Select Table | Height and width of the cell. In the "Height and Width" dialog box, go to the "Row" tab.
The "Line Height" option allows you to set the following values:
Value | Result |
Auto | Sets the height of strings by the highest cell |
Minimum | Specifies the minimum row height. If the contents of the cell exceeds the minimum height, the height is set to accommodate all the information |
For sure | Specifies a fixed height of the cell. If the contents of the cell exceeds a fixed height, only the text or part of the graphical object is displayed, which is placed in the specified amount |
At this stage, you must choose one of the specified options.
· If at the previous step you chose a value at least or accurately, enter the desired value in the value row. You can set a value in points or centimeters, indicating the corresponding units (PT or CM) after the numerical value.
· If you need to format other lines, go using the Next or previous buttons to the desired string. At the same time, the current line number will be displayed in the field header. Follow steps 2 - 3.
Changing the height of the strings is completed, but before proceeding to the next example, let's stop at one very useful tool provided by the "String" tab - Allow the transferring line to the next page. If with the checkbox (default) the contents of the cell is not placed on one page,MS Word. Slides the string and transfers unnecessary data to the next page.
· Click OK.
Example 13.13. Changing the height of rows with a vertical line
- In order to configure the height of individual rows of the table using a vertical line, you must be in the page markup viewing mode. If you are in different mode, select View | Page Marking Or use the Markup mode button located on the left of the horizontal scroll bar.
- Each row of the table on the vertical line corresponds to the horizontal marker. To set the required height, move the marker of the corresponding string.
MS Word Reaction On the movement of the marker depends on how and in which direction you are moving. If you have not been pressed when movingCtrl For string, the minimum height value is set. In this caseMS Word. It will automatically increase the row height so that its contents will be completely displayed. If after changing the height you add text or graphic image to the string or graphic image, if necessary, the row height will be increased automatically.
In order to set a fixed row height value, when moving the marker, press the keyCtrl . In this case, part of the text or graphic image that will not fit in the height allotted, will be trimmed. To view the full contents of the table on the screen or output to the printer, you will have to increase the row height.
Change distance between rows
The presence of an additional interval between the rows improves the readability of your tables. Team format can be used to configure the inter-interval | Paragraph or option of the paragraph of the context menu that appears on the screen as a result of pressing the right mouse button.
Example 13.14. Increase interval between rows
· Select the lines, the distance between which you want to enlarge.
· Select Format | Paragraph, as a result of which the "Paragraph" dialog box appears on the screen. Click the "Indents and Intervals" tab.
· Fill in the input fields before and after, you can enter the desired value in the string or select it using the buttons located on the right side of the rows. The values \u200b\u200bare specified in paragraphs (PT) or lines (ST).
· Click OK.
Setting the position of the string
The position of the string is determined by the alignment of the rows and the indentation of the line from the left field of the page. Changing the level of alignment and installing the left retirement does not affect the location of the text relative to the string. When setting the left retirement, the selected lines are shifted by the right as happens when the paragraph is shifted.
Example 13.15. Alignment of rows and set of left retirement
To align lines relative to the left and right page fields, follow these steps:
· Select the lines for which you want to change alignment.
· Select Table | Height and width of the cell. In the "Height and Width of the Cell" dialog box, go to the "Row" tab (see Fig. 13.19).
· Select the desired level of alignment using options: on the left edge, in the center or by right edge.
· Fill in the input field of the retreat on the left by entering the desired value or selecting it using the buttons located on the right side of the row.
· Click OK.
Insert and remove cells, rows and columns
After creating a table, you can change its structure by adding and removing cells, rows and columns. If you need to make a few changes to the table structure, you can do it within the same command. The specific type of options insert and delete from the Table menu is determined by which the elements of the table (cells, rows or columns) were selected before calling the command.
Example 13.16. Insert rows and columns
· Select a string or column depending on whether you want to add rows or columns.
· Select the insert line or insert columns from the Table menu.
When choosing a table | Insert strings new line It will be inserted above the current line, and all the lines below it will move down (Fig. 13.21). When inserting a column, the new column will be added to the left of the current column, and all columns located to the right will move to the right. After inserting a new line or column becomes current.
Instead of the menu commands, you can use the Insert button on the standard toolbar toolbox to insert the rows and columns.
If you need to add a string to the end of the table, go to the last table of the table and press the keyTab.
Inserting a column at the end of the table has features and implies a different sequence of actions:
· Install the cursor in the last row of the table, outside the table.
The cursor should be located in front of the end marker. In the positioning of the cursor you will be helped by markers and lines of the grid. If these items are not displayed on the screen, display them as they did in the "Display and masking of the mesh lines, the markers of the cells and rows."
· Select Table | Select column.
· Select Table | Insert columns or click the Insert columns button on the standard toolbar.
If you need to insert a few more columns at the end of the table, select Edit | Repeat the insertion of columns or click F.4 So many times as columns you need to insert.
It is possible that when performing inserts and deletion operations in the Table menu, the required commands will be missing. This may be due to the fact that you have chosen not a string or column, but only a few separate cells. In this caseMS Word. Just can not determine what you intend to perform actions on rows or columns.
Example 13.17. Deleting rows and columns
· Select one or more lines (or columns) that you intend to delete.
· Select the Delete Rows or Delete Columns from the Table menu.
As a result of the choice of table | Delete Rows The selected lines will be deleted, and all the lines below will move upwards. When the columns are removed, all columns located to the right of remote columns will be moved left (Fig. 13.23).
Example 13.18. Insert and remove cells
You do not need to insert or delete lines or columns entirely. In some cases, you may need to perform operations on specific cells. In this case, your actions will be similar to those discussed earlier when inserting and removing rows and columns.
· Select the cells that you want to delete or next to which you want to insert new cells.
· Run the Table command, from the menu of which click Paste Cells or Delete Cells. Depending on the selected command, the "Insert cell" dialog box appears on the screen (Fig. 13.24) or "Deleting cells".
· When inserting new cells and remove existing cells,MS Word. Shifts the rest of the cells. Using the dialog window, specify how the position of the remaining tables of the table should change. Note that using the data of the dialogue window, you can insert or remove the entire string and column.
Table selection | Insert cells inserts new cells in the current position, shifting the selected cells down or right. Similar to Table Selection | Delete cells removes selected cells, shifting the remaining cells up or left to fill the resulting empty space.
· Click OK.
If you need to clear the cells (that is, delete the contents of the cells, without deleting the cells themselves, select the cells whose contents you want to delete, and click Del. orBackspace..
Creating table titles. Association and splitting cells
If you prefer to place a title directly in the table, you may need to combine several cells of one line in one cell. A similar task you have to be solved when placed in a table enough long text, which should be displayed in one line or graphic image.Word for Windows. Allows you to merge a few horizontal cells located in one. In this case, the contents of the cells are also combined into one cell.
Example 13.19. Combining cells
To combine several cells located nearby in one line, follow these steps:
· Select the cells you want to combine.
· Select Table | Combine cells. As a result, the cells you choose merge into one cell (see Fig. 13.27). If necessary, format the cell and its contents.
If you now need to create a table title, select the first string and an arbitrary number of the following lines that you want to use as a table header. Next, select Table | Headers. If the table does not fit on one page,MS Word. It will automatically repeat the table title on each page.
If after setting the table header you change the header text, the headers on subsequent pages will be changed automatically. However, if there is a mandatory end of the page in the table, the title will not be repeated or updated.
In order to check whether the header is set to the current table, open the Table menu. If the titles are defined for the table, a marker will be displayed opposite the header command.
Split cells
The splitting of the cells is a reverse operation in relation to unification. With it, you can restore the initial state combined cells. In this case, the distribution of text between the cells will be determined by the presence of paragraph characters. The first paragraph will be placed in the first cell, the second paragraph is to the second cell, etc.
In addition, you can smash a cell that is not the result of combining cells. In this caseMS Word. Spears the cell on the number of cells of equal size specified by you so that their total size is equal to the size of the original cell.
Example 13.20. Split cells
· Choose one or more cells that you intend to break.
· Select Table | Smash the cells, as a result of which the "Split cells" dialog box appears on the screen.
· In the input field, the number of columns displays the number of columns to whichMS Word. It offers to smash each of the cells. If necessary, change the specified value and click OK.
Formatting tables
You can format cells in the table and their contents in order to give the table more readable view.
To format the contents of cells, you can use the receptions of formatting of ordinary text. For example, you can change the type, size and font inscription. You still have access to all the tools provided by the format command, with which you can set the desired line interval and align the contents of the cell. To format the contents of the cells, the contextual-dependent menu, called when you press the right mouse button can be used.
In addition to the contents of the cells, you can, at your discretion, add the design elements directly to the table (lines of the grid of the entire table or its individual cells, framing, etc.).MS Word. Provides at your disposal a set of predefined style design styles from which we will start learning the table formatting tools.
Using Team Table | AutoFormat
Team Table | AutoFormat allows to significantly reduce the time required to give your table of professional species, by using predefined table design styles. With their help, you can quickly install the framing and fill of the cells, the font parameters and color design, as well as the automatic change in cell size in accordance with their contents.
Example 13.21. Formatting a table using the AutoFormat command
· Install the cursor within the table.
· Select Table | AutoFormat, with the result that the "Auto-Table" dialog box appears on the screen.
· From the list of predefined formats, select the format in the greatest degree Meeting your requirements. The appearance of the selected format is displayed in the "Sample" section, facilitating your choice.
· If you want to change only one or more design items, while saving a part of the design elements of an existing format, remove the corresponding checkboxes in the "Use" section (frame, font, auto-section, fill, color). At the same time, the "Sample" section will display the changes you entered into the table format.
· To apply autoformat only part of the table, specify in the "Change" section of the table, the format that you intend to change (header lines, first column, last row, last column).
· Click OK.
Selection of frame formats
MS Word. Allows you to add a frame to separate cells, rows, columns and entirely to the table. As an example in Fig. 13.30 shows one of the variants of change external view Tables using frames.
Example 13.22. Adding a frame to the entire table or its individual cells
· Select the cells that you want to enter into a frame (or entirely entire table).
· Select Format | Framing and fill. Go to the "Framing and Filling Table" dialog box to the Frame tab.
· Select the style and thickness of the line in the list.
· Select the color line in the list.
· Select the frame type in the "Frame" section (no, frame, mesh).
· Click OK.
You can at your discretion to install the type of frame, color and thickness of the lines, using the partition options and the Frame tab color options. To do this, you need to perform the following actions:
· Select the type and thickness of the line from the "Line" section.
· Select the color line from the color list.
· Select a line or border of the table to which your selected style and color of the line will be applied using the capabilities provided by the "Frame" section.
The "Frame" section shows a sample table. Its specific view depends on the number of stock and columns of the current table. If the table contains several rows and columns, the sample will contain angular markers designed to install the style for the borders of the table, and the central markers - to set the style of the table mesh lines. If the table contains one column or one string, the corresponding central markers will be absent.
If you prefer to use the mouse in your work, click the desired line or border on the sample. You can also press the corresponding marker. As a result, the line you chose will be marked with triangles from two sides. If you want to set the style immediately for multiple lines and / or borders, press the key.Shift. And holding it down, click the required lines. After selecting lines and borders, set the desired style and color for them.
· Sample "Frame" allows you to get an idea of \u200b\u200bthe appearance of the table after its change. If you decide to delete the selected line, select No in the "Line" section. If you are not at all satisfied with the results of the work done, select No in the "Type" section and start all over again.
· Press the buttonOK.
We discussed how to conclude the entire table into the frame or add a frame to the selected table cells. In addition, you can add a frame to paragraph contained in the table cell.
Example 13.23. Adding a frame to paragraph contained in a table cell
· Click the Unproducable Symbols button on the standard toolbar, as a result of which the paragraph characters appear on the screen.
· Select the paragraph character for which you want to add a frame.
· Select Format | Framing and fill and set the required parameters for paragraph.
Installation of filling
You can give your table a more readable type of filling and attract attention to the cells containing key information.
When filling out the settings you selected are applied to the selected cells. If the pointer is located within the table in which there are no dedicated cells, the installed filling will be applied to the entire table.
Example 13.24. Adding fill to the table
· Select Format | Framing and fill. The "Framing and Filling Table" window will appear on the screen.
· Click the "Fill" tab.
· To add a fill, set the configure switch (or not - to delete fill).
· If you select the configure switch, specify the sample to fill from the "Pattern" section.MS Word. Allows you to set as a pattern (these options are located at the bottom of the list) and the density of filling (in the absence of a pattern). If you only want to slightly sharpened the cells of the table, use small percentage ratios, for more dense filling - large values.
· Select the color of the pattern from the corresponding list. If you intend to print your document on a black and white printer, select Auto or Black.
· Select the background color from the corresponding list. If you intend to print your document on a black and white printer, select Auto or White.
· In the section "Sample", look at how the filling you created will look. If the results are satisfied, clickOK. Otherwise, continue to work on filling.
If you assume to bring the document to print and you have no ready-made solutionsWe recommend experimenting with the options of lists pattern, pattern color and background color for giving your document the most attractive look. Finding an acceptable combination, use it when developing other documents.
The appearance of filling when printing is fully determined by the resolution of your printer. The higher the resolution of the ability, the more readable will look at the filling and the table as a whole. The resolution with which the printer displays the graph is set in the "Properties" dialog box. To open this window, select File | Print, after which click Properties and go to the "Graphics" tab.
Split tables
When working with the tables, you may need to break the table into two parts in order to, for example, insert text or drawing between them.
To split the table, set the pointer to the string in front of which you want to break the table. Then select Table | Split table or clickCtrl + Shift + Enter . The table will be broken into two parts, between which the paragraph marker will be inserted (¶), formatted by a normal style. If you need to cancel the partition, remove the paragraph marker.
If the table begins with the beginning of the document,MS Word. Inserts a paragraph marker in front of the table. As an alternative way to insert a paragraph marker over such table, you can set a pointer to the first cell and clickENTER.
Sort Tables
Typically, the tables are created in order to in a certain way to streamline data on columns and strings. You can change the order of the rows in the completed table. The elements of the table can be arranged in an alphabetical or digital order, as well as sort them by date. For example, you can arrange recording in the table, which is your telephone-address book. At the same time, at the beginning of the records are ordered by last name, then - by date of birth, and in conclusion - at the place of residence (city or street). In total, three columns values \u200b\u200bcan be used to sort records, each of which you can specify the sort direction - ascending or descending.
Example 13.27. Sorting information in the table
· Highlight the lines that you want to sort, or the entire table.
· Select Table | Sorting. The "Sort" dialog box appears on the screen.
· Default MS Word It offers you to streamline the strings on the elements of the first column. If you have your own opinion about this, specify the first column, the rows will be sorted by the values.
· From the Type drop-down list, select Text, Number or Date.
· Set the switch ascending or descending.
· If you want to use to sort the value of additional columns, repeat PP. 3 - 4 using the "then" section.
· If the table has a header that should not be included in the sorting, set the switch without the header string.
· To make a sorting of a delicate register, click the Settings button, select the check box with the register and clickOK.
· Click OK.
Similarly, you can streamline the lines of text or lists that are not included in any table. Mandatory condition is the separation of text with tabs, commas or similar signs. You can even sort the text paragraphs.
The structure of the table created by the wizard or constructor of the table can be modified, i.e. change the name of any field and its type, insert a new field or delete the existing, change the order of fields in the table.
To modify the table, open it in the table constructor. To do this, do one of the following.
- In the Project window, set the cursor to the modifiable table and press the MODIFY button.
- In the Project window, set the cursor to the modifiable table, press the right mouse button and in the screen appeared on the screen. context menu Select Modify command.
- When you open the table designer from the database constructor window, select the modifiable table and press the Modify Table button on the Database Designer toolbar (Database Designer) or select the Modify command in the Database menu.
As a result, the Table Designer dialog box opens on the screen (table constructor), containing the structure of the modifiable table.
Change the names of fields and their types
Errors allowed when specifying a field name or its type, easily eliminate. Set the cursor to the name of the field you want to change, and, using the key Remove erroneous characters. After that enter the correct name of the field.
To change the field type, set the cursor to the Tour Column (Type) and select the desired value from the list.
A warning
Changing the type of table fields containing data can lead to loss of information.
Adding and removing fields
To add a new field to the table, follow these steps:
- Use the arrow keys or mouse to set the cursor to the string in front of which you want to insert the missed field. In this case, the cursor can be in any Name column (name), tour (type) or width (size).
- Press the INSERT button.
- Visual Foxpro. Inserts an empty string named NEWF L D. Enter the desired field name.
- Using the Turing List Values \u200b\u200b(Type), set the field type.
- In the width column, enter the size of the new field.
To remove a field from the table structure, set the cursor on the field you want to delete, and click the Delete button.
Changing the order of field location
The order of the fields specified when creating a table structure can be changed. To do this, follow these steps:
- Install the cursor on the field whose location you want to change. The button moves the field movement in the form of a bidirectional arrow appears on the button.
- Set the cursor to the move icon.
- Click the mouse button and holding it down, move the up or down icon to the desired location in the structure.
- Release the mouse button. The field has changed its location.
Under the modification of the table, we will understand the removal of existing fields from the table, adding new fields, changing the name, type, size, field data format.
In Access, the modification of the structure of the table is carried out in mode Constructor.To modify the structure of the table, it is necessary:
1. Open the database containing a table whose structure must be changed.
2. Click on the desired table in the window Database.
3. Click the button on the button ConstructorTo open the description of the table structure in the constructor mode.
To remove the field in the designer mode, follows:
1. Set the text cursor to the removed string
2. Click the button on the button Delete strings On the Standard panel or execute the menu chain: Edit® Delete lines.
3. Click the button on the button Yesin the window that opens.
It must be remembered that when the field is deleted, all the data contained in it is deleted.
To insert the field in the designer mode, it is required:
1. Set the text cursor in the line field on which the new field will be located. For our example it will be a field Language.
2. Click the button on the button Add strings On the Standard panel or execute the menu chain: Insert® Lines.
3. After inserting an empty string, it is filled in analogously to how it was done earlier when describing the table structure.
Changing the field name is carried out when editing columns Field nameChanging the data type in the constructor mode is performed using the column drop-down menu. Data typeand changing subtypes, format and data size is made in the window Properties of the field.
The process of installing links between tables is called the construction of the database schema.
To establish links between the two tables, it is necessary to determine in each of them fields for this binding. These fields may not necessarily have the same names, but should contain the same type.
8. Working with data using DBMS request MS Access
Previously, it was noted that for working with data selected in accordance with any condition, it can be used the ability to install a filter for a database table or form (in the menu item Entries). In the same menu item there is a section Advanced filterthat opens the window Designer requests. Moreover, Designer of requestsin fact, it was already used when describing the source of records for the report. To work with requests and to save them in the database in the system Access.there is a special partition that allows you to create new requests in the constructor mode or using Masters.
The principle of query formation is most easily led by using Masters of requests. Suppose we need to select those students who are on the subject Mathematicsthere are only excellent marks on the results of the first semester. To create a query, choose in the section Inquiriesbase mode Creating a query using a wizard.
In the first step You should select tables and fields to be included in the query. The selection of fields can be performed from several base tables.
In step 2.("Detailed or Final Report") Choose a detailed report. In the last step 3we specify the name of the query Mathematicsand choose the option Change query layout, then press the button Ready. The request opens in designer requestsHis species is shown on. At the top Designerrequests are shown in the tables used to select data and the connection between them, at the bottom - the table to select fields, grouping data (if the "group operations" lines are not, you need to select this command in the Main Menu of Microsoft Access in the "View"), tasks Sorting and selection conditions. You can also remove checkboxes from those fields that you do not want to show on the screen.
Save the request and see his text in SQL mode (Structured Query Language). The query text will look like this:
Close the designer window and execute the command request Openor double-clicking mouse. The data selection result will be shown on the screen as a table. It should be remembered that the editing of these table data will change the information in the database tables! The results of the execution of the query or data of the tables can be represented as charts and graphs. Create a request in which we will show in graphical form a middle score on student groups on the subject of "mathematics" (№ № \u003d 1). To group the data, as noted above, in the "View" section of the system menu, we put a tick at the group operations string. We get the following query text:
To view data in the form of a graph in the menu Viewselect item Summary chart, after which the window opens Builderdiagrams. Diagram design methods are similar to the use of the object. Chart Microsoft Graphin Microsoft Word or Excel programs.
Practical work 2.Subject: Editing and modifying MS Access database tables.
Purpose: Mastering MS Access Database Tables Editing and Modify Technology
Operating procedure. Run MS Access and open the Firm staff table
Task 1.1. Modify the table "Firm staff".
1. Enter data:
1.1. Delete the 8th record. To do this, highlight the recording by pressing the button to the left of the recording and use the command Edit / Delete or team Delete the context menu caused by the right mouse button. When deleting the program will ask for confirmation of deletion. Give confirmation of the removal button OK . If done correctly, then the 8th record after this operation will not be.
1.2. In the third post, change the surname to Orlov .
1.3. Enter a new entry in Table modewith the last name Rockies;
1.4. Enter a new recording mode Data input(team Entries / data entry)with the last name Grigoriev;(Please note how the view of the screen using filtering in mode has changed. Data input) After entering the recording, perform
1.5. Display all records with the team Recording / Remove Filter.
1.6. Move the first entry to the end of the table (highlight the first record and use the command Edit / Cut , (In the window that appears, answer "yes")next, select a free recording string and execute: command Edit / Paste ( in the appeared window to answer "Yes")
1.7. Copy the name with the surname Rokotovon the second and change the name in it;
1.8. Check that the database changes are correct: there must be a record from 2 to 7 and from 9 to 13
2. Spend data on the field Surname in descending order (highlight the appropriate field Surname clicking on its name and select the command Record / Sort ). Table 2.2.
3
. Summarify all entries with the surname Rokotov
To do this, highlight the required surname field and select the command. Edit / Find.
In the window that appears in the field Sample
Enter the last name Rockots.
Fig.2.1.
4. Change the name of the field " Passport ID " on the " Passport details "In" Tables "To do this, set the pointer to the field name and double-click.
5. Add to the "FIRST employees" in front of the field P pu tag new fields: Bet, Prem u. i, salary . Fordo this field highlight Etc u. tag and select Team Box / column . Assign the appropriate names created by the fields.
6. Go to mode K. onstructure o. p (view / designer ). Created fields should have monetary data type. Return to B. Table Mode (Table View / Mode ).
7. Fill in the field Rate numeric data, for correct future work, dial
several rates with values \u200b\u200bin the range of 5000 ... 7000 p.
Note. For convenience, some fields can be hidden by the team. Format / Hide columns , to call hidden columns, use Display columns .
8. Save the changes in the table.Fig. 2.2.
Task 2.. Calculate the values \u200b\u200bof the premium and salary in the "Firm staff" table. The premium is 27% of the bet, and the salary is calculated as the sum of fields Etceatu.iandRate.
1. Open the "Firm Employees" table.
2. To fill the fields Prize and The salary select Object Inquiries , call the request form
team FROM text / designer .
TO 
ratpnaya certificate. A request form is a form designed to define a query or filter mode. Request Designer.
In the opened dialog box Adding a table Select the table "Firm staff » Click the button Add And close the window, while the query form will add a list of the fields of the company "Firm staff".
Brief certificate. List of fields - a small window containing a list of all fields in the basic source of records. MS Access is the ability to display list of fields in mode. Designer forms , reports and requests, as well as in the window Data schema.
4. In Menia Z. anros select Team ONN hEALTH . Pay attention to changes in the form
request Sorting
changed by Update
.
5
. From the list of fields in the request form, drag the fields you want to update - Etc
emiah I.
The salary
:
in line Update
Enter the calculated formulas first for
field filling Etc
emya
and then - fields The salary
(Prize
is 27% of Betting
, but The salary
calculated as the sum of fields Prize
and
Rate
).
6. To calculate the premium in the "Update" line, type: [Rate] * 0.27
To calculate 3Arts, type: [Prize] +
7. Save the request under the name " Prize and salary "(Fig. 2.3.);
8. Spend the update on the venture: Request / Ran. sC. for what do you double on the execution of the update request "Prizeand salary. " At the same time confirm the execution of the request to the button Yesin the opening dialog box.
9. Open the company "Firm staff" and check the correctness of the calculations (Fig. 5.). If everything is done correctly, then fields P remuya and The salary will be filled with calculated results.
10. Change the sequence of fields: field Note place the field Rate.
The rules of movement are the same as in all WMDOW applications (highlight the field
Note, mouse drag to a new place).
9. Save the changes in the table.
Task 3. Create a copy of the table "Firm staff." New table Submit the name "branch of the company". Changes in the fields of tables.
1
. Run the Access program and open your created database. Select Object Base
Ta6litsa.
2. To copy in the window Database install the cursor to the "Firm Employees" table and select the command Edit / Copy Further Edit / Paste .
In the window that appears Insert table enter the new name of the Firm branch table and select
Switch Structure and data (Fig. 2.6.).
3. Remove part of the fields in the "Firm staff" and "branch of the company" tables.
The "Firm staff" table should remain fields:The code. Surname. Name. Middle name.
Position, Home Phone, Tabel Number, Date of Birth, Hire Date.
The "branch of the company" should remain the fields: The code. Surname. Name. Note. Bet Prize. The salary.
Lab. Slave №1
Creating a database structure in MS Access environment, entering and editing data in table mode
1 goal and content:learn to form a database structure in the Access environment. Explore access features When entering and changing data in the database. Learn how to format the database tables.
Theoretical Justification
Formation of the structure of the table
The Access database is a unified object that combines such components as tables, reports, requests, forms, etc., and allows you to store them in a single disk file. The main structural component of the database is table. Each table contains records of a certain type, for example, about suppliers of goods to customers (customers). Each table entry contains all necessary information About a separate database element. For example, a write record may contain its code, name, address, etc. Such separate structural elements Table entries are called fields. Each field of the table is assigned a unique name that cannot contain more than 64 characters.
The data type indicates the Access system how to process this data. You can use the following types: text - for text information and numbers at non-compliance with mathematical calculations (up to 255 characters); field Memo. - for storing arbitrary text, comments (up to 64,000 characters); numerical - when performing on the data of mathematical operations; monetary - A special numeric field is used for money operations; date Time - Designed to store information about the date and time; counter - a special numeric field in which Access automatically assigns the unique sequence number of each record; logical -can have only one of the two possible values \u200b\u200bof "yes" or "no"; oLE object field -object (for example, Microsoft Draw spreadsheet) created by another application. Maximum size - approximately 1 gigabyte is used to enter in the field of drawings, graphs, tables, etc.
Creating table structure
Create a table for subsequent input to her own data can different ways: in designer mode; via masters Tables; way data entry in an empty table.
Creating a table in Constructor mode.To create the table that the table "from scratch", fully controlling all the stages of the development structure of the table, is provided in Access Designer mode. IN Designer mode You can create a structure of the future table in full compliance with its previously developed project. In this mode, it is possible to determine the list of table fields, select the data type, configure properties for each field, as well as enter the description of the fields.
Entering and editing data in table mode.In the created table, the data can be entered both directly in tabular form by default and using a specially designed custom screen form. Editing records and correcting errors in the table data is also possible in each of the two modes. With any of the specified methods of entering and adjusting the data of the table, Access saves the entered or fixed record on the disk.
Data input . IN Table mode The display of records in the string and column format provides the ability to simultaneously view multiple records, add and change data.
Along the top edge of the window are located table fields. Each field corresponds to a specific column in the table. Each entry takes one line in the table. Input to a specific table (highlighted cursor) is carried out by dialing information on the keyboard and then pressing the key ENTER or Tab.. When entering data entering the last Access recording field itself goes to the first recording field and expects data entry.
Move in the table . To quickly browse the data entered in the table, as well as the required positioning in the table, you need to pay attention to the possibilities of quick movement in the table (see Table 1.).
Table 1 - Move in Table
Key. Since each field in the table is unique, it is necessary to distinguish the records to provide quick search In a specific record table. In relational databases, a unique identifier is introduced to solve these problems - the primary key. As such a key, one or more recording fields are selected. In addition to unambiguous recording identification, the primary key allows you to implement links between tables.
There are two types of primary keys: simple key and composite key. In the role simple key can perform one of the existing table fields if it contains unique meanings (for example, machine number, inventory number, identification codes). Composite key It is built as a combination of two or more data elements. In practice, the composite key is determined, as a rule, only for a table that is used to bind two tables against "many to many".
Error correction
Table cell data can be edited both with full and partial replace them. To fully replace the data, you must bring the cursor to the editable cell so that all its contents are laid out in a reversing form, and then dial (enter) replaced information.
Particular data replacement can be carried out in two ways: click in the desired cell, and it will automatically open for editing; Using the control keys, move to the desired cell, and then press the function key F2..
Removing recordingTo remove the record, it is necessary to highlight it (click on the recording marking area) and press the key Del. (or execute the Edit\u003e Delete command, or use the Delete command from the context menu). In the query displayed, confirm deletion.
Formatting table
Selection of used fonts . All ACCESS tables are created and displayed in a single, standard style, but if necessary, this style can be changed. Unlike modes of forms and reports, where you can specify your values \u200b\u200bfor individual screen elements, all parameters that are installed for the font are valid for the entire table entirely, including for column headers.
To change the appearance of the table font need: Select the command format \u003e Fontto open the dialog box Font, Showed in Figure 1.1. Change the required font parameters: font type, drawing, size, color, emphasis. The result can be viewed in the window Sample. If the result suits you, click OK , if not, then Cancel.
Changing the column width and row height . The width of the column can be changed using the mouse: to bring the cursor to the border of the columns until the image of the bidirectional arrow appears while holding the left mouse button,
Figure 1 - dialog box Font Allows you to set new attributes for a specific table font.
change column size. When the column is the desired width, the mouse button must be released.
To set the column width along the longest data item, already entered in the field, place the pointer to the right limit of the field header until the bidirectional arrows appears and double-click on the vertical border of the column.
You can specify the width of the column more accurately using a special window. Column width. To do this, you must execute the format\u003e command Column width Or use the context menu. A window depicted in Figure 2. The dialog box offers three options:
1. To set a column width equal to the exact number of characters that can be configured in the field, enter the desired numeric value in the field Column width.
2. To specify the default column width, check the option for the option. Standard.
3. To set the column width to the highest number of data entered, click on the button By the width of the data.
Figure 2 - accurately set the width of the selected column using the window Column width
You can change the height of the string using all of the above Takes: Format\u003e String height(Fig. 3) or using the context menu, as well as using the mouse for the physical movement of the recording boundaries.
Figure 3 - To specify the row height in the table, you can use the window String height
Table format dialog box. Many appearance settings of the table are installed in the dialog box. Format of table. You can call this window using the context-sensitive menu or by following the sequence of actions: Format \u003e Table mode . Window opens Table format,showed in Figure 4.
In a group Registration You can select the switch is raised or recessed so that the table becomes "volumetric". In this case, the background color will be silver. The new look of the table after applying the selected settings is shown in the area. Sample.
Figure 4 - Format of table Allows you to choose design
tables, color and view of mesh and background lines, as well as manage
displays the grid of the table
The default is the usual design with a white background and silver grid lines. Drop-down lists Background color and Color lines mesh allow you to install your own color solution for designing table cells.
You can refuse the grid - vertical and / or horizontal lines by selecting the switch normal and, removing the checkboxes from the corresponding options in the group Mesh lines. If the output of the mesh lines on the screen is disabled, when printing, they will not be visible.
In the dialog box Format of table You can change the color of the background and lines of the mesh, the view of the border and lines, the direction of the text. In order for the changes to be applied, you need to click OK .
Using the format panel . Many commands when setting up a way to display a table, using the toolbar Format (table mode ) (Fig. 5). To display it on the screen, you need to select the team View \u003e Toolbar > Format (table mode) Or right-click on the background surface of the Access window toolbar and in the context menu that opens, select the command Format (table mode).
Figure 5 - Toolbar Format
If necessary, you can add missing buttons if necessary. To do this, click on the small arrow to the right of the panel Toolbar Parameters\u003e Add to Delete Buttons > Setting. In the window that appears Setting Select from the relevant sections the right buttons (Fig. 6).
Figure 6 - Adding and removing buttons
