Employee data sheet - Create a Data sheet

Employee data sheet - Create a Data sheet

 The tutorial of the day is “how to create an Employee datasheet in MS Excel”. Today we will work on an “Employee datasheet” and our work will depend on some functions which are SUM, COUNTIF, MAX and MIN. To start this interesting tutorial follows these steps which are given below.

1) Start “Microsoft Excel 2007”.
2) Write “SNo, Name, Position, Salary, Join date, Experience, Phone no and Address” at the top of Excel Row as given below.

3) Now select your text then “bold” and “color” your text and also make a “border” from “Home” menu as given below.

4) Now fill your information at the below of “SNo, Name, Position, Salary...” as given below.

5) Now choose “color” and “border” for your information text as given below.

6) Now select two cells down and then go to “Home” menu and then click on “Merge & Center” command as given below.

7) Now write “Total Salary” in this cell and use this function =Sum(D2:D11) at the front of this cell as given below.

8) After type of function press “Enter” from keyboard. Now like this fill these name at the below of “Total Salary” as given below.

9) Now type these function at the front of all your text as given below.

10) Fill the above functions one by one and your value will define as given below.

11) Now “color” and “bold” your text and also make “border” of your text as given below.

 

Read More

Copy and Paste - Copy to Clipboard - Paste from clipboard

Copy and Paste - Copy to Clipboard - Paste from clipboard

 The tutorial of the day is How to copy multiple characters, Words, Sentences, paragraph or Picture in MS Word, MS Excel, MS PowerPoint or in MS Access. We can use this tutorial in all courses of Microsoft Office but we will do our tutorial in MS Word 2007. To copy multiples items in MS Word 2007 or in other courses of Microsoft Office follow these steps which are given below.

1)  Start “Microsoft Word 2007”.
2) Open a document from “Open” command or click “Ctrl+O” from keyboard.
3) After open of document click on “Clipboard” dialog box as given below.

4) Now select your “text” or “picture” and then click on “Copy” command or click “Ctrl+C” from keyboard. As you will copy your “text” or “picture” it will appear in “clipboard” as given below.

5) Now select your “text” or “picture” and then click on “Copy” command or click “Ctrl+C” from keyboard. As you will copy your “text” or “picture” it will appear in “clipboard” as given below.  

Read More

One to One relationship - Relationship one to one - One to One relationship in Access

One to One relationship - Relationship one to one - One to One relationship in Access

 Relationship:-

Is a kind of “attribute” which connect two or more than two tables is called “Relationship”.
We have three kind of Relationship which are given below.
1) One to One
2) One to Many
3) Many to Many

One to One relationship:-

Number First we will work on One to One relationship that how we can make “Relationship” between One to One table and we will work on “Employee database” by the example of “One to One table”. With the help of one to one relationship we can divide a long table by two tables. To make a “relationship” between two tables follow these steps which are given below.
1) Start Microsoft Access 2007
2) Click on "Blank database" then give a name "Employee" and lastly click on "Create" button as given below.

 
 3) Click on "Create" Menu and then click on "Table Design" command. As you will click on "Table Design" command after that fills your information after that take "Primary key" of ID. To take the "Primary key" of ID right Click on "ID" and then choose "Primary key" you can also get "primary key" from "Design" Menu which is given below.

     
Notes: What is different between Text and Memo in data type column?
Text: - Text is a field of “data type” which contains up to 255 characters in a cell or the length set by “field size” property and “Memo” is also a field of “data type” which contains up 63,999 character. Its mean that whenever a sentence or paragraph which can write more than 255 character than we use “Memo” like information.
4) Click on “View” command and then choose “Datasheet view” from “Design” or “Home” as given below.

5) Then click “yes” and type a name for example “Employee” and lastly click “OK”.
6) Close the table from “close” button or click “Ctrl+W” from keyboard
7) Again click on “Create” menu and then click on “table design”. Now fill the information in another table which is given below.

    

