Creating an Access 2016 Database from Planning to Creating First Table
This guide will instruct you on creating an Access 2016 database from planning to creating first table. Yes it's true that when you create an Access 2016 database there can be a daunting amount of work to do. However, if you are a beginner to the world of database design, then start with this instruction guide.
Here you will see a mind map of the database planning process all the way up to the creation of your first table. It's the one of a series of videos that will take you through the database creation process. Next instruction guide will talk about relationships.
This example shows you how to create a customers database. The idea is that orders are taken but you will have to follow along with the whole series to get the most out of this.
#computertutoring
00:00 Introduction
00:20 The planning stage
03:30 Four primary tools to make a database
04:30 Get started creating a database
06:02 Advice on using underscores when saving a file in Access
06:40 Creating a table
08:15 Explanation of the data type
09:30 Explanation of field name
12:10 Number data type
13:20 How to give a unique name
14:40 Primary key button
15:40 Saving the table naming protocol
16:25 Datasheet view
😊 Check out my website and social media to keep up to date - enjoy learning 😊
📱 http://www.computertutoring.co.uk/ 📱
📽 / thecomptutor 📽
👨👩👧👦 / computertutoring.co.uk 👨👩👧👦
🦉 / ct_tutoring 🦉
📷 / computer_tutoring 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