Parts Of A Report In MSAccess 2010

In Access, the design of a report is divided into sections. In a client database, you can view your report in Design view to see its sections. In Layout view, the sections are not as obvious, but they are still there, and can be selected by using the drop-down list in the Selection group on the Format tab. To create useful reports, we need to understand how each section works.  

Read More

New Features of Reports in Access 2010

Creating a report in Access 2010 is a very similar process to creating a report in Access 2007. However, in Access 2010 there are a few new features that pertain to reports:

Read More

Prevent Navigation Pane at Startup

By default, the Navigation Pane appears when you open a database in Microsoft Office Access 2007, even if the database was created in an earlier version of Access. In an open database, you can hide or show the Navigation Pane at any time. You can also set the default option in an open database so that the Navigation Pane does not appear the next time the database is opened. 

Read More

Convert a Database from One Format to Another

If we have an existing database that we want to convert to a different format, you can choose a format under the Save Database As command. This command preserves the database in its original format and creates a copy of the database in the format you specify. You can then use the copy of the database with the version of Access that you want.

Read More

Change Default File Format In Access

When we create a new, blank database, Access asks us to name the database file. By default, the file is given the ".accdb" extension. It is created in the Access 2007-2010 file format and is not readable by earlier versions of Access.

Read More

Manually Rename Office Document Cache

 
Cache is a place where the data is stored. It is a memory part of computer's memory. It can be either a reserved section of main memory or an independent high-speed storage device. If your Office Document Cache needs an upgrade or repair, and the upgrade or repair fails, you can create a new cache by manually renaming your existing one.

Read More

Upload Center And Its Uses

Microsoft Office 2010 has brought a new feature in it- Upload center. It gives us a way to see the state of files we're uploading to a server, in one location. When we upload a file to a web server, Microsoft first saves that file locally to the Office Document Cache before it starts the upload, which means that we can save changes and immediately continue working even when you are offline or have a bad network connection.

Read More

Types of Document Properties

Document properties, also known as metadata, are details about a file that describe or identify it. Document properties include details such as title, author name, subject, and keywords that identify the document's topic or contents.

Read More

Change The Number of Recently Used Files

In Microsoft office programs we can easily see the recently used files and places that we have accessed on the computer. These files may be used to see the last document made, or for any kind of information. 

Read More

Clear Recently used Files

Many Microsoft Office programs display the last few documents that are opened in that program so that we can use those links to quickly access files. This feature is turned on by default, but we can turn it off, turn it back on, clear, or adjust the number of files that it displays.

Read More

Adding Numbers In A Cell

 

In Excel 2010 or any version we can easily add numbers in a cell easily. Excel is a beautiful program that helps in making calculation easier.

Read More

Check If 2010 Presentation Works With 2003

We can run the Compatibility checker in Power point 2010 to check if it is compatible with previous versions. 
The Compatibility Checker finds potential compatibility issues between PowerPoint 2010 and earlier versions of PowerPoint, and creates a report to help you resolve any issues.

Read More

Convert a Document into Word 2010 Mode

We can work in Compatibility Mode or we can convert the document to the Word 2010 file format to work on a word document that is of earlier. The Word Convert command clears the compatibility options so that the document layout appears as it would if it had been created in Word 2010. If the file is in .doc format, the Convert command also upgrades the file to the .docx format.

Read More

Determine The Mode Of The Document

When we save the Microsoft word documents in different formats that are of earlier versions we can be able to open them in those versions. Similarly we can open the file of earlier versions of Microsoft word in Office 2010.When a document is opened in Microsoft Word 2010 that was created in an earlier version of Word, Compatibility Mode is turned on.

Read More

Save File as Previous Version

While using Microsoft Office 2010 we have an option to save it as previous versions which is very vital when someone don't have a latest version of Microsoft Office. Office 2010 continues the use of the XML-based file formats, introduced in the 2007 Office release, for files created in Word, Excel, and PowerPoint. However, the Office 2010 programs may have features and functions that aren't supported in the 2007 Office release. Office 2010 does not support saving in Microsoft Office 95 and earlier.

