Labels

Tuesday, 28 January 2020

Easy to use Free URL Shortening Service


LeLink URL Shortener is leading shorten URL software used throughout many social networks. It permits basic Short URL creation in addition to random hyperlinks with out an account.

 Link of FREE URL SHORTENER


Thursday, 11 May 2017

What is PPC - Pay Per Click

PAY PER CLICK

Pay per Click also written as PPC. It is an internet marketing model where the advertisers use the publisher’s website to market their products or services through ads. The publisher gets paid by the particular advertisers when a user clicks on their ads. It is a pull-type internet marketing of buying user visits to a site.

Large no of people using internet. Internet is providing large option. It is also provide platform for advertising products and services online.

Advertisers around the world have shown a keen interest in making good use of the Internet that is omnipresent these days to market various products and speed up their business activities by reaching out to numerous users.

What is Visual Aids

VISUAL AIDS

Visual Aids are any pictures, objects, art facts, flipcharts, transparencies or projections that you might show to your audience during the course of your talk. It is advised to consider using some kind of visual aid as part of your presentation if it is going to take more than 5 minutes. While it is thought that effective speaking does not require visual aids, a few well-placed they can add a significant amount of clarity and impact. More importantly they can also help your audience stay focussed and have great retention of information. But thinking that flashy visuals can save an otherwise poorly structured and delivered speech. You have to start with a well-developed speech before visual aids can have any major effect.

What is Digital Signature

DIGITAL SIGNATURE

Digital signatures allow us to verify the author, date and time of signatures, authenticate the message contents. It is a process that guarantees that the contents of a message have not been altered in transit.

Digital signatures help to authenticate the sources of messages. For example, if a bank’s branch office sends a message to central office, requesting for change in balance of an account. If the central office could not authenticate that message is sent from an authorized source, acting of such request could be a grave mistake.

Search Engine Details and Components

SEARCH ENGINE

Search Engine refers to a huge database of internet resources such as web pages, newsgroups, programs, images etc. It helps to locate information on World Wide Web.

User can search for any information by passing query in form of keywords or phrase. It then searches for relevant information in its database and return to the user.

Details and Features of C LANGUAGE

C LANGUAGE

The C programming language is a structure oriented programming language, general-purpose, imperative computer programming language, lexical variable scope and recursion, while a static type system prevents many unintended operations.

C was originally developed by Dennis Ritchie between 1969 and 1973 at Bell Laboratory, and used to re-implement the Unix operating system. It has since become one of the most widely used programming languages of all time, with C compilers from various vendors available for the majority of existing computer architectures and operating systems. C has been standardized by the American National Standards Institute (ANSI) since 1989 (see ANSI C) and subsequently by the International Organization for Standardization (ISO).

What is Java

Java

Today Java is a commonly used foundation for developing and delivering content on the Web. According to Oracle, there are more than 9 million Java developers worldwide and more than 3 billion mobile phones run Java. Java initially name oak was developed by the team headed by James Gosling at Sun Microsystems, USA in 1991.

The first and foremost reason behind the development of Java was the need for a platform – independent and portable software to be embedded in the consumers electronic devices like remote controls, microwave ovens etc.

What is Data Mining

DATA MINING


Data mining refer to computer-assisted tools and techniques for shifting through and analysing these vast data stores in order to find trends, patterns and correlations that can guide decision making and increase understanding. It is also known as knowledge discovery. It covers a variety of uses from analysing customer purchases to discovering galaxies.

How To Protect Your Computer From Cyber Crimes

TIPS TO PROTECT COMPUTER FROM CYBER-CRIMES

Cyber-crimes refer to illegal activities that committed through the use of a computer and the Internet.

There are various forms of cyber-crime like Spamming i.e. unwanted product advertisements, illegal reproduction and distribution of software applications, games, movies and audio CDs, Hacking, Phishing, Spoofing etc.

ANTIVIRUS SOFTWARE

ANTIVIRUS SOFTWARE

ANTIVIRUS SOFTWARE refers to applications designed to detect and remove viruses from computer systems. Antivirus software is a computer program that is used to protect our computer system against unwanted virus attacks. It scans computer memory and mass storage to identify, isolate and eliminate viruses.

HOW TO PREVENT YOUR COMPUTER FROM VIRUS?

HOW TO PREVENT YOUR COMPUTER FROM VIRUS?

Do not open any e-mail attachment that you think may have a computer virus. Your antivirus software may not be able to clean the virus received.

Avoid booting the computer with a floppy. If it is required to boot from a Floppy, use a floppy that is virus free and write protected.

TYPES OF VIRUS

TYPES OF VIRUS

There are thousands of viruses and several are discovered everyday. They have variations in the way they infect or the way they spread.

Some common categories of the viruses are:

Boot Sector Viruses
Boot sector viruses affect the hard disk.

VIRUS

VIRUS

Virus stands for VITAL INFORMATION RESOURCES UNDER SIEZE. A computer virus is an intrusive program. The virus affects computer files and folders Computer virus is a program or piece of code that is loaded onto your computer without your knowledge and runs against your wishes. It modifies other computer program by inserting a copy of itself inside them. When the program is loaded, the copies of the virus are executed to infect still other files.

What is Database Management System

Database Management System

A database is an organized as structured set of related data. It helps you to organize related information in a logical manner for easy access and retrieval. Even in your daily life, you maintain a database like, your personal address dairy in which you records addresses and telephone numbers of your friends and relatives. A school maintains the records of its students, staff, fees, salary, etc.