8) Again click on “View” command and choose “Datasheet View” from “Design” or from “Home” menu. After click on “Datasheet view” click “yes” and “type a name” for example “Employee 2” then click “OK” and lastly choose no primary key.
9) Also close it from “close” button or click “Ctrl+W” from keyboard.
10) Now go to “Database Tools” menu and click on “Relationships” command as given below.

11) As you will click on “Relationships” command choose both of table by the help of “Ctrl” button and then click “Add” as given below.

12) After click on “Add” button then click “Close”.
13) Now drag the first “ID” which has “Primary key” to another “ID” as given below.

14) After dragging of “ID” the three options will appear. Checkup the first one and then click on “Create” button as given below.

15) Now press “Ctrl+S” from keyboard to save it and then close the display of Relationship with the help of “Close” button or click “Ctrl+W” from keyboard.
16) Now Open the first table “Employee” with double clicks or right clicks on it and then chooses “open”. As you will open your “Employee” table fills it by your own information as given below.

17) Now as you will fill your information a “plus sign” will appear at the 1^st cell of ID as given below.

18) Click on “plus” sign and then fill your information.
            How to insert CV file?
            Right click on the first cell of CV and then click on “Insert object” as given below.

   
19) As you will click on “Insert object” a menu will display click on “Create from file” option and then click on “Browse” button now select your CV file then click OK and lastly also click OK.
Now like this also insert your Picture in picture column and fill your other information as given below.

        

This was our tutorial about One to One relationship in database and I hope you like this tutorial    

Read More

Create a certificate - make a certificate - make a certificate in Word

Create a certificate - make a certificate - make a certificate in Word

Today we have a great topic that how to create a English lanuage certificate. Yesterday i was thinking that what topic will better to teach then come in my mind that why not i teach to create a very designful certificate for english language. To create a certificate is very help you in MS Word that how it work and how we can use some useful commands of MS Word 2007. To create a English language certificate in MS Word 2007 follow these steps which are given below.

1)  Start "Microsoft Word 2007".
2) Click on "Page layout" menu and then choose "Landscape" from "Orientation" command as given below.

 

3) Click on "Page layout" menu then click on "Page color" and select "Red, Accent 2, Lighter 60%" color as given below.

4) Click on "Page Layout" menu then click on "Page Borders".

5) Click on "Page border" then click on color and choose "Red, Accent 2, Darder 50%". After choosing of color fix "width: 25 pt" and lastly fix Art to the following border or another any one you want and then click "OK" which is given below.

6) Click on "Insert" menu then click on "WordArt" command and choose "WordArt style 3". As you will click on "WordArt style 3" a menu will disply "type the name of institute, School name, Collage name, Institiute name" etc and fix the following setting and then click "OK" as given below.

  

7) Select your "WordArt text" then go to "Home" menu and click on "Center" command or click "Ctrl+E" from keyboard.

8) Now fill these information which are Name, F/Name, Level, Sex, Institute, and other informations which are given below.

   

9)  Click on "Insert" menu then click on "Text Box" and choose "Alphabet quote" from the list. As you will click on "Alphabet quote" it will appear in irregular rule so fix it at the right side and type "Picture" as given below.

This was the tutorial of the day i hope you like this topic. If you like my tutorial don’t forget about comments thank you for your visiting

 

Read More

How to create a resume in Word 2007

Today is a great topic that “how to create a resume in word 2007”. In this topic I will show you how to create a resume for your job so if you want to “create a resume” follow these steps which are given below.

1)   Start MS Word 2007

2)  Click on “Office button”

3) Then click on “New” command from Office Button or click “Ctrl+N” from keyboard.

4)  As you will click on “New” command from Office Button a menu will display which is given below.

5)  Now bring your scrollbar bar down and find “Resume or CVs”.

        As you will find “Resume or CVs” click on it as given below.

          

6) As you will click on “Resumes and CVs” option the three options will display if you have internet connection without internet connection it is impossible to do it. So as will click on “Resumes and CVs” option the three options will display which are “Basic Resumes, Job-Resumes, and Situation- specific resumes”. Click on Job-Resumes. As you will click on “Job-Resumes” a list of belong to “Job resumes” will appear which are given below.  

