IT LAB WORK

Computer
Computer it is an electronic device which takes the data as input from the keyboard, process it and gives the result as output on the screen.






Components of Computer

There are four components

1) CPU
2) Input Unit
3) Output
4) Storage unit

CPU: -
This unit performs processing of instructions and data inside the computer. It is “administrative “Section of the computer system. It interprets, coordinates the operation and supervises the instruction.






The CPU itself has three parts

1) ALU:-This unit performs the arithmetical and logical operation on the stored number.

2) Control Unit: - It checks the correctness of Sequence of operations.

3) Memory Unit: -

This unit holds the intermediate results during the course of calculation and provides the data as and when required. The internal storage is primary or secondary memory

INPUT UNIT:-
This unit Accepts instructions and data.

OUTPUT UNIT:-
This unit communicates the result to the user.

STORAGE UNIT :-
This unit stores temporary and final results.


Information processing has five steps as explained below:-

INPUT:
At this stage information enters to the computer. The common input devices are keyboard, mouse, camera etc.


PROCESSING:

The next stage is processing. It is important once information is stored in the computer, it can be processed according to your requirements.

OUTPUT:
To see what the computer has processed this stage is useful. The processed information can be output to a screen, printer, speakers etc..,



STORAGE:

Information in the form of programs and data that are not currently useful normally stored so that can be loaded back into the computer at any time. Here the information is safe and secured.

DISTRIBUTION:

Information can be distributed from one computer to another computer without creating there. Here it saves the time to create the information again and again; two popular ways to do so are...


MS-OFFICE:

Microsoft Office is a collection o0f software application. All applications share some common programs and looks such as menu bars, tool bars, spell checking, auto correct, help, the office assistance etc.,

MS- WORD:

MS-Word is a word processing program. It is used generating any type of printed document including letters, reports, memos, tables, new letters, and electronic mails.

MS-EXCEL:

Excel is a spread sheet application that enables you to do mathematical calculations. It is used to prepare budget and price costs, prepare costs, format figures and create graphs and charts.

MS-POWERPOINT:

Power point is a presentation application that produces colorful professional presentation slides.








INTERNET

The internet is a global network of networks connecting millions of users World Wide via many computer networks using the simple standard common addressing system and communications protocol called TCP/IP(Transmission control protocol/Internet protocol). This includes federal networks, regional networks, educational and some foreign networks. The connection between the different networks is called “gateways”. These gateways serve to transfer electronic data world wide.

For most of its existence the Internet was primarily a research and academic network. More recently, commercial enterprises and a vast number of consumers have come to recognize the internet’s potential. Today people and businesses around the world can use the Internet to retrieve information, communicate and conduct business globally, and access a vast array of services and resources on-line.

The primary use of the Internet is electronic mail (commonly called “e-mail”). Millions of people use the Internet for electronic mail capabilities. Electronic mail however, is only a small part of what the Internet offers. There’s also
· Chat groups
· The world wide web
· E-mail and mailing lists
· Bulletin boards and newsgroups
· Remote computer access(TELNET)
· File transfer(using ftp, or file transfer protocol)

TECHNOLOGY:

When you send a message over the internet it is broken into small pieces, called packets, which travel over many different routes between your computer and the recipient’s computer.

TCP/IP:

The communications protocol used to route the packets across the internet is TCP/IP (transmission control protocol/internet protocol).use of this standard protocol enables computers using different operating systems to communicate with each other. DOS-based PC’s, PC’s, using the Microsoft windows(R), Windows 95, or windows NT(TM) operating system, Macintosh(R) computers, and UNIX(R)-based systems all use TCP/IP to connect to the Internet.






CLIENT/SERVER:

Once you connect to the Internet, you interact with other computers using a client/server model. The resources of the internet – information and services—are provided through host computers, known as servers. The server is the computer system that contains information such as electronic mail, database information, or text files. As a computer, or “client”, you access those resources via client programs (applications) which use TCP/IP to deliver the information to your screen in the appropriate format for your computer.

BROWSERS:

A browser is a client program (application) that is used to search through information provided by a specific type of server. A browser helps you view and navigate through information on the internet. Today’s most popular browsers, including Mosaic(R), Netscape(TM) Navigator, and the Microsoft Internet Explorer offer a graphical interface to the world wide web.



























