Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access – Part 1 of 2

Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access – Part 1 of 2

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 p

How to download and install Microsoft Office 2010 for free without product keys.
Trung tâm sửa chữa Laptop uy tín
Link download và hướng dẫn cài đặt bộ Office 2003



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

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

COMMENTS

WORDPRESS: 47
  • comment-avatar

    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.

  • comment-avatar

    TOLONG Subscribe balik .. amanah

  • comment-avatar

    that you for this information

  • comment-avatar
  • comment-avatar

    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!

  • comment-avatar

    Best spending of money for the last few months. I paid almost nothing and received such a nice essay on myeasypaper.com❤️❤️❤️

  • comment-avatar

    KLEENCLEFF on iG unlocked my non spendable bitcoin successfully…

  • comment-avatar
  • comment-avatar
  • comment-avatar
  • comment-avatar

    Powerful teaching, thanks, Sir

  • comment-avatar

    Dear Sali, my entries in form don't display in my table. What's your suggestion regarding it ?

  • comment-avatar

    wao nice … make more videos 🙂

  • comment-avatar

    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.

  • comment-avatar

    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!

  • comment-avatar

    Amazing conten… I have same conten.. You can visit my channel and subscrib…

  • comment-avatar
  • comment-avatar

    how to download this app?

  • comment-avatar

    What are two ways to add more fields in a table?

  • comment-avatar

    Thanks Sali, you just helped me to put aside my fear of Access and saved me from VLookUp in Excell

  • comment-avatar

    E great explanation

  • comment-avatar

    When making a form how do you permanently have contact info on the bottom for every form?

  • comment-avatar

    Access is literally the hardest fucking basic computer class there is. I did way better a excel

  • comment-avatar
  • comment-avatar
  • comment-avatar

    very helpful

  • comment-avatar

    i can't get to the work file. When i click on the link down a web page appears telling me to log in. Pls help

  • comment-avatar

    Easy to understand and slow enough to follow along. Thanks! You've made learning Access much easier than I thought it could be.

  • comment-avatar

    Good morning. How do you do. I hope you are ok with your family. I like your tutorial video for Microsoft Access. I highly requested you make tutorial video for stock control. Example stock table, Customer table and Suppliers table from this three table how control minimum stock level when issue material for Customer automatic reduce from stock and when receive material from Suppliers automatic add stock. Please make tutorial video for this.

  • comment-avatar

    Your tutorial was extremely helpful and I have reviewed several instructional videos prior to yours. I do have a question that I can't seem to find an answer for…..I have a spreadsheet that I'm importing into access that requires two additional columns added. The columns will be used to add a formula. Question: how do you add the column so that it does not disappear when running saved imports? I need these columns to appear in the final report that will be exported. Every time I run the saved imports it overrides the table. Any help is appreciated. Thank you

  • comment-avatar

    Thank you Mr. Kaceli for your thorough yet simple to follow tutorial. You are an awesome teacher. Thank you for sharing. Never used Access and find myself having to get a quick handle on it as I go back out in to the work place. You have given me the confidence I needed, by making what I thought was going to be a mind boggling experience into a easy to understand one. Thank you so very much. Shalom

  • comment-avatar

    Who's watching this because they have an ICT test

  • comment-avatar

    Brilliant lecture. You totally demystify Access. Thank you.

  • comment-avatar

    I have tried importing the text file and it couldn't be done. I did everything you did but I always get an error message and a notice that the table couldn't be transferred. What could be wrong?

  • comment-avatar

    Great video! Really helpful.

  • comment-avatar
  • comment-avatar

    Great tutorial Sir. This was very helpful . Than you so much.

  • comment-avatar
  • comment-avatar

    thank you so much sir

  • comment-avatar

    How do i call on a database and deploy ALL the information stored? Say when i pull up a name, it also gonna automatically deploy all the info that was stored, e.g: name, address and cell number?

  • comment-avatar
  • comment-avatar

    When it comes to Primary key, can I have 2 of them? My situation requires field#1 to be able to repeat if it has different value in field#2 (IE: ModeA Version 1, ModelA Version 2)

  • comment-avatar

    Hi. Can you please explain PeopleSoft idea and give quick examples? Thank you.

  • comment-avatar

    1:03:30 Defining the relationships

  • comment-avatar

    Thank you so much for sharing your knowledge Mr. Kaceli, easy and understandable.

  • comment-avatar

    super useful!!!thank you so much!!

  • comment-avatar

    letter R: Am I a joke to you?

    Haha.. thanks for the video.

  • DISQUS: 1