Microsoft Access 2016 for Beginners: Creating a Database from Scratch

This is part 3 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating a database from scratch and designing tables in Access. For more info. see also kaceli.com
In more detail, this session we will focus on:
Creating a database from scratch in Access 2016
Learn components of Microsoft Access and what various components do.
Learn about external data in Access
Database tools and database relationships
The Tell Me feature in Access 2016
Creating and designing tables in Access databases
Creating fields in a table in an Access database
Defining the data types in a table in Access 2016
Records and fields in an Access database
Defining types of fields in an Access database
Defining the primary key in a table
Saving the table
Changing the design of a table in Access 2016
Using the Design View to modify the structure of a table in Access 2016
Setting the field size length in a table.
If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
Video URL: • Microsoft Access 2016 ...
It is suggested that you continue to part 4 after completing this module.
Keep in touch and please spread the word by subscribing and using the share links below the video and commenting:
Website: kaceli.com
KZbin Channel: / skaceli
If you want to take get a deeper understanding of Microsoft Access, take a look at learn.kaceli.com
Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

[@Masya7ru]

Great video. Thank you so much for a very detailed and easy to understand introduction to access. I just started learning this software and this video was very helpful. Great pace, useful tips, and great job of explaining the terminology.

[@tymccarthy9661]

Thank you for this! This was a good refresher to dust off my old Access skills from years ago!

[@pauletterisher4034]

I was very impressed with this video. The narrator has the gift of explaining complicated information in an understandable way. He also provides some practical "hard won" advice and cautions i.e., get the structure of the database correct from the beginning. Well done. Thank you!

[@KaceliTechTraining]

Thank you @pauletterisher4034. I appreciate the feedback. I hope you also gave it a thumbs up.

[@sarthakdhillon1983]

Hi, thank you for giving me this knowledge as i am studying this in school at present

[@ah9250]

Thank you I'm learning this for work!

[@sksweetu2275]

Thank you so much i have my computer assessment tomorrow and I was not prepared getting to know basics really helped cuz it helped me guide through my textbook to easily learn it

[@Liberty_Freedom_Brotherhood]

Clear, calm and concise explanation. Great video! 👍

[@mostafatantawi8680]

Amazing Tutoring videos, Thanks alot Mr. Kaceli

[@rika5632]

Your explanation is spot on. TY. Need to create a DB for work

[@AbdulRafayVlogz]

Thank you so much Mr Kaceli... My finales are tomorrow and i just find this video pretty helpful

[@dorothykearney7234]

Very Good! Great teacher! Thank you for putting this on KZbin!!!

[@trainingvideos9999]

Great explanation Sr! Thank you

[@nursyahirahabubakar4576]

hi, i would like to ask how build a search engine using microsoft access. I want the it to match data from three different table when we insert input. I would be grateful if you can help me

[@karlamcgrigg9911]

Easy to understand, very helpful, Thanks soooo.. much

[@sgarcata]

Very clearly presented without a lot of unnecessary chatter.

[@edememmanuel5412]

Thank you sir As simple as it is I've acquired lots of knowledge in brief

[@x4ms]

Thank you. Verry well done!

[@jameelaltheeb4635]

Thanks a lot Sali, really useful session

[@aptisinfo7386]

Helpful video, thank you... I have a question - in migrating data from MS Outlook, via CSV data import, into Access, and one of my contact record fields, the "Categories" field, includes multiple data elements separated by semi-colons. Example, a record may have 5, 10, 50 categories (separated by semi-colons)... so, wondering (1) how to properly import this information into an Access table properly, and (2) what the form will look like for entering new "Categories" into Access once it is up and running.... Thank you for any insights.... AG

[@audlemcrafting]

Thank you, very informative and easy to follow :)

[@Error-xd7cb]

Thanks for the help sir.

[@AlyIns838]

Best by far!!

[@teresiahngugi8870]

This was helpful to me.Thanks

[@davesucre2291]

thank you for the tutorial. helpful

[@rafaelreformado9370]

Go to settings and change the speed to 1.25... you are welcome

[@hiavl]

thank you so much

[@midohossam5782]

I wish I saw your comment before finishing the video....

[@user-db2du6kx7s]

perfectly fine with x2!

[@Dornpunzel]

Didnt fint the speed setting in MS Access. Möhöhö :D

[@mardenhill]

you meant 0.75. no need to thank me.

[@UnbreakLeviatan]

Hi Sali., This is very good and helpful. Just want to check if you can point me to the right direction. I am trying to create a data base of just numbers. for example like a number integer can call other number data?

[@Stephanie-zl1ws]

OMG thank you! the only video i have been able to understand!!!

[@KaceliTechTraining]

Great. Please spread the word in your social media then. Thank you.

[@bhaskarbharati5663]

wow learned a lot. Thanks

[@ave1996]

Can we add formula in a field? Example I want to add 3 to every number I input in that field...

[@yolow69]

Thanks, I’m learning

[@sofiav7791]

this vid came in clutch, i have an IT assignment due tonight thanks man

[@KaceliTechTraining]

Hope you did well in the assignment even though it is 3 years later 🙂

[@102masumbillah8]

Thanks a lot...

[@deebialism4359]

Magnifico 👌

[@dm7628]

Thanks 🙏

