What is Microsoft Office - Free Microsoft Office training - Microsoft Office 2007

What is Microsoft Office - Free Microsoft Office training - Microsoft Office 2007

 I want to give a little bit information about Microsoft office 2007. Microsoft office is a bundles or packages of programs which uses in offices, banks, factories, industries, business and much more. Microsoft Office offer us to do all those works which are Mathematics, write a letter, write a Projects etc, we can do these all works with the help of MS Office software. Have you noticed that whenever a student get admission in computer institute after finished of "Windows Xp" the teacher starts them Microsoft Office course So from that we can notice that MS office is so important computer learning course. As we talked MS Office have a bundles of courses, like Microsoft Word, Microsoft Excel, Microsoft Power point, Microsoft outlook, Microsoft Access and Microsoft front page, But I will teach in my site Microsoft Word, Microsoft Excel with above 250 functions and formulas, Microsoft Access with projects, and Microsoft PowerPoint. Now I want to give you a little information about the branches of Microsoft offices. 

Microsoft Word:-

Microsoft word is a computer learning course which is a branch of Microsoft office. Microsoft word allows you to perform make a text page with comprehensive tool which need us to create a advance page. For example you can make a style of you text and also you can add a picture. Microsoft word use to create a letter, novel, newspaper, term paper, Result sheet, CV and much more.

Microsoft Excel:-

Microsoft Excel is a computer program which is use for calculation. We can make result sheet, records, projects and much more. Mostly we can use MS Excel in banks, offices, business etc…We calculate our value with the help of formulas and function in MS excel. For example =sum(A2:D2).

Microsoft Access:-

Microsoft access is a branch of Microsoft office but it doesn’t come with other version of Microsoft office. It’s use for creating a database, result sheet, report, project and much more..

The database of Microsoft office is made from 7 parts which is given below.

1)   Table

2)   Query

3)   Forms

4)   Report

5)   Modules

6)   Macros

7)   Relationship

Microsoft PowerPoint:-

Microsoft PowerPoint is a branch of Microsoft office which is use for different presentation. Microsoft PowerPoint has a comprehensive graphic tools which is use to create a advance page and also you can make a style of page. In PowerPoint we can also make slide show of text.

 

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

What is database

What is database

Ans) The collection of fact and figure which is related with each other is called database. Arrangement of data in database is like this. There is a few example of database which uses daily.
1) Dictionary
2) Arrangement of books in library 
3) Arrangement of Salary
4) Arrangement of Fee
Now we will work on this database that how to create a “Employee” database. For example there are 200 employee in a company and the Boss of company wants to know information about employee like What is the Name, F/Name, Position, Salary, Join date, Picture, Phone no and Address of an employee so there is an example of employee database which is given below. 

                                                                                                                

                                                                           
                                                  

Read More

What is Microsoft Access

What is Microsoft Access

Microsoft Access is a branch of Microsoft Office but it doesn’t come with other version of Microsoft Office. Microsoft Access is a ready made package from MS Office use to do several tasks projects, database, calculation, reports, and much more…

The database of Microsoft Office is made from 7 parts which are given below.

1)      Table

2)      Query

3)      Forms

4)      Reports

5)      Modules

6)      Macros

7)      Relationship

Read More

Open Microsoft Office - Open Microsoft Access - Open Microsoft Access with different methods

Open Microsoft Office  - Open Microsoft Access - Open Microsoft Access with different methods

1)      Click “Start” button then “All programs” and bring your mouse pointer to Microsoft Office and lastly click on “Microsoft Access”

2)      Click “Start” button then click on “Run” and type “Msaccess” and lastly click “Ok”.

3)      Click “Start” button then click on “Run” and then click on “Browse” button and select the location of Microsoft Access and lastly click on “Open” button. This is the address of Microsoft Access "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE".

 

After open Msaccess file click “OK” button from “Run”.

4)      “Right click” on windows desktop bring your cursor to new and then choose “Shortcut” as given below.

 

After click on “Shortcut” click “browse” to choose the location of file. After select the file clicks “Open” and then click “next” as given in the picture. This is the address of Microsoft Access "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE".

 

Click “next” and lastly click on “Finish” button.

5)      “Right click” on Microsoft access icon and click on “Properties” then go to shortcut menu and lastly type a shortcut in the front of “Shortcut key”. For example “Ctrl+Alt+A” and then click “OK” as given below.

 

6)      Click “My computer” and go to “Local disk C” then “All programs”, “Microsoft Office”, “Office12” and lastly click on “Msaccess”.

Read More

Database in Access - Create a database in Access - Microsoft Access training

Database in Access - Create a database in Access - Microsoft Access training

Now we will work on this tutorial that how can we make an Employee database. To make a database follow these steps which are given below.

1)      Open “Microsoft Access” then click on “Blank database” and lastly type “Employee” in front of “File name” and then click “Create”.

2)      Go to “Create” then click on “Table design”.

3)      Type an employee info like ID, Name, F/Name, Position, Salary, Join date, Picture, Phone no and Address as given below.

4)      “ID” in “AutoNumber”

         “Name” in “Text”

         “F/Name” in “Text”

         “Position” in “Text” or in “Lookup Wizard”

          “Salary” in “Currency”

          “Join date” in “Date/Time”

          “Picture” in “OLE Object”

          “Phone no” in “Number”

          “Address” in “Memo

5)      Why we have taken “Name” in “text” because we write a name in text so therefore we have taken it by text and like this “Salary” in “Currency”. After type the information click “View” from “Design” and then click on “Datasheet view” then click “yes” and type “Employeeinfo” then click “OK”. After click on “OK” button choose “No” primary key. Now type the information as given below. 

Q) How to get employee picture in Employee database?

Right click on the first “cell” of picture choose “insert object” and then bring you mouse pointer to “Create from file” now click “Browse” choose the picture and then click “Ok”. After click on “Ok” button check the “Link” on right side of “Browse” and lastly click “OK”. Now whenever we click on “picture first cell” then picture will directly open.

Read More