Introduction to ms-excel
Microsoft Excel is a spreadsheet program that is used to store, sort and efficiently crunch numbers. Accountants use Excel to keep track of transactions for their company. Students might use Excel to help draw conclusions from the data they gathered on a science project.


Excel Basics
Create a New File
Before you can start learning to use Excel, you need to create a new workbook that will store your data. To create a new Excel workbook follow these steps:
1. Open Microsoft Excel
2. With the mouse, go to the Excel menu bar and left-click the File menu


3. Within the File menu find and left-click New
4. There should now be a New Workbook pane on the right side of your Excel program


5. Left-click Blank Workbook to create a new workbook
Save a New File
Saving frequently, especially after major changes, is a very important practice you should pick up. Lucky for you, saving in Excel takes only a second and in time you'll probably be doing it without any thought!
1. Add some data to your currently blank spreadsheet
2. On the keyboard push Ctrl + S (press and hold the control key then push S key while still holding down control) to save your work!
3. If this is the first time saving the current file then you will be greeted with a Save As popup


4. At the bottom of this popup is a field labeled File name and currently contains the text "Book1.xls". Replace this with any name you want to give your file,
5.

6. Before you press Save, pay attention to where you are saving your file to. The default location Excel saves to is the My Documents folder and we suggest you save there if you are not very comfortable with navigating the Windows File System.
Pushing Ctrl + S will just save your file after you have specified a filename in step 5. We recommend that you save your file at least every 5 minutes. It only takes a second and just think how happy you'll be if your computer crashes or the power goes out and you won't have to worry about losing information!
Remember, use the keyboard shortcut Ctrl + S often!
Open an Existing File
Now that we have a saved file we can attempt to open an existing file. If you name your file the same as we did then we're going to have a scavenger hunt for the file named "TizagBasics.xls". To open a file in Excel just follow these three steps:
1. Go to the Excel menu bar and left-click the File menu
2. Within the File menu find and click the Open choice
3. If this is the first time saving the current file then you will be greeted with a Open popup


4. You should currently be in the "My Documents" folder, if not please navigate there.
5. Find your file "TizagBasics.xls" and double-click the file to open it.
Close a File
There are two options for closing your Excel file. You can close your file but keep Excel open or you can close your file along with Excel. To only close your file follow these steps:
1. Click the lower of the two X's that appear in the top right.
2. If you have made any changes to your file you will be prompted to save before you quit, you should do so.


To close both your file and Excel follow these steps:
1. Click the upper X that appears in the top right. Notice that this X rests on a raised gray square.
2. If you have made any changes to your file you will be prompted to save before you quit, you should do so.


Undo Changes
This could quite possible be the greatest invention man has ever created! The ability to undo a mistake without having to start over! If you're like me, you make more than your fair share of mistakes, especially early in the morning. In Excel there is a quick and easy shortcut to undo mistakes.
1. Make a bunch of mistake in your Excel spreadsheet (this may be easier for some)
2. Using the keyboard press Ctrl + Z (press and hold the control key and press the Z key while still holding down control)
3. Notice that your last change was just undone!
4. Continue to press Ctrl + Z until all your mistakes have been undone
For undoing a lot of mistakes just hold down the keyboard shortcut Ctrl + Z. Be careful though, it goes quite fast when you hold it down!
Redo Changes
Chances are you will accidentally undo something that was not a mistake sometime while using Excel. Good thing there's an undo for undo, aptly referred to as redo. To reverse your undo follow these steps:
1. Undo something you don't want to undo
2. Using the keyboard press Ctrl + Y (press and hold the control key and press the Y key while still holding down control)
3. Notice that your last undo was just reverted!
4. Continue to press Ctrl + Y until all your accidental undos have been "redone".
· cell(s): B3 and the range of cells from B4:B7
· constant(s): 5
· function(s): SUM()
Excel Formulas: Creating Your First Formula
This first formula will be as simple as they come and will teach you the basic form of an Excel formula. Create a new spreadsheet and then follow these steps:
1. Select cell A1
2. Type the following basic arithmetic formula into cell A1: =1+1


3. Press Enter and notice how cell A1 changes from your formula to the result!


