Communication leads to success
La communication génère le succès
Français
Home
About Us
Contact Us
Web
Web DesignDynamic Web Sites
Web Portfolio
Database
Excel vs. MyQL Database
Domains & Hosting
Business, Marketing Training & Coaching
Sales & MarketingInternet & Web
Social Media
SEO & Traffic Analysis
Strategy & Business Plan
Communication
| Excel vs. MyQL Database |
| MS Excel Spreadsheet | Database |
Definition: A screen-oriented interactive program enabling a user to lay out financial data on the screen. |
Definition: An organized body of related information, using tables, index … (i.e. MySql). |
Specificities of Excel: |
Specificities of a database: |
- Storing and analyzing data in lists, although the number of sorting combinations is limited. |
- Viewing information in list, form, or table view. The number of sorting combinations is high. |
| - Producing charts and graphs. | - Creating and publishing customized forms and reports from numerous tables. |
| - Building a financial model. | - Storing and managing virtually any type of information (words, images, numbers, files and more). |
| - Creating basic reports, rapidly. | - Easily interconnecting related information such as clients, seminars, training, etc.. |
- No programming language knowledge required, although the embedded code requires caution! |
- Programming language knowledge required. |
- Controlling who can open or modify a file. Only one user at a time can modify a sheet. |
- Modifying tables by multiple people at the same time all using a different level of rights. |
| - Low protection of the embedded code. | - High language protection, it's accessible only to programmers having access to the server. |
| - Sorting list may lead to mixed data. | - A database is built to sort and to search. |
| - The same information can be repeated in different sheet and be difficult to maintain. | - Information is entered only once. |
| - Back up possible at the computer level. | - Automatic Back up possible at the hosting level. |
| - Transparent for a majority of computers. | - Transparent for many servers using MySql. |
- Allows Dynamic Web Site owners to modify their web site content alone. |
Web
Web Design | Dynamic Web Sites | Web Portfolio | Database | Excel vs. MyQL Database | Domains & Hosting
Business, Marketing Training & Coaching
Sales & Marketing | Internet & Web | Social Media | SEO & Traffic Analysis | Strategy & Business Plan | Communication