In episode 22 of R&R we discussed what a database is and why you would want to use one. In this episode we walk you through creating a database from scratch using Microsoft Access. We show how to import data from a Microsoft Excel spreadsheet. How to set up primary keys. And how to create a relationship between 2 tables in your database. So without further ado, lets talk about Building Access Database:
What is a Database?
A Database is an organized way to store data (usually in a table). Inside tables you’re going to have fields that contain records relative to the table. The benefits of using a database in place of a spreadsheet are:
- Easier to store large amounts of data.
- Multiple ways to input data including forms.
- Easy to run reports from a database.
- Ability to set up relationships between tables.
Building Access Database
In this episode we talk about the first steps in building Access database. We walk you though how to:
- Create a blank database.
- Import data from a spreadsheet.
- Create Primary Keys.
- Set up a Relationship between 2 tables.
In future episodes we will go over creating forms. Setting up Queries. And creating valuable reports!
If you enjoy our videos don’t forget to “Like”, comment on, and share them on social media and subscribe to our YouTube channel to make sure you never miss an episode!