STUDIES serve for delight, for ornament, and for ability. Their chief use for delight, is in privateness and retiring; for ornament, is in discourse; and for ability, is in the judgment, and disposition of business. For expert men can execute, and perhaps judge of particulars, one by one; but the general counsels, and the plots and marshalling of affairs, come best, from those that are learned. To spend too much time in studies is sloth; to use them too much for ornament, is affectation; to make judgment wholly by their rules, is the humor of a scholar. They perfect nature, and are perfected by experience: for natural abilities are like natural plants, that need proyning, by study; and studies themselves, do give forth directions too much at large, except they be bounded in by experience. Crafty men contemn studies, simple men admire them, and wise men use them; for they teach not their own use; but that is a wisdom without them, and above them, won by observation. Read not to contradict and confute; nor to believe and take for granted; nor to find talk and discourse; but to weigh and consider. Some books are to be tasted, others to be
swallowed, and some few to be chewed and digested; that is, some books are to be read only in parts; others to be read, but not curiously; and some few to be read wholly, and with diligence and attention. Some books also may be read by deputy, and extracts made of them bothers; but that would be only in the less important arguments, and the meaner sort of books, else distilled books are like common distilled waters, flashy things.
Reading make a full man; conference a ready man; and writing an exact man. And therefore, if a man write little, he had need have a great memory; if he confer little, he had need have a present wit: and if he read little, he had need have much cunning, to seem to know, that he doth not. Histories make men wise; poets witty; the mathematics subtitle; natural philosophy deep; moral grave; logic and rhetoric able to contend. Abeunt studia in mores. Nay, there is no stand or impediment in the wit, but may be wrought out by fit studies; like as diseases of the body, may have appropriate exercises. Bowling is good for the stone and reins; shooting for the lungs and breast; gentle walking for the stomach; riding for the head; and the like. So if a man's wit be wandering, let him study the mathematics; for in demonstrations, if his wit be called away never so little, he must begin again. If his wit be not apt to distinguish or find differences, let him study the Schoolmen; for they are cymini sectors. If he be not apt to beat over matters, and to
call up one thing to prove and illustrate another, let him study the lawyers' cases. So every defect of the mind, may have a special receipt.
Thursday, February 25, 2010
How to Generate 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.
To read about highest
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.
To read about highest
Life
Life is like water. We should adapt to it. I like running water. It is the strongest and mar incxhauslihle source of life in the world. Its strength lies in Its generosity, Its incessant running and Its adaptibility to any environment. To adapt is to conquer. The eonstant dropping of water wears away the stone. This is Its tenacity, stamina and persistence.
Water makes Its way through the mountains, Sometimes it runs and jumps in the valley. Sometimes it rushes down in the shape of a saran and sometimea it goes slowly forward in ripples and deep in emotion. Now it hides silently underground. Then it hangs high in the sky and distinguishes herself.
It is not afraitt of diffieulties, nor of twists and turns. It is willing to be a tiny drop of water. In short it can be as big and small and tolerant as it is.
In this world, tortunes and misfortunes are common. What matters is to keep quiet as water when disaster befalls The water keeps running and will never stop until it reaches the sea.
Water makes Its way through the mountains, Sometimes it runs and jumps in the valley. Sometimes it rushes down in the shape of a saran and sometimea it goes slowly forward in ripples and deep in emotion. Now it hides silently underground. Then it hangs high in the sky and distinguishes herself.
It is not afraitt of diffieulties, nor of twists and turns. It is willing to be a tiny drop of water. In short it can be as big and small and tolerant as it is.
In this world, tortunes and misfortunes are common. What matters is to keep quiet as water when disaster befalls The water keeps running and will never stop until it reaches the sea.
Sonnet of Life
Chaos and Chronos
Abandoned the Egg
Egg that nestled the quantum of life
Upon the mercy of elements below
Sustained by nourishing waters
Kept alive by the whirling winds
Energised by the passion of fire
On the foundation of terra firma
Life’s legacy
Egg, Embryo and Evolution
Left alone to love
Left alone to ponder
About the space beyond,
The cosmos and their fate ahead
Abandoned the Egg
Egg that nestled the quantum of life
Upon the mercy of elements below
Sustained by nourishing waters
Kept alive by the whirling winds
Energised by the passion of fire
On the foundation of terra firma
Life’s legacy
Egg, Embryo and Evolution
Left alone to love
Left alone to ponder
About the space beyond,
The cosmos and their fate ahead
Marketing officer
As the main principle,taking active part in the project of the Internationalo Auto Show and Autumn Real Estate fair in sehnzhen,including the data collectting,infomation analysis,communicate with customers and supervise the work of the layout.At the same time,i have successfully developed the security and the banks of the two markets.
Responsible for buying carton, graphic carton and instruction. In accordance with the production schedule to urge the supplier to supply,Negotiating with suppliers,Communicating with the quality management department and customers.During the time,many changes have taken place,i have excellent communication and implementation of the ability to safeguard the company's interests and credibility.
Responsible for buying carton, graphic carton and instruction. In accordance with the production schedule to urge the supplier to supply,Negotiating with suppliers,Communicating with the quality management department and customers.During the time,many changes have taken place,i have excellent communication and implementation of the ability to safeguard the company's interests and credibility.
Subscribe to:
Posts (Atom)