One of the more abstruse points of procedure in Access involves the three so-called normal forms. What, exactly, are they? If you think “guidelines”, or “protocols”, you’d be in the ballpark. When building a database, especially a relational database, there are some “streamlinings” which allow …
The good news is, the import and export processes in Access—and in general—are two sides of the same coin. And there really isn’t any bad news, other than making sure the data are set up in a way that Access can understand—namely, something row-and-column-ish when …
When setting up reports in Access, we’re trying to learn something which wasn’t in the original data. Something calculated, derived, or otherwise figured out from the existing information. It’s fairly easy to do, though there are a few steps. After determining the requirement—a sales tax …
A fundamental aspect of Access databases is the setup of relationships between tables. It’s usually the nature of business databases to have them. So the actual creation of the relationship isn’t hard to do. But there are a couple of not-so-obvious things the user needs …
The term “normalization” gets thrown about quite a bit in database circles, to try to explain part of data organization. But it’s vague, to someone not acquainted with database-ese. The idea of making data “normal” is not too far from the meaning used by database …
Working with Microsoft Access can be kind of intimidating when you start, especially because there seem to be so many details to absorb and keep track of. And even fairly experienced database people have to watch out for the little things. One which really drives …
Judging Access vs Excel can take thought. Most people find Microsoft Excel fairly easy to learn—it has a fairly gentle learning curve, the fundamentals only take a short time to pick up, and the program is actually fairly versatile—it’s not just a ledger book on …
Often times the information you need isn’t stored as a field within a database. As a matter of fact, certain fields make more sense to calculate whenever they are needed instead of storing the value in a table. Microsoft Access 2013 makes this very easy. …
You find yourself working in an Access table filtering out some unnecessary data and it dawns on you this filtering is something you’ll end up doing frequently. It would make sense to store this process as a query in the database. Okay, so now I …
How to Import Excel Data into Microsoft AccessWatch this video on YouTube In this Microsoft Access tutorial, you’ll learn how to import data from a Microsoft Excel worksheet and create a table from it in an Microsoft Access database. To learn more about Microsoft Access, …