Double-click on the data control in your Toolbox the one that looks like this. A regular blank form should appear on your screen. Choose the "Standard EXE" option and click OKģ. Start Visual Basic if youre unsure about this, check out my Visual Basic tutorial here.Ģ. You don’t want to hear me babble about database theory – you need to get stuck in! Well, I can take a hint so let’s get down and dirty, and develop our first Visual Basic database-integrated application with absolutely no code at all!ġ. Either way, that’s pretty geeky stuff so we’ll cover it later.ĭon’t tell me, your boss has asked you to develop a supercool database system and handed you a deadline of yesterday. You can even have a relationship with a query, but the Church doesn’t commend it. Tables store numerous rows of informationĪ database can also contain relationships and queries.OK, lets run over those wizzy terms once more: Also, it’s inadvisable to graze sheep in a table field. This is considered highly uncool in the database world. Top Tip: You cannot eat your dinner off a database table. So each time you need to add a new customer, you just fill in the "CustomerName", "CustomerPostCode" and "CustomerTelephoneNumber" fields and Bob’s your Uncle!Īctually, he is my uncle but thats totally irrelevant to the current discussion. Just like an Excel worksheet, you can add new entries to the table by simply filling in a new set of fields. We need to call them "fields", because it’s the done thing and boosts your street-cred. Each of those boxes has a descriptive name, such as "TelNumber".īecause we’re supercool geeks, were not allowed to call those boxes err, boxes. That’s all a table is a set of pre-defined "slots" or "boxes" into which you throw information. Column A, for example, could hold a customer name, column B may hold the customer postal code and column C may hold the customer telephone number. You can imagine a table as one worksheet in an Excel workbook.Įach column of the worksheet may hold something different. A database may include many different tables. Most database wizards just like to overcomplicate things in a bid to scare off any programming newbies. Hmm, doesn’t sound terribly complex does it? Erm, thats because it’s not. Top Tip: You can make friends and impress the opposite sex at geeky cocktail parties by saying "DB" instead of database. You can shove information into this store or retrieve it from the store, with virtually no code at all. They usually come in the form of a simple file (just like a Microsoft Word file, say). Eugh, who wants to play around with databases? Certainly not me, I just wanted to program.īut you soon realise no matter what type of program you’re creating, databases can be pretty cool things.Ī database is essentially just a store of information. When I first entered the geeky database scene, I shivered at the "d" word. Ha – and they said this tutorial wasn’t going to be interesting! The meaning of life is 42 and grass is green ’cause all the other rainbow colours are absorbed and only the green reflected, a process known as subtractive colour mixing. Well, let’s get the philosophical stuff out of the way first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |