fbpx
Logo

Category Archives: Tables

Designing A Query in Access 2017 – Part 1


The true strength of a relational database lies in its capability to instantaneously fetch and analyse your data by running a query. Queries enable you to pull data from one or multiple tables based on a set of search conditions you define. This tutorial will teach you how to make a basic one-table query. Then you will figure out how to plan and run a slightly complex multi-table query. What are ms access query ? Queries are a method to search […]

Tags: , , , , ,

Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type


Microsoft Access 2016 Database eBook

Coming soon… Microsoft Access 2016  will gain a new data type called ‘Large Number‘ which will be an extension to the Number at a type or more commonly referred as BigInt (Big Integer). Large Number (or BigInt) is a new supported data type that will help developers and users with added analytical capability. This extended support means that Access can finally read and write data to and from external data sources which make also makes use of BigInt. This has been a limitation […]

Tags: , , , ,

Should We Be Using Calculated Table Fields-Microsoft Access Database ?


Microsoft Access Database

Microsoft Access Database: Should We Be Using Calculated Table Fields With the introduction of Microsoft Access 2010, a new data type field appeared in your table design view which provided a basic way to take fields in the same table and create new expressions as a new dedicated field sitting at the ‘top of hierarchy’ database! However, should we really be using this new data type and practice at all? Purists will frown upon this technique and say you should stick […]

Tags: , , , ,

Microsoft Access Table Relationships


Microsoft Access

An ideal database is free of redundant or duplicate data. To achieve that, you must split your data into many subject-based tables so each subject is presented only once. To do that in Microsoft Access, you place common fields in tables that are related. But before you do that, you must need to understand the relationships between your tables, then you can specify these relationships in your Access 2013 database. In this article, I will elaborate to you the ten […]

Tags: , , , ,

Microsoft Access Validation Rules In Tables


Microsoft Access

A Microsoft Access validation rule restricts or controls what a user can input in a table field. You can think of it as a set of layers which ensures that your users input data properly. Here’s a quick video tutorial to get you going and very easy to apply. Microsoft Access provides several ways to validate data: data types, field sizes, table properties, and input masks. Among these, table properties provide specific types of data validation. One example is setting the […]

Tags: , , , , ,

Microsoft Access Tutorial: Creating A Many-To-Many Relationship


Microsoft Access Tutorial

Let’s revisit a popular aspect to your Microsoft Access Tutorial database design; Creating a many-to-many relationship. Firstly, watch this quick video which explain the key components and the starting steps to getting to the many-to-many state for your Access database. In order to create this type of relationship, it’s now clear we need an interceding or junction table to handle the two-way joins of the outer tables with the option of setting referential integrity option which tightens the operational side […]

Tags: , , , ,