DATABASE COMPONENTS IN MS ACCESS

DATABASE COMPONENT MS ACCESS

There are seven database components in Microsoft access.

Tables

Tables are the fundamental data building blocks. All the data is stored in tables. A table stores data in a row and column format. Every table deals with one subject at a time.

Creating a Query in MS Access

Creating a query in MS Access

Queries are extracts which are created and saved for future use. You can create a query by taking the steps as follows:

1. Click on Query Wizard option in other group on Create TAB. New Query window will come on the screen.

AUTOSUM, SORTING, FILTERING AND FORMATTING IN MS ACCESS

AUTOSUM FEATURE IN MS ACESS

Autosum feature is used for quickly summing the data values stored in a row or column. This feature can be used by clicking Auto sum button presented in the formula tab.

The steps to use Autosum features are:

Step 1: click the formula tab.

2: select Autosum button.

Step 3: press the enter key after selecting the correct range to get the sum of values in the result cell.



SORTING DATA

In the spread sheet, it is easy to maintain data as the sheet is divided into rows and columns. Data when entered in the sheet may not be arranged in an order. However, you can arrange it either in describing or ascending order is called sorting.

To sort the data on the basis of alphabetical order, follow the steps:

Step 1: creates the worksheet and select the cells.

For example: A2:F8.

Step 2: click ont the data.

Step 3: on the sort and filter group, click sort A to Z to sort in ascending or sort Z to A to sort in descending order.

FILTERING DATA

Filtering shows the data you wish to see while temporarily hiding the rest. By defining different filters, you can compare data in multiple ways. Thus, filter can be defined as a facility in Excel that allows a user to filter items in a list according to set criteria.

To filter the data, follow the steps given below:

Step 1: click a cell in the range you want to filter.

Step 2: click on data tab.

3: On the sort and filter group, select filter option.

Step 4: click on the arrow on the column heading, for example Roll No.

Step 5: A list opens with all the values selected by default. Choose the value you want, for example 10, and click on Ok button.


CONDITIONAL FORMATTING

Conditional formatting refers to the features which apply formatting to cells that meets certain conditions.

To apply conditional formatting follows the steps given below:

Step 1: select the cells within the range. For example D1: D8.

Step 2: click on the home tab and select conditional formatting from styles group.

Step 3: select the required option from the drop down list to specify condition. For example, highlight cells rules – text that contain. A dialog box appears.

Step 4: Type the name. For example, Delhi.

Step 5: click OK button.

How To Add Fields To Tables in MS Access

ADDING FIELDS TO TABLES

After creating a database, if you want to add some more fields in the database table, you can adding fields by the following steps:

1. Click on HOME tab.



2. Click on View group.

3. Select Design View by clicking on it

4. Now, add the new field in the last. If you want to add the new field between previous fields then place the mouse pointer there and right click. Then, click on Insert Rows option.



5. Close the table from design view and open the table again in datasheet view.

Now, new fields which you have added will be shown on the screen.

How To Create a Blank Database in MS Access

CREATING BLANK DATABASE IN MS ACCESS

You can create a blank database by the following method:

Step1: open Microsoft office access. Microsoft access window will appear.

Step2: click on blank database option under new blank database.

Step 3: click on browse folder at the right side of the pane.

File new database window will appear.


Step 4: select drive, where you want to create your new database.

5: click on new folder option on the command bar.

6: To open the folder, double click on it.

Step 7: Enter the file name in file name option and click on OK.



Step 8: now, click on create button on the getting started with Microsoft office access page. As a result, anew dialog box will appear.

The window for the database will appear on the screen.


CREATING A TABLE IN MS ACCESS

When you create a database, you store your data in tables. You can create a contacts table to store a list of names, addresses, and telephone numbers, or a products table to store information about products.

To create a table, follow these steps:

1. Click on datasheet tab.



2. On the ribbon click on view group. A menu will appear, click on design view. In the design view, you can name your feeds, assign data type for each field, and format your fields.

3. A save as window will appear. Enter the name in the table name box and click on OK.Table1 will be created.



4. Place the cursor in the second box beneath fieldname.



5. Type first name and press enter key on the keyboard.



6. Like above, click in the next box beneath first name and type last name and press enter key on the keyboard.

7. You can also type other information, e.g. city, address, phone number, etc.

HOW TO DESIGN A REPORT IN MICROSOFT EXCEL

DESIGNING A REPORT

A report is the final output taken on the basis of the existing database in the database management system or relational database management system. Reports play very important role. Queries are used to generate the reports which work on a database available in the tables.

You can design a report by taking the following steps:

1. Click on create tab.

2. Then click on report wizard in reports groups.

Designing a Report in ms excel

3. Select a table/query on which you want to base your report. Then select the fields to display and click on Next button.


4. The report wizard will appear on the screen. In this wizard, select the fields which you want to put in the report.


5. Click on next button. Now, another wizard will come on the screen.



6. The screen appears what sort order do you want for your records? Set the order of records for sorting and click on next button.

7. The screen will appear with a message, how would you like to lay out your report? Select layout and orientation for printing and then click on next button. In portrait orientation, the width of page is less than height but in landscape, the width is greater than height. clip_image012

8. Respond to the table, what style would you like? By selecting the style for printing as a flow, foundry, median, metro, module, etc. and then click on next button.

9. Enter a title for your report in the given box and select the option preview the report and then click on finish button.