How to Utilise and Apply Access Database Normalisation Techniques
In the design of an Access database, the process of organizing data to minimize redundancy is called normalization. Normalization usually involves dividing large, badly-formed tables into smaller, well-formed tables and defining relationships between them. More ...
Your First Visual Basic 2010 Express Program
Visual Basic is very popular because its Visual Programming Environment lets you develop Windows applications by dragging and dropping controls from a Toolbox. It's also popular because it's based on the Basic programming language, and because Visual Basic Express edition can be downloaded from Microsoft's website for free. More ...
Five Common Mistakes Affecting Access Database Optimisation and Performance
Building an Access database requires some time, effort and ideally a good level of database knowledge. The assist tools Microsoft Access provides do not control some of the pitfalls most developers brush aside leading to a slow database. Here are the five common mistakes developers need to be aware of and handle accordingly. More ...
How to Navigate the Access 2019 Opening Workspace
If you're upgrading to Access (or Office) 2019 from the 2013 or 2016 interface, you'll find it looks very familiar ? and you'll find much of it to be the same as what you're accustomed to. More ...
C Sharp Keywords
keywords, sometimes called reserved words, are predefined words that have special meaning to the compiler. Keywords cannot be used by the programmer as identifiers such as variable, method, or class names. A programmer must use keywords only in designated locations in the code. More ...
Visual Basic File Reading and Writing
The biggest problem with administering the list myself is adding and deleting email addresses from the list. Before you add an address to the list you have to make sure it's not already on the list. More ...
The Components of the Microsoft Access Database Interface
As you open a document window in Microsoft Access, toolbars, menu bars (or Ribbon Bars from version 2007) will change state and can be a little disorientating at first. In some cases, you can only be in one type of window to view a function or feature. More ...
How to Learn to Program
If you want to learn to program will be happy to know that programming is not a hard thing to start learning and will not require you to pay out huge sums of money. The only way to become an expert is much like learning the violin; the answer is practice, practice and practice some more. More ...
Six Important Points When Importing Data Into An Access Database
Asking general users to import data into an Access database without knowing too muchabout how Microsoft Access works and they will become frustrated within minutes. The most desirable way of using external data is by importing or linking data to an Access table object. Once the data has been imported or linked, you treat it like any other data table and build your queries, forms and reports. More ...
Visual Basic 2010 Textbox Based Simple Edit Program
In this example, you'll create a very simple text editor that uses the Textbox control. This example is for beginners so I'll go step-by-step through the process of developing the program. More ...
