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. How do I build my own mini database program in VB?.What’s Microsoft Access got to do with it?.Now let’s get that wizzo brain cap on as we prepare to answer the following searching questions: Whether youre wanting a Christmas bonus or just need to boost your Visual Basic knowledge I’m here to help.ĭon’t forget that I love to hear feedback! Feel free to send me a message, abusive or otherwise by clicking on the "Post Feedback" link at the end of the page. I’m your crackingly cool host, Karl Moore and over the next few weeks we’ll be covering everything you ever wanted to know about databases, but were too afraid to ask.
Welcome to the very first part in this wizzy Visual Basic Database tutorial!
0 kommentar(er)
