How to Reset the Number of AutoNumber field on Table

How to Reset the ID of AutoNumber field on Table Per picture below, a Customer table has a Customer_ID field as a primary key and its data type is set to AutoNumber. That means the Customer_ID is automatically assigned by MS Access to each record and it is incremented by one (1). The first record will start with one on the Customer_ID field. If we delete some records then the next Customer_ID will continue from the one that is deleted. For some reasons that you want to start the Customer_ID…

Read More

How to Remove Duplicate Records from table

How to Remove  Duplicate Records from table by removing dot (.) Many of us have trouble removing duplicate records from our database tables. When data is imported from an excel file or from another database file, the database table will contain the duplicate records or data. For example, there are two records for John (in the CustomerName field) with the same address: John M Lopez with address of 123 N First St John M. Lopez with address of 123 N. First St. This means that there are duplicate records of…

Read More

How to Design and Create Database Table

How to Design and Create Database Table in MS Access Database is a structured set of data held in a computer, especially one that is accessible in various ways per Google.com. Database is a set of data grouped together in one location in (or accessible by) a computer. A computerized database has been likened to an electronic filing cabinet of information arranged for easy access or for a specific purpose (dictionary.com). Planning How will we create a database in MS Access? Before we will create a table for database, we will consider these factors: What type of database we will create? What kind of data or information we need to use? How the each data related to each other? Can we group those…

Read More

How to Create Lookup Field in Table for MS Access

Create Lookup Field in Table Database is a group of data the organized by the specific group that has relation to each other.  Each group has relationship to each other. The employee has relationship or links to the job or task that he or she performs.  The lookup method is used to link one group to another group to avoid the duplication and for consistency of input. For this example, I will use two tables: Employee and TaskDue table to demonstrate the lookup method. One task is assigned to process…

Read More

How to Generate Email List from Excel

How to Get Email List from MS Excel using MS Access There are many ways to get the email list from the Excel list for sending email to those people. Many people may just copy the email from Excel then paste it on the Outlook new mail one by one. You cannot copy one time from the column C shown on the picture below then paste it on the Outlook mail To, because Outlook needs a semi-colon(;) between each email address. Also there is a blank email for some customers…

Read More

How to Link Table from Another MS Access File

How to Link Table from Another Access file When we have many Access database files, sometime many files have the same table or same information on each file. For instance, we use the Security table and User table on many Access file. Each file is using same information. Normally, we just import those tables from another file. However, if we need to update the information for those tables we have to update same information for users on each file many times. The Link Table will eliminate the duplication of updating…

Read More

How to Create Table from Query

Create a new table from data from a Make Table Query We can also create the table from using the Make Table query. In this How To, I will show how to a table by using the Crosstab query and Make Table query together. As example below, I have customers table from the NorthWind Access file. I want to make a JobTitle table from the Job Title field of customers table which has duplicate job title on the list. The customers may have same job title, but we want to show only one time…

Read More