Skip to main content

Posts

Showing posts from July, 2021

Microsoft Access MS Access Basics Tips and Trick-7

Adding Data An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View. A datasheet is a simple way to look at your data in rows and columns without any special formatting. Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry. A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields. You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or whe

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-22

Get Context Help in Powerpoint 2010 Despite getting a good grasp of the program, we may need help on different aspects from time to time. To aid in such scenarios, PowerPoint has created the context help feature. With this feature, if you get stuck in any dialog, you can press  F1  and PowerPoint will open the help topic related to that dialog. This is extremely beneficial as you need not spend time trying to browse through all the help topics just to get to the one you need. The context help is based on the active window and not on the object you have selected. So if you select an image and press F1, you will get the generic help windows as your active window is still the main PowerPoint program. If you selected any other dialog or window, PowerPoint context help will show the related help topic when you press F1. In other words, if you continue work solely from the ribbon options, the context help would not work, but if you right click on the shapes or objects and open related editin

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-21

Running Slide Show in Powerpoint 2010 Most PowerPoint presentations are created to be run as a slideshow. Given all the advanced features available in PowerPoint 2010, it is no surprise that there are many features related to running the slide show that have been included in this program too. Most of these features are really to help you create a good slide show without having to go through the entire presentation over and over again after every minor change. Features related to running the slide show are grouped under the  Slide Show  ribbon. Section Menu Item Description Start Slide Show From Beginning Starts slide show from beginning From Current Slide Starts slide show from the current slide Broadcast Slide Show Allows users to broadcast the slide shows using Microsoft's PowerPoint Broadcast Service Custom Slide Show Build a custom slide show by picking the slides you want to run Set Up Set Up Slide Show Setup the slide show including browser/ full screen display, show options

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-20

Adding Slide Numbers in Powerpoint 2010 Just like you have page numbers for books, it is usually a good idea to add slide numbers to presentations. There are two ways you can add slide numbers to your presentation and this chapter will show you both those techniques Step (1):  Under the  Insert  ribbon,  Text  group click on  Slide Number  command. Step (2):  The  Header and Footer  dialog opens up. Step (3):  Check the  Slide number  check box Step (4):  The Preview shows the section where the slide number will be placed. Instead of clicking on the  Slide Number  command you could have also clicked on  Header & Footer  menu item to launch the same dialog as Step (2). The beginner to advance and start up step-20 Thank you all very much

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-19

Adding Header & Footer in Powerpoint 2010 PowerPoint offers the ability to add header and footers to the slides. While having footers in presentations would be logical, header may not be quite evident at first. Typically, the slide title would be the header in the main slide, however when it comes to printing out handouts a separate header would be quite useful. Here are the steps to add header and footer information to slides Step (1):  In the  Insert  ribbon, click on  Header & Footer  menu item. Step (2):  The  Header and Footer  dialog has two tabs:  Slide  and  Notes and Handouts Step (3):  You can add details to the slide footer from the  Slide  tab. Slide Footer Options Description Date and time Add date and time to the footer Specify the format of the date and time entered Setup the footer to update automatically or use a fixed number Slide Number Insert Slide number in the footer Footer Add designated text to the footer - a good example of this would be confidentiality

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-18

Review Presentation in Powerpoint 2010 Reviewing the presentation can be a very powerful way of eliminating the errors and perfecting the slides. PowerPoint offers a wide range of reviewing options for you to use. Some of them are automatic or system driven while others aid other users to collaborate and review the slides. All the reviewing tools are grouped under the  Review  ribbon. Review Section Functions Proofing Spellchecking:  Identify spelling and grammar based on selected language preference Research:  Reference language related research tools based on specific reference books and research sites Thesaurus:  Provides synonyms for selected text Language Translate:  Provides translation services for selected words for multilingual support Language:  Set the default language for the presentation - this would be used as default language for proofing Comments Show Marking:  Show/hide the user comments in the slide New Comment:  Add new comment against the selected content Edit Comme

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-17

Saving Presentation in Powerpoint 2010 One of the most basic tasks in PowerPoint is being able to save your work; this is probably the most important task as well. There are many users who have burnt their fingers for not saving their work in time and losing hours of hard work. Here are the basic steps to save a presentation. Step (1):  Click on the  File  tab to launch the  Backstage  view and select  Save . Step (2):  In the  Save As  dialog, type in the file name and click "Save" Step (3):  Default file format is .pptx, if you want to save the file with a different name choose one of the file types from "Save as type" dropdown list. If you are working on an already saved file, the "Save" option in the  Backstage  view will directly save the file in the existing format with the existing name. If you want to change the format or filename of an existing file, use the  Save As  option instead. The beginner to advance and start up step-17 Thank you all very

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-16

Slide Orientations in Powerpoint 2010 In the recent years, presentations are being used for more than just as a high end replacement for transparencies and projectors. With its unique features PowerPoint is becoming quite versatile in the kind of information it can depict and very flexible in its usage. The slide orientations are invaluable part of this improved list of PowerPoint features. Like most other applications PowerPoint supports two orientations:  landscape  and  portrait . The  Landscape  layout is default PowerPoint layout and it is probably the more commonly used one. In the landscape layout, the longer edge is horizontal so the slides align better with the screens and projectors. The  Portrait  layout is where the shorter edge is horizontal. This is sometimes better for printouts depending on the kind of content you want to present. Slide orientations in PowerPoint can be changed from the  Design  ribbon using the  Slide Orientation  command. The beginner to advance and s

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-15

Setting Backgrounds in Powerpoint 2010 As PowerPoint is a design based program, backgrounds are effective ways of improving the aesthetics and readability of the slides. The  Themes  in PowerPoint help select the backgrounds by default, so every time you change the theme, the default background is set automatically. Theme, however, includes more than just backgrounds - so you can retain other aspects of the theme while changing the default background. Given below are the steps to apply backgrounds in PowerPoint. Step (1):  In the  Design  ribbon, under the  Background  group click on the  Background Styles  command. Step (2):  Select one of the background styles that suits your requirements Step (3):  To edit the background for a specific slide, right click on the desired background slide and select " Apply to Selected Slides " Step (4):  Selected slide(s) now have the new background. The graphics in the slide background can distract you from the actual content, in such cases

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-14

Presentation Views in Powerpoint 2010 PowerPoint supports multiple views to allow users to maximise benefits the features available in the program. Each view supports a different set functions and is designed accordingly. PowerPoint views can be accessed from two locations. Views can be access quickly from the bottom bar just to the left of the zoom setting Views can also be access from the Presentation Views section in the View ribbon Here is a short description of the various views and their features. Normal View This is the default view in PowerPoint and this is primarily used to create and edit slides. You can create/ delete/ edit/ rearrange slides, add/ remove/ modify content and manipulate sections from this view. Slide Sorter View This view is primarily used to sort slides and rearrange them. This view is also ideal to add or remove sections as it presents the slides in a more compact manner making it easier to rearrange them. Reading View This view is new to PowerPoint 2010 and

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-13

Working With Outlines in Powerpoint 2010 PowerPoint is a great program that allows you to bring together text, images, shapes and multimedia. However, sometimes you may just want to review the text without focusing on the non-text aspects of the slide deck. This is where the  Outline  view in PowerPoint is quite useful. The Outline view can be accessed from the tab adjacent to  Slide  tab in the  Normal  view. The outline view shows just the text content from various slides. This view does not show the text entered in non-text box like SmartArt, Word Art or any other shapes. By default the outline pane size is same as the slide tab pane hence it is small. However, you can drag the pane out to increase the size to improve the readability. The beginner to advance and start up step-13 Thank you all very much