Customize Menus In Powerpoint 2003

Menus on the menu bar consists of commands that will help us in making our work easier. So we have an option to choose the menu commands that are mostly used by us in any Office program. In Microsoft Power point  2003 program we have context menus that are useful in making presentations and we can customize the commands in each menu.Let us see how can we do it.

Read More

Upper and Lower Functions

If we want to change the text in a cell to upper case of lower case, we use functions UPPER and LOWER. In Microsoft Excel, from its initial versions, functions have been of great use reducing the time of adding up all the data and doing it individually.

Read More

Insert Current Date and Time In A Cell

There is a simple way of inserting Date and Time in to a cell in an Excel Worksheet. Microsoft Excel provides an easier way of entering a date and time that is static and which gets updated along with computer clock, just by pressing keys and also by using functions.The value of date and time can vary as well according to the computer clock.

Read More

Creating a Database In MS Access 2010

 Microsoft Access has been evolved as one of the best user friendly database programs and it has added itself many features to enhance the user and developer accessibility and ability to work on it. In Microsoft Office 2010, many things have been added compared to its previous versions. We shall see how to create a database in Microsoft Access 2010.

---

To create a new database, do the following:

1) On the New tab in Backstage view, click Blank Database or Blank Web Database.

2) On the right, type a name for your database in the File Name box.

 

3) To change the location in which you create the file, click Browse folder  next to the File Name box, browse to and select the new location, and then click OK.

4) Click Create.

5) Access puts the cursor in the first empty cell in the Click to Add column of the new table.

Entering data in Datasheet view is designed to be very similar to entering data in an Excel worksheet except with a  restriction that the data must be entered in contiguous rows and columns, starting at the upper-left corner of the datasheet .

Read More

Uses of Microsoft Access

Microsoft Access is a database software program that makes manipulating data manageable for users of many skill levels. You can input data and sort, filter or group information according to your needs. It's particularly useful when there are thousands of records and sorting through them individually would take hours. Access allows you to obtain the information quicker by providing a few commands to tell the program what is being sought. Reports can be created, too, that pull information out of the database according to the project parameters.

Read More

Microsoft Access and its Versions

Microsoft Access is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is available with Microsoft Office Suite applications included in professional and higher editions. 

Read More

Insert Foot Note In Microsoft Word

Footnotes are tags that describe a word that has got a number as super script in paragraphs in the middle. They describe either the meaning or additional information about the word that is superscribed with a number. Notes are written at the end of every page. We usually find them in dictionary, Novels and story books. Microsoft word 2010 has given this option to insert footnotes in a very easiest way.

Read More