This may seem simple, but there are a some very important things you should get out of this example. When you start off a cell entry with the equal sign "=" you are telling Excel that you want it to evaluate the following formula.
In our case we had a simple "1+1" we wanted Excel to solve for us. You can do this for addition, subtraction, multiplication, division and any other operation you can think of.
Remember, if you do not start your entry with the equal sign, then Excel will not evaluate the cell!
Using Cells to Create Dynamic Formulas
The most powerful aspect of Excel is not the simple calculator abilities we describes in our first formula example, but rather the ability to take values from cells to be used in your formulas.
Let's set up a basic sales spreadsheet to help explain this topic.
1. In cells A1-D4 enter the following information:



Notice: that cell D2 and D3 are blank, but should contain the amount of money from selling 150 candy items and 3 vegetables. By referencing the Quantity and Price cells we will be able to do this! Let's begin with Candy.
2. Note: It is very important to follow these steps exactly without interruptions! Select cell D2, candy's "revenue", and type the equal sign "=" to begin your formula.
3. Left-click on cell B2, Candy's Quantity and notice your formula is now "=B2"


4. We want to multiply Quantity(B2) by Price(B3) so enter an asterisk (*)


5. Now left-click on Candy's Price (C2)to complete your formula!


6. If your formula looks like ours then press Enter, otherwise you can manually enter the formula "=B2*C2". However, we really think it is easier and preferred to click on cells to reference them, instead of entering that information manually.
7. After you pressed Enter your Candy Revenue cell should be functioning properly and contain the value 75.


8. Using your newly gained knowledge please complete Vegetable's Revenue by repeating steps 2-7 for Vegetable
9. Your spreadsheet should now look like this:


Advanced Excel Formulas: Using Formulas in Formulas
Now that we have created separate revenues for both Candy and Vegetable it would be nice to somehow combine these two values to get the Total Revenue. Although both Vegetable Revenue and Candy Revenue contain formulas, we can still use these cells as we have been doing and add them together to get our total.
1. Select cell D5 (directly below "Total")
2. Type the equal sign "="
3. Left-click cell D2
4. Type the plus sign "+"
5. Left-click cell D3. Cell D5 should now contain this formula "=D2+D3":


6. Press Enter to complete your Total Revenue!


Excel Functions
Hopefully that title doesn't sound too intimidating because functions in Excel are really quite easy to use once you've learned the basics.

Excel Functions: Your First Function
Using our soccer goal Excel spreadsheet from the previous lessons, let's use Excel functions to figure out what the total number of goals scored by our team. Open up the soccer goal spreadsheet and follow these steps:
1. In cell A9 enter the text Total and make it bold


