Skip to main content

Posts

Showing posts with the label MS OFFICE

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...
Post a Comment
Read more

Microsoft Access MS Access Basics Tips and Trick-4

Create Database In this chapter, we will be covering the basic process of starting Access and creating a database. This chapter will also explain how to create a desktop database by using a template and how to build a database from scratch. To create a database from a template, we first need to open MS Access and you will see the following screen in which different Access database templates are displayed. To view the all the possible databases, you can scroll down or you can also use the search box. Let us enter project in the search box and press Enter. You will see the database templates related to project management. Select the first template. You will see more information related to this template. After selecting a template related to your requirements, enter a name in the  File name  field and you can also specify another location for your file if you want. Now, press the Create option. Access will download that database template and open a new blank database as shown in ...
Post a Comment
Read more

Microsoft Access MS Access Basics Tips and Trick-3

Objects MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports. When you create a database, Access offers you Tables, Queries, Forms, Reports, Macros, and Modules. Databases in Access are composed of many objects but the following are the major objects:- Tables Queries Forms Reports Together, these objects allow you to enter, store, analyze, and compile your data. Here is a summary of the major objects in an Access database; Table Table is an object that is used to define and store data. When you create a new table, Access asks you to define fields which is also known as column headings. Each field must have a unique name, and data type. Tables contain fields or columns that store different kinds of data, such as a name or an address, and records or rows that collect all the information about a particular instance of the subject, such as all the information about a customer or employee etc. You can define a primary ke...
Post a Comment
Read more

Microsoft Access MS Access Basics Tips and Trick-2

RDBMS Microsoft Access has the look and feel of other Microsoft Office products as far as its layout and navigational aspects are concerned, but MS Access is a database and, more specifically, a relational database. Before MS Access 2007, the file extension was  *.mdb , but in MS Access 2007 the extension has been changed to  *.accdb  extension. Early versions of Access cannot read accdb extensions but MS Access 2007 and later versions can read and change earlier versions of Access. An Access desktop database (.accdb or .mdb) is a fully functional RDBMS. It provides all the data definition, data manipulation, and data control features that you need to manage large volumes of data. You can use an Access desktop database (.accdb or .mdb) either as a standalone RDBMS on a single workstation or in a shared client/server mode across a network. A desktop database can also act as the data source for data displayed on webpages on your company intranet. When you build an applicati...
Post a Comment
Read more

Microsoft PowerPoint SHARING PRESENTATION Tips and Trick-1

Create a Video File in Powerpoint 2010 PowerPoint allows presentations to be saved as video files that can be posted on video sharing platform like YouTube or just played on any other media. Given below are the steps to save a presentation as a video file. Step (1):  Go to the  Backstage  view under the  File  tab Step (2):  Click on  Save As  to open the Save As dialog Step (3):  Select the file type as .wmv from the list of supported file types Step (4):  Add a proper name to the file and click Save Step (5):  The video creation is not an instant process like other file types as PowerPoint needs to create the video file. You can track the progress of video creation at the bottom of your presentation window. Step (6):  Once the creation is complete the video file is created in the specified location. The beginner to advance and start up step-1 Thank you all very much
Post a Comment
Read more

Microsoft PowerPoint WORKING WITH MULTIMEDIA Tips and Trick-15

Add & Preview Animations Powerpoint 2010 PowerPoint offers animation support which can be used effectively add some motion in a monotonous presentation and make it more interesting. Animation can be applied to any object on the slide and the motions can the automated, timed or trigger. Given below are the steps to add and preview animations in the slide. Step (1):  Go to the  Animation  ribbon and click on  Animation Pane  to display the animation sidebar Step (2):  Select one of the objects in the slide and click on  Add Animation  menu option Step (3):  Choose from one of the Animation options. Entrance  will cause the object to appear in the screen Emphasis  will cause the object to emphasis without appearing or leaving the screen Exit  will cause the object to disappear from the screen Step (4):  Once you add the animation for an object, it would show up in the  Animation pane Step (5):  By default, all t...
Post a Comment
Read more

Microsoft PowerPoint WORKING WITH MULTIMEDIA Tips and Trick-12

