IT Tips And Tricks

Hi I am Safeer! I am student. Safeermughal779@gmail.com This is my email.you can connect with me with this email. V LOOKUP:               V LOOKUP in excel is useful for looking for specific information in your worksheet. The value you want to lookup also called the lookup value . The range where the lookup value is located. Remember that lookup value Should always be in first column in the range for  v lookup to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.  USE  OF  V LOOKUP  FORMULA:               Use lookup when lookup values are located in the first column of a table with information organized vertically. Use H LOOKUP when lookup values are located in the first row of the table, and each "record" appears in the new column. Range-lookup controls weather values need to match exactly or not. How to u...

HI I am safeer. Safeermughal779@gmail.com This is my email. you can communicate with this email. The database Wizard guides you through process of the creation a database; it includes choosing a database template, selecting fields, making customization, adding pictures, and the database. When Microsoft Access first stars up, a dialog box is appeared with option to create a new database or to open an existing one. when this dialog box appears, select Access Database Wizards, Pages, and projects and then click OK. Microsoft Access starts up, when you click the New Database on the toolbar. On the Database tab, double-click the icon for the kind of database you want to create. Specify a name and location for the database. Click Create to start defining the new database.    DATABASE  OBJECTS                                     (1)     Tables    ...

 A   Data Base is a collection logically related data sets or file . No r maly, these files /data sets are of different nature, used for specific purposes. these may be organized in various ways to meet processing and retrieval requirements of the organizations or users.                                      A  Data base system is just a computerized record keeping system. A data base itself can be regarded as a kind of electronic file cabinet, a warehouse or a repository for a collection of computerized data files. the user of he database normally has he following facilities to enjoy. Adding new , blank file to the database. Inserting new data into the existing files. Retrieving data from existing files. Updating data in existing files. Deleting data from existing files. Removing existing files, empty or otherwise from the database. A database syste...