Skip to main content

Posts

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 Access MS Access Basics Tips and Trick-1

MS Access Basics in Powerpoint 2010 Overview Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and softwaredevelopment tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions. Microsoft Access is just one part of Microsoft’s overall data management product strategy. It stores data in its own format based on the Access Jet Database Engine. Like relational databases, Microsoft Access also allows you to link related information easily. For example, customer and order data. However, Access 2013 also complements other database products because it has several powerful connectivity features. It can also import or link directly to data stored in other applications and databases. As its name implies, Access can work directly with data from other sources, including many popular PC database programs, with many SQL (Structured...
Post a Comment
Read more

Microsoft PowerPoint SHARING PRESENTATION Tips and Trick-8

Email Slide Show in Powerpoint 2010 PowerPoint allows users to share the presentation as an email attachment too. Although you can attach the presentation from outside the program, the ability to send the emails directly from PowerPoint is quite convenient; this is because you need not leave the PowerPoint program to send the email. Given below are the steps to send an email from PowerPoint. Step (1):  Go to the  Backstage  view under the  File  tab Step (2):  Click on  Save & Send , select  Send Using E-mail  option and click on  Send as Attachment  button Step (3):  This launches the Outlook send email window with the presentation added as attachment. You can add the emails of recipients and send the email. Step (4):  Instead of " Send as Attachment " you select " Send as PDF " you will get a pdf attachment instead of a .pptx attachment.
Post a Comment
Read more

Microsoft PowerPoint SHARING PRESENTATION Tips and Trick-7

Setting Document Password in Powerpoint 2010 Sometimes it is important to protect the presentation and ensure unauthorised audience does not get to view the slides. PowerPoint offers users the ability to protect the presentations. Given below are the steps to password protect the presentation Step (1):  Go to the  Backstage  view under the  File  tab Step (2):  On the  Info  section, click on the  Permissions  drop down Step (3):  Select " Encrypt with Password " to enable password protection Step (4):  Enter the password in the  Encrypt Document  dialog Step (5):  Re-enter the password in the  Confirm Password  dialog Step (6):  Presentation is now password protected. Step (7):  Readers would have to enter the password in the  Password  dialog to open the file. Step (8):  To unprotect the file, follow the steps up to Step (3) and delete the password in the  Encrypt Documen...
Post a Comment
Read more

Microsoft PowerPoint SHARING PRESENTATION Tips and Trick-6

Broadcast Slide Show in Powerpoint 2010 PowerPoint 2010 offers users to broadcast their presentations on the internet to worldwide audience. Microsoft offers the free broadcast Slide Show service; all you need to do is share the link with your audience and they can watch the presentation from anywhere. There is no special setup or charges required to do this; all you need is a Windows Live account. Given below are the steps to broadcast your presentation. Step (1):  Go to the  Backstage  view under the  File  tab Step (2):  Click on  Save & Send , select  Broadcast Slide Show  option and click on  Broadcast Slide Show  button Step (3):  In the  Broadcast Slide Show  dialog, click on  Start Broadcast . Step (4):  Log on to your Windows Live account in the login dialog Step (5):  Once the login is successful, PowerPoint will prepare the presentation for broadcast Step (6):  PowerPoint will provid...
Post a Comment
Read more

Microsoft PowerPoint SHARING PRESENTATION Tips and Trick-5

Printing Presentation in Powerpoint 2010 It is sometimes necessary that you share your slides with your audience in printed format before you begin presenting them so they can take notes. There are other times when you want to give your audience handouts with additional notes. To do this PowerPoint supports various kinds of printing options. To print slides you must go to the  Backstage  view under  File  tab and click on  Print  menu. The table below describes various printing options available in PowerPoint. Main Settings Options Description Printing Slides Print All Slides Print all the slides in the presentation Print Selection Print just the selected objects Print Current Slide Print just the selected slide Custom Range Define the slides you want printed Slides This is same as Custom Range Print Layout Full Page Slides One slide per page Notes Page Slide and notes for every slide printed one below another - one slide per page Outline Print Slide outlin...
Post a Comment
Read more