Read More

Prevent Page Breaks In A Table

When we are documenting in Microsoft Word, we may insert page breaks. Sometimes that will insert breaks in tables as well. So we have an option to prevent page breaks in a Table. 

Read More

Find The Number of Words In A Sentence

If we want to count the number of words in a sentence instead of whole page or the document, we can do it easily using the same word count feature. 

Read More

Page Break In Microsoft Word 2007

Page Break will insert a break at the current location of the cursor or we can insert the page breaks automatically where ever we want. Microsoft Office has done it in an easier way.

Read More

Protect Documents using Word 2003

In Microsoft Word 2003 we have an option to choose who can edit the document that is created by us and what are the features that they can change. This is very helpful in keeping the formatting of the documents by others. We can restrict them from formatting the document. 

Read More

Line Spacing In Microsoft Word 2003

When we are writing text in documents we may need to check the line spacing sometimes. The space between one line and other will vary depending on different parameters, the text we copy may change the line spacing on the word document. Microsoft Office has given an option to change the line spacing.

Read More

Picture Background In Power point 2003

As we insert pictures in Microsoft Word we can set pictures as background for the slides as well. In powerpoint we have an option to insert images into slides as background. 

Read More

Paste Special option In Microsoft Excel

When we are using Excel we will come across formatting, formulas and many settings,but while pasting we may not paste all the formatting into another cell. Then we use paste special to paste just what we wanted.

Read More

Trace Precedents Of A Formula

If we find a formula in the middle of the data and if we want to know the data that is being used in that formula we may need to search for the addresses in the formula bar. Microsoft Excel has provided us another feature to see the cells and data used for that formula.

Read More

Error Checking In Microsoft Excel 2003

Microsoft Excel we have error checking for formulas and functions. It will show the cell with some special characters with 'NAME?' followed by them. To know the error we need to click on that cell to see the error in the formula bar or we can see the details of the error by choosing the error checking option.

Read More

Information Rights Management-Office2003

In Microsoft Office 2003 we can secure our documents by restricting the access to the file. For this we need to install Windows Rights Management Client. It comes under Information Rights Management which helps prevent sensitive documents and - e-mail messages from being forwarded, edited or copied by unauthorized people.

Read More

Erase Table In Microsoft Word 2003

When we insert table in Microsoft word 2003, sometimes we may insert more number of rows or columns or they might have been left out after inserting data in to it. At those times we can erase table in using them. 

Read More

Insert Table In Microsoft Word 2003

Tables are very useful in representing some numerical or statistical data. In Microsoft Word 2003 we have an option to insert tables in to the document. 

Read More

Insert Symbol In Microsoft Word 2003

In documenting some scientific data we may need to insert some symbols like Alpha, beta etc to do the calculations or to show the formula. In such instances we may insert symbols from the Word's gallery. 

Read More

Animal Trough in Farmville

Animal Trough is a place where we feed animals in Farmville. Once we fill the trough with animal feed it attracts one of a number of typically available animals which you can be adopted for our farm.Once an animal is adopted , Feed Trough will need to get filled up again in order to attract another farm animal.

Animal trough can be purchased from market in Buildings Under Animals Tab. 

If you do not choose to place it when we get a gift from a friend or just as an update we can later go into Gift Box for placement later. Once we click on the Animal Trough and choose “Look Inside” we’ll see this window.

Next we need to get the Animal Trough filled which will take 20 units of Animal Feed to top off the Trough. We can acquire Animal Feed in one of two ways—you can buy it by clicking on the “Buy Feed” button which costs 1Farm Cash for one unit of Animal Feed. If you click on the “Ask For Feed” you’ll be prompted to put a notice up on your Facebook feed asking for more Animal Feed. You can also acquire more Animal Feed through feed posts.

 

We can get Animal Feed in other way as well- 
When our neighbors visit our farm, they can click on our Animal Trough to give one unit of Animal Feed or, if you visit them, you can click on their Animal Trough and gift them a unit of Animal Feed. When we fill our neighbor's Animal trough at times we will get two more units of animal feed as bonus. 

The Animal Feed Trough window shows visually how full theTrough is, and has six mug shots of the animals known to be nearby that may wander onto your farm. Animals will drop out of the rotation eventually and new animals inserted, so the six won’t stay the exact same for long.
The visual state of the Animal Trough changes as it fills up with Animal Feed:

Once the Animal Trough is filled with Animal Feed you’ll get a notice:

Sometime in the next day or so an animal will stop by and enter the Animal Trough. You’ll be able to tell by the fact that the light above the building entrance is green, the doors are closed, and the feed has been drained. If you visit the Animal Trough in time, you will be successful in adopting the animal for your farm and will have an option to share one with your neighbors. 

All of your Animal Feed will be used up and you’ll need to fill your Animal Trough back up again to get another animal. However, if you wait too long, more than a couple of days, the animal will go away. You’ll see the following window instead:

By losing the animal you’ll only lose 2 units of Animal Feed, so you’ll have 18 units instead. The mug shot board in the Animal Trough will reflect which animals you’ve adopted and which still remain to be adopted.

Read More

See System Info From Microsoft Word 2003

When we use Microsoft Word 2003 version we can see the system information as well. System Information gives information about hardware resources, information about software that are installed on the PC and all the computer components as well. 

Read More

WordArt Color in Microsoft Word 2003

Word Art is a feature in Microsoft Office Programs that will insert the selected words in pre-defined shapes and styles. But it will apply the shapes that comes as default in the word art gallery. After inserting those auto shapes we can easily change the shape and color of it.

Read More

Change Word Art Shape In MSWord 2003

When we Insert Word Art in Microsoft Word it will be inserted in a shape that is set for the chosen style. We have an option to change the shape of it to some pre-defined shapes as well. 

Read More

Change Page Border Color In Word 2003

In Microsoft Word 2003 we can easily change the border color for the page or paragraph. After applying the page border to the page or paragraph we can change the type and color of the border as well. 

Read More

Always Use Plain Text for Pasted Text

Microsoft Word will keep the formatting of text and other content you paste into a document, including links, colors, size, font, and all other formatting.  This will mess up other formatting in the document. so we have an option to get the just text filtering all the formatting.

Read More

Excel Sheet Properties

In  Microsoft Excel we can know the properties of a workbook very easily. It has become very easy in Microsoft Office 2010 version. Here we will see how to find properties of it in Excel 2003.

Read More

Display Documents Faster In Word 2007

When we open Microsoft Word documents, sometimes it will take a lot time to load if it have large images in it. Here we will look at how to display the document text quickly, then get the images to display later. 

Read More

Crop Pictures In Microsoft 2010 Programs

Sometimes when we paste pictures in Microsoft Word or Microsoft Excel we get it very big in the picture's regular shape which may look odd or we may require it to be cut to required shape.

Read More

Create A Flow Chart In MSWord

Microsoft Word enables us to make flow charts which will explain the sequential way of analyzing a software program or a procedure. Word 2007 and 2010 have improved this drastically. Just choose the option on the ribbon. 

Read More

Crop Pictures to a Default Shape

In Microsoft Word we may sometimes need to crop the pictures that we have inserted. We will have to use the crop tool in Format Picture tab. It is possible word, Excel and Power point as well.

Read More

Add Bullets To Data

When we write some data in Microsoft Word we may need it in some table format or in bullet points or in numbers. Microsoft Word has made it easy for displaying the data in bullets.

Read More

Hide Toolbars In Microsoft Excel 2003

In Microsoft Office 2003 we have toolbars and we may need to view or hide the toolbars. Unlike in 2007 and 2010 where we have this Ribbon view. So to see the Toolbars in word 2007 we may need to select them or deselect them.

Read More

Align Cells in Microsoft Excel 2003

When we are writing in Microsoft Excel 2003, the data we enter will be aligned to the right and to the left if it is Numbers and Text respectively. If we want to change the alignment we may need to change it manually. 

Read More

Error Indicating Color in MSExcel 2003

Microsoft Excel reports an error with a color on the top of the cell where it finds an error. we can change the color of it as well.  Now we will see how we can change the color of error reporting in Excel 2003. 

Read More

Change the Gridline Color In Excel 2003

In Microsoft Excel 2003 we can change the grid line color just as we do it in Excel 2007 and 2010 version. It is just a step different and is easier to change the color.

Read More

Take Screenshots with Microsoft Word 2010

In some part of the documentation we may insert pictures that will assist the readers in understanding the data we have scripted in it. And if we don't have the correct pictures we may need to take the screen shots of the application we are working on. Office 2010 has come with this feature of taking screen shots in its application.

Read More

Magnify Selected Cells In Excel 2007

Excel has a zoom feature that can increase the size of the entire spreadsheet, but sometimes we just want to zoom in on a specific set of cells that we work on, and Excel 2007 makes this task simple. in a single click. 

Read More

Farmville Tips

  

Hay Bale:

Hay Bales are decorations available on FarmVille. There are 10 colors of Square hay bale, 2 colors of Round hay bale and 3 colors of star hay bale, also available. With exclusion of the Kelly Green Hay Bale, they can all be bought from the market. We can purchase hay bales in Market under Decorations and in Landscaping Sub- Category.

These can be either purchased or we can get them in mystery boxes as mystery gifts from friends.

  
Time Saving Tip:

To Speed up Farming be it plowing, harvesting or in planting the seeds we can speed up the process just by using the bales. Lay out three hay bales in the very center of your farm and maneuver your Farmville farmer inside of this makeshift trap than once he is in place the fourth bale sealing him in. This Farmville technique can be used with a multiple of farm equipment that can form the same box shape. It is nice and simple and a huge time saver.

Farmer in the Hay Bale

“You can do it once you visit neighbor’s farm and return to your farm.”

Look for the place he/she stays in when you return your Farm. Use Move tool to remove the field plot he stands in, move bays around him so that he will be trapped in it.

To Harvest all the trees at a time:

We can use FarmHands gift to collect coins from all the animals. We receive it from our friends. We can send the Farm hand gifts for a limited period of time in Free Gifts Page.

 Farmhands are consumables can be bought from the market at a cost of 5 Farm Cash each in the "Animal" section. They can also be received randomly when collecting from a Horse Stable or found in a mystery gift or mystery egg.

 Once received, a farmer may use them to collect from every roaming animal on their farm that is ready to be collected from, with a single click. The Farmhands will not transform animals, such as Baby Turkey and Ugly Duckling. It won't collect from Beehives, Pig Pens, Chicken Coops, Dairy Farms or Horse Stables either. Farmhands may only be used once.

After using the farm Hands we get a message like this

 Arbortists:

This will help in harvesting all the trees in the farm at a time. Arborists, is a consumable on FarmVille that can be bought from the Market at a cost of 5 cash. It is available in the "Trees" section or can be received when collecting from a Horse Stable. When a farmer uses Arborists, all trees on the farm will be harvested, with one single click. Arborists can only be used once. It is possible to receive collectibles by using Arborists. Arborists also can be found in Mystery Egg and in Mystery Gifts. Arborists will also collect Tree Mastery.

Using this we can harvest all the trees that are ready to be harvested at a time. We will get a same message as we get it for Farmhands after harvesting all the trees. 

Read More

Magnify Cells In Microsoft Excel 2003

In Microsoft Excel we often come across instances where we will not be able to see the numbers or text in the cells. In such cases we may need to increase the size of the selected cells by magnifying the cells without actually increasing the size.

Read More

Edit Video In Powerpoint 2010

In Microsoft Power point 2010 we have an option to insert videos into it. After inserting them we can edit those videos to our requirement and look of the presentation. Videos make an impact easily and will be remembered well. 

Read More

Add Video from Web to Power point 2010

PowerPoint 2010 allows you to embed video from the Internet which opens a lot more creative possibilities for your presentations. Videos make the presentation more descriptive and informative and always gives a better impact than pictures or just the information.

Read More