7) Choose one of them and then click on “Download” button which is given below.

8) As you will click on “Download” button the downloading of resume will start which is given below.

 

 Wait a few second then enjoy. I hope you like this topic thank you for reading dear friend and brother.

Read More

Make a Result sheet in Excel 2007

How to make a result sheet of students

Result sheet

Today I am going to teach you a very interesting topic that how to create a “result sheet”. In this topic we will create a “high school” result. We will work on some functions which are “Sum”, “Min”, “Mix”, “Average” and “IF”. Follow these steps which are given below to create a result sheet.

1) Start “MS Excel” program

2)  Fill your data by these information “SNO”,  “Name”, “F/Name”, “English”, “Chemistry”, “Mathematics”, “Physics”, “Biology”, “Drawing”, “History”, “Total Marks”, “Marks Obtained”, “Minimum no”, “Maximum no”, “Average”, and “Grade”.  Bold your text and then fill it by your own information as given below.

 3) Use this function in first cell of “Marks Obtained” which is given above.            =sum(F5:L5)                        As you will type this function “=sum(F5:L5)”. After type it press “Enter”. As you will press “Enter” our value will directly define as given below.

 4) “=sum(F5:L5)” In this function the first is =. = we use it at the beginning of every function and number second is “Sum”. Sum function is use for adding of value and the last think of this function is (F5:L5) is the area of values that we want to add. (F5:L5) means (F5 cell to L5).

5) Now follow these steps which are given below.

6)  The next column is about “Minimum no”. In this column we will find the minimum no of paper that what the minimum mark is. To find the minimum no of paper type this function at first cell of “Minimum no” column “=Min(F5:L5)” as given below.

 

 7) Drag “Minimum no” column also like “Marks Obtained”.
8)  Now we are going to work on “Maximum no” column that how to find the maximum no of paper. To fine the maximum no of paper we use the function              “=max(F5:L5)”          as given below.

 After type of function press “Enter”. As you will press “Enter” the value will define. Drag it below.

9)  Now is the turn of to find the “Average” of your marks. To find the average of mark type this function at the first cell of “Average” column          =Average(F5:L5)           as given below.

 After type of function press “Enter” and drag it as given below.

10)  The last think is to find the “Grade” of your marks. To find the Grade first of all click on the first cell as given above and then type in “Formula bar” as given below.

 After click on “Formula bar” type the below function 

  =IF(N5>=550,"Grade A",IF(N5>=450,"Grade B",IF(N5>=400,"Grade C",IF(N5>=350,"Grade D","Failed"))))

 
 Press “Enter” and drag it as given before.
11)  Select your Result sheet and click on “Outside broders” and then select a color of background and then click on it as given below.

 This was our topic of the day I hope we like it.

Read More

Add a slide in powerpoint

Add a Slide in powerpoint

To add a new slide in MS PowerPoint 2007 first of all starts “MS PowerPoint” click on “Home” menu and then click on “New slide”. As you click on “New slide” a list of slides will open with some options which are given below.
 

Choose a slide which you want to need.

1) Duplicate Selected Slides:-

 With the help of this option you can take “Duplicate of your slide”. For example you are working on a “Title and Content” slide and you want to get a duplicate of it so for that time we use this option.

2) Slides from Outline...

Now we will work on this option that what are the properties of this option. With the help of this option we can get a topic etc from other program. For example we have a topic in “MS Word” and now we want to bring that topic from “MS Word” to “MS PowerPoint”. So for bring topic from another program to “MS PowerPoint” first of all follow these steps which are given below.

(i)         Click on “Slide from Outline…” option from “New slide.

(ii)    Now select your “MS Word” document which you want to open and then click “Insert”.

(iii)   As you will click on “Insert” option your text will appear in unarranged role. Bring your mouse pointer at top of topic and then click. Now fix it by the help of “Enter”. Press “Enter” again and again to fix the place of your text which is given below.

 

 

1)

Read More