Microsoft Access
Importing Data from Excel to Access
Importing Data from Excel to Access Managing large volumes of data efficiently is a common challenge in various fields, from business to research. Microsoft Access, a versatile database management system, offers powerful tools to streamline this process, including the ability to import bulk records from Excel spreadsheets. This tutorial is designed to guide you through…
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…
How to Create a Query in Microsoft Access 2013
Access 2013 is a versatile database management tool that allows you to filter the data based on the criteria that you define. For any given table (or tables) that you select, Access 2013 allows you to select the fields, sort the data, and then define the conditions. There are several ways in which you can…
Create Access 2013 Forms using the Form Wizard
If you are using only Access 2013 tables to manage your database, then you are just using a fraction of the functionality that it has to offer. You should go a step ahead and start using Access 2013 forms to make your database user friendly and interactive. Access 2013 forms allow you to impose controls…
Take Your Database Online with New Features for Access 2013
Access 2013 boasts a number of impressive new features, but the headliner is Apps. This exciting new capability enhances collaboration by improving the multi-user toolset, greatly reducing the potential for conflicts arising from multiple people interacting with the Access database simultaneously. Better yet, Access 2013’s new App features allow these databases to be easily taken online….
Access 2013 Ribbon Interface: Optimized for Work on the Go with Touch
Access 2013 sees the continued refinement of Microsoft’s Ribbon interface. The addition of a touch mode with improved context features makes it easier than ever to take your work where you need to go using tablets and other touch-capable devices. When activated, buttons and menus are spaced more generously, allowing easy selection of options by…