Add Web Pages to PowerPoint Presentation

Powerpoint has been the most powerful data presentation program in Microsoft Office. We sometimes show the audience, information from the internet.  Taking a Screenshot sometimes may look outdated on the webpage we're demonstrating, we can create a webpage which is live. 

Read More

Write a Query In Microsoft Access 2003

Query is a request made in RDBMS programs to get certain amount of requested data from enormous amount of data. A query in general means a question. In Microsoft Access we shall learn how to write a new query in Microsoft Office 2003 Version.

Read More

Animating a Slide in Power point 2003

In Power point, animation makes the presentation look better. In power point 2003 we have the easiest way of Animating a slide. 

Read More

Design Templates In Power point 2003

Power point is provided with making a presentation attractive and it has become a very powerful tool in project presentation. In power point 2003 we have an option to design the templates with predefined designs and themes. 

Read More

Insert Date and Time in Power point 2003

We can insert notes, page numbers and even date and time on each slide of a presentation. Powerpoint 2003 has a way to get it done but it is very easy in its higher versions and the templates have also increased. 

Read More

Change Case in Microsoft Word 2010

In Microsoft Word 2010 the way we change the letter case to lower or higher or toggle and keep first letter of the paragraph to Upper Case. This paragraph view makes the document look good.

Read More

Entering Data In Microsoft Access 2010

Microsoft Access is one of the relational databases that is provided by Microsoft that has become very popular. It has a very easy to use interface and easy to export or import files to or from any other file types respectively.

Entering data in Microsoft Access has been very easy compared to its previous versions with its new features.

Read More

Show Gridlines in Microsoft Word 2003

Grid Lines are lines that can be inserted to see the document with margins or till the margins and borders are set to a document. They make the document look like a Graph Sheet.This is available in all the versions of Microsoft Word.

Read More

Customize Textbox

Text box is used to type text on a document, presentation or in an Excel Spreadsheet. This is very useful in putting text in any part of document page.

Read More

Advantages of A TextBox

Text box is a very important formatting tool which is very useful in putting text where ever we want on the document. It is available with all the Microsoft's formatting programs including paint. It has a very good purpose for being included in all Microsoft programs. It is there in Word, Powerpoint, Excel.

Read More

Add Textures to the Background In MSWord

Since Microsoft Word 2003 there have been many improvements to the word program by Microsoft compared to its previous versions. They added pictures to the gallery with different formats. The background textures are one of the things they have added that has impressed many users. We can add some predefined textures or textures with custom colors. 

Read More

Move An Object Forward and Backward

In Microsoft word 2003, we have an option to insert word art and we can move it according to its position on the document. If the object is hidden, select any object, and then press TAB or SHIFT+TAB until the object you want is selected.

Read More

Save the Document As a Template

Templates are pre-defined word documents that has some pre-defined text in them which can be used for different purposes. A template will simplify work , we may need to just edit the content in the template. We can save a word document as template so that it can be later on used at different places as and when required.

Read More

While Selecting Text Word 2007 Scrolls Fast

While selecting text in Microsoft Word 2007, When we drag to the edge of the document window, it scrolls through the document so quickly that it is difficult to release the mouse button exactly where we want. It is not a issue with it but it is a feature of that. Actually Word helps us in scrolling down the page but we need to control the speed.

Read More

Add a Cover Page

Cover pages are inserted by default at the beginning of a document, no matter where the cursor appears in the document. They convey a message what the document is all about. Microsoft Word 2010 offers a gallery of convenient pre-designed cover pages. Choose a cover page and replace the sample text with your own to make it look the way you wanted.

Read More

Delete a Page in Microsoft Word 2010

As we type data and delete it in the middle of a document or in some part of it we may need to delete the page which will be empty by deleting the data. So we may need to either move the data up, which will change all the set page alignments, borders or we can just delete the page simply which could be easiest in all versions of Microsoft Word.

Read More

Insert A New Page In Microsoft Word 2010