2. Select cell B9 and locate the formula bar (it's right under the Excel menu bar) and notice that it contains the content of cell B9, which just so happens to be nothing! Let's fix that


3. Notice the little fx to the left of the formula bar. This is the insert function button.
4. Left-click the fx button to bring up the insert function popup


5. Using the Excel "Search for a function" feature type in the text "Sum" and click Go


6. Make sure SUM is selected and click OK to bring up the Function Arguments Window



Before we go any further let's make sure you understand what we have done so far. First we selected a cell that we wanted to have our total goal count appear in. Next we inserted a function and chose the SUM function.

We've done quite a lot and the only thing that remains is to select which numbers we want to sum up. So let's finish this up!
7. Move the Function Arguments Window so you can see the goals scored.
8. We want to sum up all the goals scored, so we need to select all the cells that contain goals scored.
9. Starting at the top of the list, Tim's goals, left-click and hold in Cell B2 then drag down to cell B7, Jason's goals and finally release left-click. Your screen should now look like this:


10. Click OK and admire your work!












Excel Functions: General
Let's review the general ideas you learned in this lesson. First, you found out that you could insert a function using the fx insert function button

You also learned how to select arguments to be used in your functions. You can now add up Formatting part of a cell content in MS Excel
Sometimes you need to format part of the content in a cell. For example, you want to produce a reference to a footnote in the column header in cell D1:



The reference number should appear like a superscript.
To do this, follow these steps:

1 – edit cell D1 and add "1" immediately after "March"
2 – Select "1" and press the right button in the mouse to open the Format Cells dialog.



3 – Open the Format cells dialog and check the Superscript option.



Hit Ok and then Enter to finish the cell edit. Add the footnote. Your table will look now like this




In the same way you can change the font and/or the color of part of the cell's content, or use any of the other format options
Formatting part of a cell content in MS Excel

Sometimes you need to format part of the content in a cell. For example, you want to produce a reference to a footnote in the column header in cell D1:




The reference number should appear like a superscript.
To do this, follow these steps:

1 – edit cell D1 and add "1" immediately after "March"
2 – Select "1" and press the right button in the mouse to open the Format Cells dialog.



3 – Open the Format cells dialog and check the Superscript option.



Hit Ok and then Enter to finish the cell edit. Add the footnote. Your table will look now like this




In the same way you can change the font and/or the color of part of the cell's content, or use any of the other format options
Formatting part of a cell content in MS Excel
Sometimes you need to format part of the content in a cell. For example, you want to produce a reference to a footnote in the column header in cell D1:



The reference number should appear like a superscript.
To do this, follow these steps:

1 – edit cell D1 and add "1" immediately after "March"
2 – Select "1" and press the right button in the mouse to open the Format Cells dialog.



3 – Open the Format cells dialog and check the Superscript option.



Hit Ok and then Enter to finish the cell edit. Add the footnote. Your table will look now like this




In the same way you can change the font and/or the color of part of the cell's content, or use any of the other format options



Cell Referencing
Each cell in a spreadsheet is named by its column and row labels. The row labels are numbers and the column labels are letters. The first cell, therefore, is called A1. One row down and one column over is cell B2, and so forth.
To reference the value stored in a single cell, enter its coordinates as a function argument. For example, to have the data in cell B1 appear in another cell, enter =B1 into that cell.
Example 6-6. Some examples of function syntax
=EXP(B1)

=COS(A2)

· Charts and graphs
· Select the range of cells that includes the data you want to chart, including the column and row headings and any chart title. If you were using the data shown in above figure, you'd select cells A1 to B14.
For speedier chart building, just position your cursor somewhere inside the data you want to chart. Excel then automatically selects the range of cells that it thinks you want. Of course, it never hurts to remove the possibility for error by explicitly selecting what you want to use before you get started.

· Click the subtype you want. Excel inserts a new embedded chart alongside your data, using the standard options (which you can fine-tune later).



















Excel’s statistical analysis tools
Microsoft Excel provides a set of data analysis tools — called the Analysis ToolPak — that you can use to save steps when you develop complex statistical or engineering analyses. You provide the data and parameters for each analysis; the tool uses the appropriate statistical or engineering macro functions and then displays the results in an output table. Some tools generate charts in addition to output tables.
Related worksheet functions Excel provides many other statistical, financial, and engineering worksheet functions. Some of the statistical functions are built-in and others become available when you install the Analysis ToolPak.
Accessing the data analysis tools The Analysis ToolPak includes the tools described below. To access these tools, click Data Analysis on the Tools menu. If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program.
ANOVA
The Anova analysis tools provide different types of variance analysis. The tool to use depends on the number of factors and the number of samples you have from the populations you want to test.




























Microsoft Access Description
Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other program such as Microsoft Works.

. Some keywords involved in this process are: Database File, Table, Record, Field, Data-type. Here is the Hierarchy that Microsoft Access uses in breaking down a database.
Database File: This is your main file that encompasses the entire database and that is saved to your hard-drive or floppy disk. Example) StudentDatabase.mdb
Table: A table is a collection of data about a specific topic. There can be multiple tables in a database. Example #1) Students Example #2) Teachers
Field: Fields are the different categories within a Table. Tables usually contain multiple fields. Example #1) Student Last Name Example #2) Student First Name
Datatypes: Datatypes are the properties of each field. A field only has 1 data type. Fieldname) Student Last Name Data type) Text


Starting Microsoft Access
· Two Ways
1. Double click on the Microsoft Access icon on the desktop.

2. Click on Start --> Programs --> Microsoft Access


Creating New, and Opening Existing Databases




The above picture gives you the option to:
· Create a New Database from scratch
· Use the wizard to create a New Database
· Open an existing database
o The white box gives you the most recent databases you have used. If you do not see the one you had created, choose the More Files option and hit OK. Otherwise choose the database you had previously used and click OK.

Create a database using the Database Wizard
1. When Microsoft Access first starts up, a dialog box is automatically displayed with options to create a new database or open an existing one. If this dialog box is displayed, click Access Database Wizards, pages, and projects and then click OK.
If you have already opened a database or closed the dialog box that displays when Microsoft Access starts up, click New Database on the toolbar.
2. On the Databases tab, double-click the icon for the kind of database you want to create.
3. Specify a name and location for the database.
4. Click Create to start defining your new database

Create a database without using the Database Wizard
1. When Microsoft Access first starts up, a dialog box is automatically displayed with options to create a new database or open an existing one. If this dialog box is displayed, click Blank Access Database, and then click OK.
If you have already opened a database or closed the dialog box that displays when Microsoft Access starts up, click New Database on the toolbar, and then double-click the Blank Database icon on the General tab.
2. Specify a name and location for the database and click Create. (Below is the screen that shows up following this step)







Tables
A table is a collection of data about a specific topic, such as students or contacts. Using a separate table for each topic means that you store that data only once, which makes your database more efficient, and reduces data-entry errors.


Tables organize data into columns (called fields) and rows (called records).



Create a Table from Design view

1. Double-Click on "Create table in Design view".
(DESIGN VIEW)

2. Define each of the fields in your table.
o Under the Field Name column, enter the categories of your table.
o Under Data Type column, enter the type you want for you categories.
§ The attribute of a variable or field that determines what kind of data it can hold. For example, in a Microsoft Access database, the Text and Memo field data types allow the field to store either text or numbers, but the Number data type will allow the field to store numbers only. Number data type fields store numerical data that will be used in mathematical calculations. Use the Currency data type to display or calculate currency values. Other data types are Date/Time, Yes/No, Auto Number, and OLE object (Picture).
o Under the Description column, enter the text that describes what you field is. (This field is optional).
o For our tutorial enter the following items:










Primary Key
· One or more fields (columns) whose value or values uniquely identify each record in a table. A primary key does not allow Null values and must always have a unique value. A primary key is used to relate a table to foreign keys in other tables.
· NOTE: You do not have to define a primary key, but it's usually a good idea. If you don't define a primary key, Microsoft Access asks you if you would like to create one when you save the table.
· For our tutorial, make the Soc Sec # field the primary key, meaning that every student has a social security number and no 2 are the same.
o To do this, simply select the Soc Sec # field and select the primary key button

o After you do this, Save the table


Entering Data
· Click on the Datasheet View and simply start "chugging" away by entering the data into each field. NOTE: Before starting a new record, the Soc Sec # field must have something in it, because it is the Primary Key. If you did not set a Primary Key then it is OK













Manipulating Data
· Adding a new row
o Simply drop down to a new line and enter the information
· Updating a record
o Simply select the record and field you want to update, and change its data with what you want
· Deleting a record
o Simply select the entire row and hit the Delete Key on the keyboard


Create a Form using the Wizard
It is a very good idea to create a form using the wizard, unless you are an advanced user and know what you are doing. Microsoft Access does a very good job of creating a form using the wizard. The following steps are needed to create a basic form:
1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.
2. Click on the Forms button under Objects on the left side of screen
3.
4. Double click on Create Form Using Wizard
5. On the next screen select the fields you want to view on your form. Most of the time you would select all of them.
6. Click Next
7. Select the layout you wish
8. Click Next
9. Select the style you desire...HINT: if you plan on printing your form, I suggest you use a light background to save on printer toner and ink
10. Click Next
11. Give you form a name, and select Open the Form and enter information
12. Select Finish
13. You should see your form. To adjust the design of your form, simply hit the design button (same as with the tables), and adjust your form accordingly
Reports
A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.
Create a Report using the Wizard
As with the Form, it is a very good idea to create a report using the wizard, unless you are an advanced user. Microsoft Access does a very good job using the wizard to create reports.
1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.
2. Click on the Reports button under Objects on the left side of screen
3. Double click on Create Report Using Wizard
4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them.
5. Click Next
6. Select if you would like to group your files. Keep repeating this step for as many groupings as you would like.

7. Click Next
8. Select the layout and the paper orientation you desire
9. Click Next
10. Select the style you desire...HINT: if you plan on printing your report, I suggest you use a light background to save on printer toner and ink
11. Click Next
12. Give you report a name, and select Preview the Report
13. Select Finish

Microsoft Access is used within many businesses to store and access information. You can also create a simple report easily using the Report Wizard.
Open your Access Database and click on Reports located under the Objects field on the left hand side. On the top toolbar click on the New button to start a new report.

