Microsoft Access 2016 Complete Tutorial – Access Made Easy by Sali Kaceli

Microsoft Access 2016 Complete Tutorial – Access Made Easy by Sali Kaceli

This is the complete tutorial on Microsoft Access 2016. The tutorial starts with the very basics and continues to the more advanced features on prop

Sửa vali kéo ở Hà Nội
Các phần mềm chụp ảnh đẹp
Formatou O PC? e Precisa Dos Drivers De Rede? – 3DP NET O Menor Aplicativo Para Instalar Drivers



This is the complete tutorial on Microsoft Access 2016. 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:

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
Learn how to create forms in a database in Access 2016.
Learn how customize forms in Access 2016.
Learn how to create queries in Access 2016.
Learn how to create custom queries with criteria and calculated fields.
Learn how to create reports in Access 2016
Learn how to customize reports in Access 2016.

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://ehome3s.com

Xem thêm bài viết khác: https://ehome3s.com/tong-hop/

COMMENTS

WORDPRESS: 35
  • comment-avatar

    I'm here because of COVID pandemic Quarantine. 🙂

  • comment-avatar

    The video is very helpful and is one of the best video tutorial i have ever watched

  • comment-avatar

    Excellent pace for beginners. I wanted to find the download referred to in the access course, but did not know where it was.

  • comment-avatar

    Very helpful video. easily can understand your explanation . Thank you so much.

  • comment-avatar

    At around 45 minutes it mentions Working Files–where do I get those from?

  • comment-avatar

    How can I pay you, my country is not in the list of Paypal

  • comment-avatar

    Your clear concise and perfectly paced voice make learning Access a pleasure!

  • comment-avatar

    thats just excellent , that was refreshing for me but an excellent way to do it so, i had the ms acess course in 2008 but i felt i am much mature to use and understand it by your method

  • comment-avatar
  • comment-avatar

    I've been following this tutorial from the beginning but at 33:23 when he starts creating a form, in the available fields list, there are fields that I don't understand how they were created (Field1.File Data, Field1.FileFlags etc.). Did I miss something and will the absence of these fields affect my tutorial progress?

  • comment-avatar

    Sir, I am beginner to access. In which job field access is useful?

  • comment-avatar

    Thank you Mr. Kaceli

  • comment-avatar

    Super easy to follow! Thank you so much! Now I can ace my database assignment!! <3

  • comment-avatar

    Very useful, great tutorial!

  • comment-avatar
  • comment-avatar

    Thank you! Now i realize process of Access

  • comment-avatar

    Well done Sali, thank you for sharing this fantastic resource!

  • comment-avatar

    Thank you for sharing your knowledge. I watched it because I want to learn how this software is being used. You make it so easy that is why I learned that fast. Great job! 😀

  • comment-avatar

    Why do you worry anyone is going to copy this? I can barely hear you. Get a real mic, like the Snowball.
    It gets better after one minute, the echo is gone though volume is still low.

  • comment-avatar
  • comment-avatar

    how do i download working files

  • comment-avatar

    All this tutorial is perfect for me. But I have some technical question. Also it'' s troublesome
    . So, at 00:34:16 we see fields. First field "Customer". The number "1" is in black. Is it possible to make content of this field like rest of them? Without black cursor mark or whatever its call?

  • comment-avatar

    Northwind Database is a fantastic template for testing many Access projects. I understand it is availble in some additional languages but NOT in the correct formats for Regional Use. I think many developers would love to get a Northwind with GBP currency UK telephone numbers and Address Formats (Postcode not Zip and Town/City not City. also UK accounting and trading terms. Does such a thing exist? I feel certain there will be a big demand. Where can I get to ask Microsoft for help on this?

  • comment-avatar

    Simply the best classes I had. Clear Voice with plenty of details and examples. Like Albert mentioned, I learned so much from here than I did in 3 weeks in College. Thank you very much Professor Kaceli!!!!

  • comment-avatar

    1:00:50 my bookmark

  • comment-avatar

    In ms excess only table,form,query,relationship , report genrate ?I will learn more in access.

  • comment-avatar

    Thanks for the great effort and well-explained tutorial. I tried to download the data files for this tutorial. I subscribed to your channel and also donated but still unable to download.

  • comment-avatar

    I used access a long time ago and built many databases. As my career progressed I went into Project/PMO Management and kinda lost touch with database and access concepts. I guess its an age thing. I am now doing this tutorial and its easy to understand and clearly explained.. Well done..

  • comment-avatar

    I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

  • comment-avatar

    That was very helpful! Thank you for your time Sir.

  • comment-avatar

    This saved my life big time thanks

  • comment-avatar

    Excellent tutorial.

  • comment-avatar

    it really works,Thank you !!! you are a legend

  • comment-avatar

    so helpful ,thanks a lot

  • comment-avatar

    Great and easy way of explaining the
    topic, thank you very much.

  • DISQUS: 0