In Microsoft Office Word, we can add pages to the documents or delete them as and when needed. The more pages the document contains the more informative it becomes or more information can be added to it. Since Microsoft Word 2007 version we have the ribbon view we have the insert page option from that ribbon.

Read More

Redo the Last Undone Action

In Microsoft Office we have an option to redo the last undone action. It is as easy as pressing an arrow turning to the right. Redo will do the last action that is undone.

Read More

Undo An Action In Microsoft Word

While working on Microsoft Office programs we may do a small mistake that we need to undo the last thing done. At that times we will need this option Undo that will undo the last action done on the Microsoft Word Document. But there are some things like commands on menus that cannot be undone. 

Read More

Start Microsoft Office at System StartUp

When we start the computer or turn on the computer we will have some programs to that will load automatically depending on the necessity we had set up for ourselves. For Example we may need to mark our attendance daily by going to a site. So as soon as the computer is turned on we will set up in such a way that Mozilla Firefox opens up the site to enter our attendance.

Read More

Load a PowerPoint Add-in

Add-ins are supplemental programs that will make the main program work fast by enhancing the features of  it. They will enhance the performance of the program by enabling the add-ins to do the customized editing using power point.

Read More

Add a PowerPoint add-in

Add-ins is supplemental programs that add custom commands or custom features to Microsoft PowerPoint 2010.  Add-ins are available for PowerPoint on Office.com or on third-party vendor Web sites. Developers can write their own custom add-in programs by using Visual Basic for Applications (VBA). Addins help in customizing the feature of Powerpoint and also making it more effective tool to get the things done.

Read More

Fill Selected Cells With Same Data

In Microsoft Excel 2010 we have an option to fill the same data easily by using a single option or command. Sometimes we may need to fill the same data, say for example- an employee working in a company will come to office daily in a same shift timing. So the same time can be filled in all the days of the week instead of typing the data. 

Read More

Share MS Access Data With MS Excel

Sometimes we may need data from other applications which will be in different format and we may have to copy, edit and remake the data. In those instances sharing the entire file might help in reducing the time of copying and editing it. We can share Access data with other applications easily in Office 2010. We will see how can we share it with Excel 2010.

Read More

Export Data to Different Databases

Access is a database tool from Microsoft that is very well compatible with all other databases and has become a important tool in Microsoft Office Suite. Microsoft Access 2010 comes with professional, professional plus, Academic and Enterprise Office Suites. There are a lot of other applications Access 2010 will let you export data, like text files, Word, a SharePoint List and more.

Read More

Delete Cells In Microsoft Excel

In Microsoft Excel we can delete data in cells or the entire cells and can bring the data into the place of cell that has been deleted. This will avoid the work of copying or moving the entire data into another cell. 

Read More

Apply Borders To Cells

In Microsoft excel we can apply or insert borders to single cell, or a group of cells or to entire worksheet. This can be done when we want to highlight an individual thing or a group of cells etc.

Read More

Insert Auto Shape In Microsoft Word

When we are writing a story we may have to insert some designs beside some characters or beside some words we may need to insert a shape which tells the readers about the word and meaning or it. In that moment we may need to create a shape into the word document. Microsoft Word document has many different shapes and they have increased in 2010 version.

Read More

Change Data Format In Microsoft Excel

In Microsoft Excel we have the default format as number. But in order to get any other format like time or data format we need to change it. Microsoft Excel has many formats which help us in assisting the data manipulation or processing easier. 

Read More

Import and Export a Customization file

We have tabs on Ribbons for making the things easier on any Office program. We can create a customized tab as well to get all the frequently using commands on a single tab. But tab created in a program can be used only on that program, for example a tab created in Word cannot be used in Excel. We can import a customized file into another system or to a co-worker.

Read More

Customized Tab on the Office 2010 Ribbon

Ribbon view in Microsoft Office Since 2007 makes it easy for us to pick options and use them in writing documents. But Sometimes it becomes a very confusing job when we need to use two or three different ribbons from different tabs. For this reason Microsoft Office has given us an option to customize ribbons. In Microsoft Office 2007 and 2010 versions we can choose commands to be placed in a customized ribbon.

Read More