If you have many users of a database, try converting it to spilt database structure. Your database will be divided into two main parts; first is the front end file containing all the objects (queries, macros, forms, reports and modules). The second part is the backend file that is linked to all the frontend files. Backend can be stored in location which can be shared with many users. The front end is distributed to each user’s desktop and linked to the shared database. This reduces network traffic as the file does not have to be retrieved every time. Database manager and database splitter helps in the process of creating such architecture.
Splitting your database has several advantages; if you are sharing it over LAN or with a large group of people, a back end version is made so that all the updates can be viewed by everyone using the file.
In this Access tutorial, we will teach you how to create a split database in Access.

Many computer users like to work with keyboards. It increases their speed and makes them less dependent on mouse clicks. There are functions that are common to all the products of Microsoft products such as cut, copy and paste and the shortcuts are the same for them in all Microsoft Office programs.
In this tutorial, we will teach you keyboard shortcuts in Access that you can use to perform various actions without using your mouse.

Access gives you a few different ways to jump to a record that you need. The find option in Access allows you to locate the specific text you can’t seem to find. The search option makes it easy to look for a person or order but it does not give you the perfect match. The “go to” options help you to navigate through records easily. Search MS access for records and objects through the use of these options.

Microsoft Access is database application software that lets you create database of various sorts with ease. In access, there are advance options that you can use to cut, paste and copy data. There is a paste append option that allows the user to avail the clipboard paste function. This means that you can copy data and it will be copied to the clipboard. If you want to paste anything from the clipboard, simply insert it from there.

Microsoft Access allows you to create tables, forms, queries and reports that are essential for your database. You can use different features to easily create your own database even if you are new to the Access. In this tutorial, we will guide you how to create tables in Access. Tables in Access are the foundation for your database and your record entries.

Design view in Access is the best way to create tables, forms and reports. Design view lets you configure even the smallest option in your database. It provides you with various options for table construction. In addition to all the features on table tools field ribbon, it has many customizable field properties. Furthermore, we will teach you how to assign a primary key to your database. Primary key is the unique identifier of a specific table and it can be any field that is unique to that table only. Follow this step by step tutorial to learn how to assign a primary key in Access.