Microsoft Access
-
Using Templates in Microsoft Access 2019
Microsoft Access is still one of the simplest to use database tools. One thing that makes MS Access such a useful tool for the novice user is templates. MS Access templates give you a head start when creating a new database, and there are lots of different options to choose from. To start using a…
-
Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
Microsoft Access remains one of the simplest database tools to learn. Better still, Access integrates well with other Office tools like Microsoft Excel. In this Microsoft Access tutorial, we take you through how to get set up in Access and start your database training journey. If you are brand new to databases, then this Microsoft…
-
Understanding Access 2013 Relationships between Tables – Part 1
The most important goal of any database design is to ensure that there is absolutely no data redundancy. The best way to achieve this is by creating relationships between different tables, which have some common fields. Access 2013 offers you an easy way of doing this. All you have to do is select tables, drag…
-
Finding Duplicate Records in Access 2013
Synopsis: A common problem when working with databases is the presence of duplicate records. In this article we look at some of the facilities in Access 2013 for identifying duplicate records. There are various causes for duplicate records in a database. One common scenario occurs when two or more databases are merged. Another situation that…
-
How to Create a Database in Microsoft Access 2013
Synopsis: In this article we look at the options for creating a new database in Access 2013. In earlier versions of Microsoft Access, a database has usually meant a desktop database. This is a database comprising data structures and user interface components that enable one or more users to maintain data. In the most common…
-
Understanding Access 2013 Relationships between Tables – Part 2
There are several features in Access 2013 that make tables much interactive and versatile. Lookup wizard allows you to predefine the set of values that a field can take. The potential values appear as a drop down menu, and you can simply select the correct value for that particular record. You can further choose to…
-
Understanding Access 2013 Relationships between Tables – Part 1
Database management is not all about storing your data in the form of tables; it is also about correlating data, ensuring data consistency, and enforcing referential integrity. A great way of achieving this is through table relationships in Access 2013. By using a foreign key or a common field, you can link two or more…