This is part 1 of 2 of the Microsoft Access 2016 tutorial. The tutorial starts with the very basics and continues to the more advanced features on properly understanding how design and use an Access database. For more info. visit
THE DATA FILES FOR THE TUTORIAL ARE HERE: You will need to download and unzip them.
The following are covered in this tutorial along with the timeline:
00:00 Getting Started with Access Concepts
00:50 General Concepts Related to Databases
02:55 Components of a Database: Tables, Queries, Forms and Reports
04:13 Database components in an actual database: A brief overview
09:08 Opening and working with an existing Access database template and identifying components
11:22 Entering data in a database from a template
13:47 Creating a new database and saving a database
14:00 The Access user interface components
15:35 The Tell me feature in Access 2016
16:19 Creating your first table in Microsoft Access and table components
17:59 Understanding data types in an Access Database and tables
18:19 Defining the table fields and data types
20:22 Entering data directly into a table
22:35 Primary Key concepts
23:57 Using the Design View to design a Table
28:51 Modifying the Design of an existing table using Design View and adding a new field
29:41 Yes/No fields in a table and assigning the Primary Key in a table
31:44 Creating forms from a table to enter and update data using the Form Wizard
36:31 Modifying a form in Access
38:53 Creating a simple query from a table and using the Query Wizard
41:30 Creating reports and using the Report Wizard
43:47 Modifying a report
45:00 Using the Data Files for the tutorial
48:00 Creating Tables from an Excel data file
49:43 Importing the data structure and the data from an external file
53:58 Creating tables and importing the data from a .csv file
55:16 Creating a Table from a .csv file
57:12 Understanding the Primary and Foreign Keys in a database
1:00:30 Linking tables in Access 2016 and Defining the Relationships
1:02:02 Identifying the primary and foreign keys
1:02:53 Selecting the tables and linking the tables
1:03:30 Defining the relationships
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:
Keep in touch:
Website:
YouTube Channel:
If you want to take get a deeper understanding of Microsoft Access, take a look at
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.
Nguồn: https://cunglamdep.org
Xem thêm bài viết khác: https://cunglamdep.org/tong-hop/
thanks
Thanks so much for your efforts, these two tutorials would be extremely beneficial for me, I have a new job that I would start soon. I was assuming that they would be using excel as their database, but I heard that it would actually access itself, I have few days to learn these important lessons. BEST REGARDS FROM BIRMINGHAM UK
i am satisfied
Ok
PRESENTATION not just Great but its FANTASTIC! very Very Informative. Many thanks
So nice video , have a wonderful day friend !
Access is great software , very much underrated .
It was fairly simple , thanks
I have learned so much from your videos! Thank you ! I have a question. I have a form that calls a second form and passes a variable to the second form. Is there any way to retain that passed variable on refresh? Scenario: Tracking documents processed. 1st form is high level – name, date, id# (unique key) and daily total docs processed and total time spent. 2nd form captures the detail start & stop times through out the day – so can be multiples to add up to total time spent. I pass the variable of id# to the second form but must close the form to enter the 2nd round of information in order to have the variable pass to the second set of start and stop times.
Is there a way to refresh selectively? and leave the passed variable in the new entry? or a way to RE SetTempVar?
I got a job thanks man
After using your trick i am able to download pokemon go spoofer in my android device thanks for sharing
Good day, Sali Kaceli. it is a exceptionally captivating video. thanks. 🙂
01:07:40
16:33
22:58
U saved my life! thanks
Hola, muchas gracias por compartir esta información, muy clara la explicación . Éxitos.
I didn't know that it was that easy. Thank you so so much. I would like to watch Part 2 lesson. Looking forward to it. Once again, thank you Mr Kaceli.
a lovely domestic web page is one b izop p. c o m . it will permit you to assemble capital money From your Macintosh or PC.
TOLONG Subscribe balik .. amanah
that you for this information
nice
Thanks for the Video!
I am a programming major with zero Access experience. I recently got a position at a company and Access is a must! You really helped me understand the fundamentals! Thanks!
Best spending of money for the last few months. I paid almost nothing and received such a nice essay on myeasypaper.com❤️❤️❤️
KLEENCLEFF on iG unlocked my non spendable bitcoin successfully…
Great video.
Sound and clear
Great video
Powerful teaching, thanks, Sir
Dear Sali, my entries in form don't display in my table. What's your suggestion regarding it ?
wao nice … make more videos 🙂
Sir, I was told to create a lab data base with query and stuff which I was stuck but after seeing your video I got some insights so far. Thanks for your explicit explanation.
The process involves migrating access tables to SharePoint. So I migrated a table in Access to SharePoint AND THEN I linked the table, then I got a live connection to SharePoint. This is a bi-direction synnc of that table. So any change in Access (any update to that linked table) will see changes sent to the same table (list) in SharePoint.
But I can work against these linked tables in off-line mode. This means that I can continue to update the tables even without network connection. When I do finally get wi-fi or some internet connection, then I can synchronize my changes to SharePoint manually by clicking on sychronise message after opening Access.
My problem is I need the data to auto-sync (both ways) and tables will update missing or changed data to SharePoint automatically.
Are there any ways to do this? Thanks!
Amazing conten… I have same conten.. You can visit my channel and subscrib…
Where is part 2?
how to download this app?
What are two ways to add more fields in a table?
Thanks Sali, you just helped me to put aside my fear of Access and saved me from VLookUp in Excell
E great explanation
When making a form how do you permanently have contact info on the bottom for every form?
Access is literally the hardest fucking basic computer class there is. I did way better a excel
Thank you. Very informative.
Yes
very helpful