Add & Format SmartArt in Powerpoint 2010 PowerPoint offers a unique feature called Smart Art which allows users to add text to predefined art designs. The advantage with Smart Art, although each component of the Smart Art can be edited individually, you can also modify the SmartArt as a whole while retaining the settings on each individual component. Given below are the steps to add a SmartArt to PowerPoint. Step (1):  Go to  Illustrations  group under  Insert  ibbon Step (2):  Click on the  Smart Art  command to open  Choose a SmartArt Graphic  dialog. You can choose the SmartArt category and pick individual SmartArt types from the list. You also get a preview and a short description of the graphic in the preview section Step (3):  Select the SmartArt type and click  OK  or double click on the SmartArt type to insert the graphic in the slide Step (4):  The graphic is inserted in the slide along with a text pane w...
Post a Comment
Read more

Microsoft PowerPoint WORKING WITH MULTIMEDIA Tips and Trick-11

Adding Audio & Video in Powerpoint 2010 PowerPoint supports multimedia in the slides. You can add audio or video clips to the slides which can be played during the presentation. Given below are the steps to adding audio or video file to the slides. Step (1):  Go to the  Media  group under the  Insert  ribbon Step (2):  To insert video file select  Video  as media type and  Video from File  to insert a video from your computer or hard drive Step (3):  In the  Insert Video  dialog, browse for a video file and click Insert Step (4):  Video file is added to the slide Step (5):  To insert audio file select  Audio  as media type and  Audio from File  to insert an Audio from your computer or hard drive Step (6):  In the  Insert Audio  dialog, browse for an audio file and click  Insert Step (7):  Audio file is added to the slide The beginner to advance and start up step-11...
1 comment
Read more

Microsoft PowerPoint FORMATTING PRESENTATION Tips and Tricks-12

Using Slide Master in Powerpoint 2010 Slide master is simple way of applying changes to the entire slide. Every presentation has at least one slide master, but you can have more than one. Using features like copy/ paste and format painting you can make changes to different sections within the presentation to make them look similar, however, if you want to use a theme and background throughout the slide, using the slide master is a simpler and more graceful way of approaching it. Given below are the steps to customise your slide master. Step (1):  Go to  Master Views  group under the  View  ribbon. Step (2):  Click on  Slide Master  to open the  Slide Master  Ribbon. The top most slide in the left sidebar is the  Master  slide. All the slides within this master template would follow the settings you add on this master slide. Step (3):  You can make changes to the master slide in terms of the theme, design, font properties, ...
Post a Comment
Read more

Microsoft PowerPoint FORMATTING PRESENTATION Tips and Tricks-10

Set Line Spacing in Powerpoint 2010 While dealing with a lot of textual content, especially during projected presentations, it is a good idea the space the lines further apart to improve the readability of the overall content. PowerPoint offers line spacing options to help you change the spacing between lines in the text. Like the indentation, these settings apply at a paragraph level. Given below are the steps to set the line spacing in PowerPoint. Step (1):  Select the text content to be spaced. You can either select the entire paragraph or just place the cursor within the paragraph. Step (2):  Go to the Paragraph group under the Home ribbon. Step (3):  Select one of the line spacing from the drop down list to apply one of pre-defined spacing options. Step (4):  To customise the spacing, you can click on " Line Spacing Options… " This will launch  Paragraph  dialog. Step (5):  The spacing section in the  Paragraph  dialog has two settings. ...
Post a Comment
Read more

Microsoft PowerPoint FORMATTING PRESENTATION Tips and Tricks-9

Borders and Shades in Powerpoint 2010 One can change the borders and shading for most of the content in PowerPoint 2010. Given below are the steps to apply these changes in your presentation. Applying Borders Step (1):  Select the object (text box, image, chart, picture, etc.) to which you want to apply the border. Step (2):  Go to the  Drawing  group under the  Home  ribbon. Step (3):  Click on the  Shape Outline  to choose the border settings. Step (4):  Use the color palette to choose the border color. You can choose  More Outline Colors  to get access to additional color choices Step (5):  Use the  Weight  drop down to define the thickness of the border. Step (6):  Use the  Dashes  option to define the border style. Applying Shades Step (1):  Select the object (text box, shape, chart, etc.) to which you want to apply the shades. Step (2):  Go to the  Drawing  group under the...
Post a Comment
Read more