[@MMchannels]

very helpful

[@senpaijol2488]

Nice video sir more data base videos with english subtitle.. thank you for the efforts sir.

[@c.d.ntechnicalhacker1052]

Thank You Very much

[@Magggneto]

Bless you for uploading this

[@KaceliTechTraining]

Thaks for the feedback. Glad you found it helpful.

[@eugene5298]

good work done

[@SaveWaterEveryday]

Thanks sir.

[@canaanwb1]

Question for you. I’m not familiar with Access, but I think I might be able to use it to make work easier. I have a large list of employees at the company I work for who routinely need paperwork filled out and submitted for events. Is it possible for me to build a database, select the names of the members attending the event and then have a macro transfer the information needed into each document? My concern is the docs I’m looking to have auto populated are word and pdf files. Is this possible? If so, do you have a video giving a walkthrough of how to create something like this?

[@joukenienhuis6888]

Hi Decan, I don't know if yu have found your solution yet, but for a large list of employees to keep track of Microsoft Access is ideal. But when you start making a database, be sure to have a good design of your database. Preparation is most of the work and makes later corrections and adaptations less possible to occur. Try to make a clear definition of what you want to do with your database. Then try to find every form you want to use to get information for your database. Then try to identify the fields people have to fill in and use that information to make your tables. If you have made your database and filled it with all the information you need, then try to make a macro that loads a Word template with defined fields. The macro will fill in the defined fields with the information from your database. And dont forget to make a selection query first to use the correct information.

[@donaldthomas7753]

Sali, can I get this in Chinese language?

[@suzetteclarke1113]

Thank you

[@OS-qd5wo]

Very helpful video Thank You sir

[@allenbennett8735]

This should be simple, but I'm not sure where to begin. What I want to do is to list all the rooms in my apartment, and all the places in each room where I can store items, enter an item I want to know the location of, and it will tell me where that item is. Is Access a good way to handle this?

[@safeenaalie2637]

Thx to hime to get us to learn about this it is very smiple n easy☺

[@KaceliTechTraining]

Thank you!

[@lindamora7]

Can the info of customers be imported from an outside system?

[@KaceliTechTraining]

Yes. You should be able to export to Excel or .csv file format and then import it.

[@sherinehill9586]

Thank u Teacher

[@KaceliTechTraining]

You are welcome. Thank you for checking it out.

[@josefuentesomana697]

Hi, excellent video! I tried to add an attachment field and it was not allowed

[@boyar3033]

Thank you! I am learning this for school.

[@joyceokyere8466]

Dang thanks a lot

[@box3676]

1.5 or 2x recommended!

[@divyamehta3102]

This video was very good and i was able to understand it easily

[@aymanamer2]

waiting the full access video :D

[@KaceliTechTraining]

kzbin.info/www/bejne/Z3qkZYabls-NiNk

[@archanaaa2514]

Which version is good to learn? Microsoft 365 or office 2016?

[@KaceliTechTraining]

Access 2016 is part of Office 365 apps.

[@clairekammerer7220]

You try to give the video more brightness it will be great if you do

[@Liberty_Freedom_Brotherhood]

“The Zip code can’t have letters” U.K. people: 🤦‍♀️ 🤦‍♂️

[@thegend8533]

Legends never die

[@atharvas3244]

no, micheal jackson died

[@lavanyachowdary3026]

you can take about download MS ACCESS

[@arrianranger5800]

Why does every access tutorial deal with a business customer data base> doesn't anyone know that access is so much more. I used to use one that was exclusively for books, authors, Isbn's titles and so on. Its been a long time and I've never set up one before. So why oh Why???

[@KaceliTechTraining]

Good point @arrianranger5800. It can be easily used for books, personal item inventory, music collections as in the old days etc. The business examples are to align it with what most small businesses use it for.

[@yogesnathan5451]

Is this still current

[@KaceliTechTraining]

Yes, Access has not changed much for the past 13 years since Access 2007.

[@wind_yeet7294]

Whos here from online school?

[@bophelofelicia6144]

Me💁

[@bophelofelicia6144]

Me💁

[@katochirimotokia400]

me

[@divyamehta3102]

goody

[@humaridunia5398]

pls explain all this in fast way.

[@KaceliTechTraining]

Thanks for the feedback. The quick version of the tutorial will premier on Wednesday at 12pm ET from this link: kzbin.info/www/bejne/j3LNYamwgsl4hqc.

[@joshuaedwards4102]

I have snaids

[@ThusIsBrad]

protip: easier to understand at 2x speed somehow

[@beepflash]

Jaihaze

[@user-jq4bo4rs4p]

The alcoholic advertisement cranially record because signature monthly behave beneath a narrow psychology. mixed, same anteater

[@user-jq4bo4rs4p]

The tacky card uniquely communicate because microwave booly prefer down a beautiful carp. tawdry, jumbled beer

[@rons.6683]

Access is the devil.

[@spotifyeu1058]

you talk a lot🤯

[@KaceliTechTraining]

Thanks for the feedback. I try to explain the concept. For those that prefer less talking, I suggest you check out the 30 minute versions of the full tutorials.

[@mikel4510]

No longer relevant.

[@micheni.g4426]

anyone doing this for school

[@Modhumitamondal]

very helpful