Filling the spreadsheet MS Excel

The Number and text are brought in table by usual image. If text begins with numbers then before him it is necessary to open the quote. Under formula is understood set numbers and references to numeric cells, united sign arithmetical operation.

The Formula begins with sign =. To assign the reference to cell, it is necessary to reference in formula its name or snap the mouse on corresponding to cell.

For task more complex molded possible to use the Master molded, residing on panels Standard.

After entering given in cell it is necessary to press the key Enter or key - an arrow.

For editing of the contents of the current cell press the key F2 and after contributing the change - Enter.

The Commands Format - a Line or Format - a Column allow to choose the width of the cell. The Width cell possible to assign the method to drag over the borders between lines and column in framing the table.

When filling or editing the table possible actively to use the font, style, justification and etc - here there are practically same possibility, as in word processors Microsoft Word.

Automation of the entering data. For entering reiterative given it is necessary to do the current first cell of the selected range and fill her(it). Then install the pointer a mouse on lower right corner of the cell - on marker automatic filling (?), cursor takes the form крестика (+) and pull, data will multiply. If the contents of the cell - a number, that it automatically increases on unit. If it is required more complex way of the change to sequences of importance, that follows to give command a Reading - Fill - a Progression. In dialogue window Progression choose the direction of the filling, type of importance, step of the change and final importance.

Separation cell. For performing operation with cell, their it is necessary to select. The Separation possible to execute several ways:

-drawing mouse;

-cursor under pressed key Shift;

-for choice integer column and lines use the markers a column or lines on edge of the workspace.

Copy and move possible method drag over. For this it is necessary to install the pointer a mouse on border of the current cell or chosen range. After he will take the type of the arrow, possible produce drag over. If drag over uses shift to the right button mouse, that is opened contextual menu, allowing choose the produced operation.

-select the part of table, for which is required sorting;

-give the command Given - a Sorting;

- in appeared window of the dialogue to choose the necessary column for sorting (or line);

- then choose the variant of the sorting (on growth or on decrease) and if it is necessary to choose second (and even the third) column? for additional sorting.

- Snap on button OK.

When filtering are reflected only record, possessing necessary characteristic. For performing the filtering it is necessary:

-select the necessary column;

-give the command Given - a Filter - Avtofilter;

-in chosen column will appear button, snap on her and choose necessary, for instance, condition:

-in appeared list to indicate the condition and write importance;

-confirm the choice a snub on button OK.

The Order action:

• 
  start the master of the diagrams;
  
• 
  choose the type of the diagram and in right window - a subrange, snap on button Hereinafter> in appeared dialogue window to indicate the interval a cell, on base which is built diagram, and snap on button Hereinafter>;
  
• 
  in following dialogue window, choosing corresponding to вкладки, indicate the headline, Legend (the explanations to element of the diagram), signature of importance, snap on button Hereinafter> in following window of the dialogue to indicate, where place the diagram;
  
• 
  snap on button Ready.
  

For preview of the divined range of the pages choose Print - a Pages, indicate the number of the pages in floor, and press the button a Viewing.

Exterior of the pages in window of the preview depends on available font, permits of the printer, amount available color.

If sheet Excel contains the built-in diagram, in window of the preview is displayed both sheet Excel, and diagram. Displacement and change the sizes of the diagram in usual mode possible or in mode of the sectoring the page. If diagram was chosen before striking the button Preview, Microsoft Excel will display only it.

The Button Hereinafter serves the following page of the sheet for viewing. The Button Back serves the previous page of the sheet for viewing. To enlarge the scale or return in mode of the image of the full page, press the button a Scale. When increase size printed page does not change. Enlarge the scale and return in mode of the image of the full page possible, also, having snapped any area of the sheet.

The Button Print serves the chosen sheet for installing parameter print and print. The Button Page serves for adjusting parameter unsealed pages.

The Button of the Field serves for image and hidings marker adjustment by flap of the page, flap upper and page footer and widths column.

The Button Sectoring the page serves for switching in page breakup view mode. Adjustment breakup pages of the active sheet Excel is executed In this mode. Also possible change the sizes of the area of the print and change the sheet Excel.

The Button Usual serves for image of the active sheet in usual mode. The Name of the button varies through Usual if striking the button Preview was an active view mode breakup pages.

The Button to Close serves for closing window preview and transition on the current sheet.

If on sheet Excel is given area of the seal, will be on computer to print only this area. If it is chosen range cell and is installed small flag, Chosen range, will is typed cells thereof range, but determined on sheet Excel area of the seal will be ignored.

1.В menu File choose the command a Print.

2.В group to Out type choose the necessary parameter.

3. If it is necessary to выводимая table completely took seats on one sheet, that it is necessary to assign the Scale of the print by command File-Parameters of the page - in section Scale to install the switch on line. Place no more than on page on width on height.

At printouts on computer several sheets at a time, follows to select them before printing

The Program Excel allows to use within the framework of one worker of the book several workers sheet. The Names worker sheet are indicated on tag in lower lion to corner of the workspace. The Choice worker sheet for the current functioning execute the snub on corresponding to tag. Each worker sheet keeps its pointer of the current cell so when return on worker sheet position of this pointer is restored.

