Monthly Archives: May 2013

How to Create A Microsoft Excel Database


The term Microsoft Excel Database has never really sat very well with me since my primary role in the IT world has been in developing database and what is used by the spreadsheeting fraternity is what I consider an over glorified list. However, for the sake of peace, I want to outline some of the principles you must follow in building what is known as the Microsoft Excel Database.

Let us review …

A database in essence is what is considered a collection of information that is related in some manner. For example if you were running a company and selling a product you may have a database that simply lists all of the sales you have made over a period of time. Storing this data in a database would make sense as the company information and the selling of a product is related and as such would be appropriate for the database.

There are many different types of databases available such as Microsoft Access Databases, Oracle Databases, MySQL databases and so on but Microsoft Excel also has a form of a database known as a database list. The form of the list is virtually the same as the other databases as the data is under column headings in rows, but after that common point, the Excel database goes in its own direction. See, to look for specific data within a Microsoft Excel Database or Excel List we do not use the common database language of SQL, we actually use specially written functions. These functions are custom written by you and are known as criteria.

So how do we create an excel database…

Well first off, there is one rule we must always follow and that is one excel database per worksheet. Anymore and you just get yourself into lots of trouble. In fact if you need to have multiple excel databases within your workbook simply put each excel database onto a separate worksheet.

The next thing you must follow is that your database lists first row must contain the heading of the list. That is the first row contains your field names. Plus each of the field names must be 100% unique. You cannot have two field names with the same name or again you will have a list that will not work.

The next issue you need to be concerned with is identifying the field names. Excel databases have a simple rule, the field names or column names must be unique. Now the way you identify them is easy, all you have to do is to ensure the field names are many different data types, format, pattern etc to the rest of the database in your list. Generally what I do is to format my field names in bold to satisfy this requirement.

One of the most important rules you must remember when you create an excel database is that around the row and columns of the fields and data there must be a blank row and column. What this means is that you can still have a heading at the top of the fields, but there must be a blank row between the heading and the fields as well as along the last column as well. The blank row rule also applies to the bottom of the list as well.

When you are entering data into your list, every cell in every record must contain some value even if it is simply blank (a blank value is still considered a value) and each record must contain the same number of fields. If there is no specific data for a field you simply leave it blank and move to the next field.

Ensure that when you are entering data into a field that you don’t have spaces before the text or at the end of the text in the field. If you do have spaces, then what will happen is that sorting and search for data in the list will be compromised and you will get unexpected results.

Upper case and low case characters in the field do not affect the searches or sort orders unless you specifically tell the Microsoft Excel application it is an issue. You can also use formulas in a cell if required. Formulas can refer to cells within the Excel Database List or outside of the Excel Database.

Note also that you can edit and format the cells just like any other spreadsheet however the issue you must consider as a priority is that the field names must have a different format to the rest of the data in the database list. It is highly recommended that there be no other formatting in the list except for the field headings. This ensures that there are no miscalculations by the application as to what is a field heading in the excel database and what is not.

Now that you have setup your list in this way following these rules, you are now ready to interrogate the list by applying criteria. The easiest way that you can do this is by using the Form dialog box. To get into the Excel Database form you simply choose the Data menu and then choose Form from the drop down menu.

From the Excel Database Form you can simply choose the Criteria button, type the criteria you have for your data and choose the Find Next button and it will take you to the first record that satisfies the criteria you are searching. Excel Databases are particularly useful for summary data that is where the volume of records you have in your database doesn’t exceed 65,536 rows.

If you follow these rules to create an excel database you will find that the functions associated with the excel database list will work in an effective and efficient manner.


Source link

PHP Custom Web Application Development Services


PHP commonly known as “PHP Hypertext Preprocessor” these days was created by Rasmus Lerdorf in 1995 and earlier meant Personal Home Page before PHP version 3.0 came into begin with rewriting of parser and fixing lots of bugs in the earlier version.

PHP open source server side scripting and programming language provides web developers and programmers with lots of instruments for web development and customization. PHP is best suited for developing dynamic websites as it allows easy insertion in HTML code and database connectivity to MYSQL and PgSQL Databases. First version powered by ZendEngine was PHP 4 and herewith superglobals was introduced. With PHP 5 OOPs was introduced. PHP 6 version offers Unicode or multibyte strings.

Whether we talk about PHP software development, PHP programming or PHP application development or outsourcing PHP; PHP server side scripting language is very commonly used language. Range of PHP solutions that custom application development company in India offers include: business applications, business software, CRM development, classified ads, website maintenance, auction, web portals, dynamic websites, communities, social networks, ecommerce, real estate development, shopping carts, online marketplaces, content management, online storage, CRM, helpdesk, newsletter, online accounting software and other custom PHP web solutions.

Custom web application development ensures web solution that is of high quality, customer-centric, on-time, within-budget centered needs needful task by web developers; also provides you develop cross-browser, high-performance solution. Delivering bespoke software solutions leveraging latest web technologies at their best. The web designers, programmers, developers in India are highly experienced and they develop quality web applications in lesser time and at affordable cost. Many custom software development companies offer PHP web hosting plans and clients opting for website development and hosting support together get opportunity to configure PHP as per their specific requirements and this helps web developers to configure PHP more easily rather than using dedicated solution.

PHP tools are extremely useful in custom web application development few are debugging tools (webgrind, DBG, MacGDBp, PHP_Dyn); testing tools (PHPUnit, Selenium); optimizing tools (PHP Profile Class); documentation tools (PHP DOX, phpDocumentor); security tools (PHP-IDS, Secureimage); Image Manipulation Graphs (PHP/SWF charts, pChart); PHP code beautifier (GeSHi, PHP Beautifier); version control system (xinc, Phing); useful extensions, utilities and classes (SimplePie, Creole, htmlSQL, Phormer, PHP User Class); PHP online tools and resources (MinifyHTTP StaticMerger, gotAPI/PHP); in-browser tools (FirePHP, PHP manual search); PHP frameworks (CodeIgniter, Dwoo, YII framework, PEAR, Zend, Qcodo, Smarty, CakePHP); PHP IDEs and Editors (PHPEclipse, PHPED, Zend Studio).

Website users have specific need and your website should best serve these needs. So, a PHP programming company plays crucial role in website requirement gathering stage, moving to cost estimation, documentation, prototype and functionality, coding, design optimization, integration, testing, debugging, deployment and maintenance. Custom application development companies provide their customers with consistent and high quality web design and development services, cost-effective website design solutions, website maintenance, complex database integration and e-commerce website design solutions, content management system solutions.

If you are looking for a website that custom fits your business needs then you are at right place, just hire a PHP development company and get unique business identity. Custom web applications developed using off-the-applications and custom software will render the complete web solution.


Source link

How to Write a Simple PHP Script – 3 Quick Steps to Your First PHP Script


I’m going to show you the exact steps I took on how to write a simple PHP script. Everything you’ve read about how simple it is to create websites using PHP is very true.

In just a short while you’ll be able to install PHP, a powerful web server called Apache and a database software, MySQL in your local Windows machine. You don’t need to buy any web hosting yet and you can simulate everything you see in live websites in your local computer. But don’t get ahead of yourself. Important thing is to relax and let’s go step-by-step on how to write a simple PHP script.

Step 1 – Download WampServer

Get ready to go insane if you plan to install everything manually. The good guys at has a free WAMP (Windows, Apache, MySQL, PHP) installation package that will take out all the frustration when installing an environment for development.

Step 2 – Open Your Text Editor

You don’t really need to buy an expensive text editor. You can just search online for some of these free quality text editors. Or you can just use Notepad if you like.

Step 3 – Write a Simple Script

Create a new file and write the following code below. Save your file under C:-wamp-www and name it simple.php. The first line will basically output “Hello World” to your browser. The second line will display today’s date and the last line will output the information regarding your PHP installation. You can see all of this by opening up your browser and typing h t t p : / / localhost / simple.php

< ? php

echo “< p >Hello World< /p >”;

echo “< p > The date today is: “. date ( ” F j, Y” );

phpinfo () ;

? >


Source link