In the New Report window select Report Wizard and below that choose from the drop down list which query or table you want to gather data to create the report. In this instance I want to create a report about Tech_Company's Customers. After you have the correct data selected click OK.







This next part of the wizard allows you to select the various fields from the table or query you selected. This is great when you only want to create a report based on specific data within a table. Highlight the information in the Available Fields and press the arrow button to move it into the Selected Fields. Here I selected the customers First Name, Last Name, City, and Phone Number. At this point you could select Finish, but let's use a bit more functionality of the wizard, click on Next.



In this window you can select to add grouping to various parts of your data. Because I am demonstrating a simple report (additional tutorials on custom report writing are coming soon), just click on Next.

Here you choose what order the data will appear in the report. This is a customization you will need to decide on based upon how you wish to present the data. Here I choose to sort the Last Name of each customer in Ascending order.










This is where you will choose the layout of the report. Once again depending upon how you wish to present the data will determine the layout. For this report I choose Layout = Tabular, Orientation = Portrait, and I usually find it best to make sure to check the box "Adjust the field width so all fields fit on a page. This ensures all the relevant data is on each page and not scattered on multiple pages. Click on Next.












Next you will choose the style or appearance of the report. Once again use your best creative judgment. For this report I am choosing Bold. Click on Next.



. If this is going to be a report you plan on saving and running from time to time, make sure and use a good naming convention so you and other database users can easily find the report and run it. After you have named your report click Finish.











14.

forms


Create a Form using the Wizard
It is a very good idea to create a form using the wizard, unless you are an advanced user and know what you are doing. Microsoft Access does a very good job of creating a form using the wizard. The following steps are needed to create a basic form:
1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.
2. Click on the Forms button under Objects on the left side of screen
3. Double click on Create Form Using Wizard
4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them.
5. Click Next
6. Select the layout you wish
7. Click Next
8. Select the style you desire...HINT: if you plan on printing your form, I suggest you use a light background to save on printer toner and ink
9. Click Next
10. Give you form a name, and select Open the Form and enter information
11. Select Finish
12. You should see your form. To adjust the design of your form, simply hit the design button (same as with the tables), and adjust your form accordingly

Access Forms
Access provides an easy way to enter data into your Access tables with forms. In Access you have the ability to quickly make and customize these data entry forms to streamline the data input process. Learning how to properly create an Access form will save you a great deal of time
Using our previous example, imagine that Bob, from Bob's Shoe Store, has recently hired someone to enter all the sales data at the end of each business day. The only problem is this person does not know how to use Access, so Bob needs to make them a custom form in Access! This lesson will guide you through the process of creating a data input form in Access
Creating an Access Form
Although we haven't recommended the various wizards that Access had available in the previous lessons, the form wizard is actually very useful and should save you a bunch of time! Let's create a simple data input form for the new employee!
1. Navigate to the Forms section in Access


2. Double-click "Create form by using wizard"
3. We want all of the fields from tbl_Sales to be included in this form, so first select tbl_Sales from the drop down box "Tables/Queries"


4. The single right arrow will add one selected field at a time, but we want all the fields. The shortcut to add every field from a given table or query is to click the double arrow button. Do that and click Next.


5. Choose a Columnar layout and press Next
6. Choose any style and press Next (we chose "Sumi Painting")
7. Change the form's title to frm_EmployeeEntry



and click Finish
Open up your form and check it out!

Entering Data Using Access Forms
Now that the form has been created, Bob just needs to teach his employee how to enter in the data. Lucky for Bob it's as easy as one-two-three and won't take him long to bring his new employee up to speed.
1. Open up frm_EmployeeEntry (easy!)


2. At the bottom of the form is a set of arrows to navigate through the records. To get to the end of the existing records and begin entering data you need to click the arrow with an asterisk(*).


3. Clicking that button will bring you to the first blank record, which would be the sixth in our case. You would then enter all the data for that record and click the right arrow to advance to the next blank record. After all the new records have been entered, close the form and pat yourself on the back.
When you enter data into this form it will automatically add it to our existing tbl_Sales because we specified that table when we created our form. With this form the new employee will be able to enter data into Bob's existing Access table without ever knowing a thing about tables!