To create the additional worker sheets, follows to choose the worker a sheet, before which must be added new sheet, and give the command an Insertion > Sheet. Change the order of the following worker sheet possible перетаскиванием tag.

To change the name a worker sheet, it is necessary twice to snap on his(its) tag. Hereon follows to enter the new name and press the key ENTER.

The Formulas present itself expressions, on which are executed calculations on page. The Formula begins with equal sign (=). Is it Below cited an instance formulas, multiplying 2 on 3 and adding to result 5.

=5+2*3

The Formula also can include the following elements: functions, references, operators and constants.

The Action of such protection spreads on the whole book. To hide from the other users whole book, but leave the access to her(its) contents, for instance макросам, choose the command to Hide in menu Window, but then save скрытую book. Protection of the general book. The General book possible to protect, having forbidden her(its) monopoly use or removing after-look journal books. If it is required fix the password for removing given type of protection, necessary to use protection before determination of the joint access to book. Using of protection automatically includes the mode of the joint access to book. Mode of the joint access is disconnected When removing of protection to book and deletes the saved after-look journal. The Other variant is protection of the joint access to book and after-look journal without use the password. The Givenned type of the protection possible to use if to book already open joint access. In this case removing of protection will not bring about cancelling the joint access or removing after-look journal.

After this lesson, you should be able to write essay (about 250 words):

- Protection data in MS Excel.

Lecture 8. Information Technology in the Real World – Databases. Microsoft Access

The first databases implemented during the 1960s and 1970s were based upon either flat data files or the hierarchical or networked data models. These methods of storing data were relatively inflexible due to their rigid structure and heavy reliance on applications programs to perform even the most routine processing. In the late 1970s, the relational database model which originated in the academic research community became available in commercial implementations such as IBM DB2 and Oracle. The relational data model specifies data stored in relations that have some relationships among them (hence the name relational).

Figure 30 – What is DATABASE?

• 
  You and your project partner are editing the same file.
  
• 
  You both save it at the same time.
  
• 
  Whose changes survive?
  

Below are two examples of tables in a relational database for a local bank:

Accounts Table

The Customer table has 6 columns (CustomerID, Name, Address, City, State and Zip) and 4 rows (or records) of data. The Accounts table has 5 columns (CustomerID, Account Number, Account Type, Date Opened and Balance) with 6 rows of data.

Each of the columns conforms to one of three basic data types: Character, Number or Date. The data type for a column indicates the type of data values that may be stored in that column.

Number - may only store numbers, possibly with a decimal point.

Character - may store numbers, letters and punctuation. Access calls this data type Text.

Date - may only store date and time data.

In some database implementations other data types exist such as Images (for pictures or other data). However, the above three data types are most commonly used.

Notice that the two tables share the column CustomerID and that the values of the CustomerID column in the Customer table are the same the values in the CustomerID column in the Accounts table. This relationship allows us to specify that the Customer Mr. Axe has both a Checking and a Savings account that were both opened on the same day: December 1, 1994.

Another name given to such a relationship is Master/Detail. In a master/detail relationship, a single master record (such as Customer 1003, Mr. Axe) can have many details records (the two accounts) associated with it.

In a Master/Detail relationship, it is possible for a Master record to exist without any Details. However, it is impossible to have a Detail record without a matching Master record. For example, a Customer may not necessarily have any account information at all. However, any account information must be associated with a single Customer.

Each table also must have a special column called the Key that is used to uniquely identify rows or records in the table. Values in a key column (or columns) may never be duplicated. In the above tables, the CustomerID is the key for the Customer table while the Account Number is the key for the Accounts table

The main features of this main screen are the menu bar that runs along the top of the window and the series of tabs in the main window. The menu bar is similar to other Microsoft Office products such as Excel. The menus include:

• 
  File - Menu items to Open, Close, Create new, Save and Print databases and their contents. This menu also has the Exit item to exit Access.
  
• 
  Edit - Cut, Copy, Paste, Delete
  
• 
  View - View different database objects (tables, queries, forms, reports)
  
• 
  Insert - Insert a new Table, Query, Form, Report, etc.
  
• 
  Tools - A variety of tools to check spelling, create relationships between tables, perform analysis and reports on the contents of the database.
  
• 
  Window - Switch between different open databases.
  
• 
  Help - Get help on Access.
  

• 
  Tables - Displays any tables in the database.
  
• 
  Queries - Displays any queries saved in the database.
  
• 
  Forms - Displays any forms saved in the database.
  
• 
  Reports - Displays any reports saved in the database.
  
• 
  Macros - Displays any macros (short programs) stored in the database.
  
• 
  Modules - Displays any modules (Visual Basic for Applications procedures) stored in the database.
  

You can do the labs using Access 2007 as well. The main windows when starting access look somewhat different but the wizards and the very important property windows look reasonably the same.

Figure 31 – Creating database

Figure 32 – Working with table

First, you will need to create tables. They are the basic modules you need - also in Access 2007 —when you build a database application.

Later, you will learn about Forms as GUIs for entering data into tables, and Reports for showing data from tables.