Don’t worry about perfection; your tables will evolve as you work with Access and gain mastery over it. To change this, click on REGULAR EXPENSES.Expense Name field, and drag it towards MONTHLY EXPENSES.Expense Name field. Some questions that will help you get this right include: We suggest you have a rough draft of your table structure on paper. Together, these Criteria will pick up mismatched Fixed Expense records. In fact, you’ll find that you can get a whole lot more out your data when you combine Excel sheets with a well-organized Access database. What should I do? SQL Server). This is the column that is typically used to retrieve unique rows of data from the table. Step 4: Know that the Columns are called Fields. If Access is already open, select File > New. Square. 2. By using our site, you agree to our. Access automatically creates a new Access database in the same folder as the data file and adds links to each table in the external database. 4. On the Select Table dialog, choose a table from the database to import. You may notice that, whenever you start Microsoft Access, you see the following screen. Click on the second column (Expense Name) and type “Rent”. It represents an absolutely versatile tool to create any number of applications that work with relational databases, forms, and workflows. These connecting links are called “foreign keys” in Database jargon. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ad\/Make-a-Database-Using-MS-Access-Step-1-Version-2.jpg\/v4-460px-Make-a-Database-Using-MS-Access-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/ad\/Make-a-Database-Using-MS-Access-Step-1-Version-2.jpg\/aid2987419-v4-728px-Make-a-Database-Using-MS-Access-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"