20 thoughts on “Microsoft Access 2013/2016”

1. lucy March 24, 2014 at 3:02 pm

   try to found your download files for access

   Reply ↓
   1. amir parmar Post authorMarch 24, 2014 at 7:19 pm

      You can find the sample files on this page http://simpletek.ca/tutorials/access2007/

      Reply ↓
   2. amir parmar Post authorMarch 24, 2014 at 7:20 pm

      And for Access 2013, I have added the sample files on that page too http://simpletek.ca/tutorials/access-2013/

      Reply ↓
2. Ravindra Patel March 25, 2014 at 11:51 am

   Excellent work which i every seen for Access sir.

   Reply ↓
3. Jones Malama May 26, 2014 at 5:43 am

   Your videos are excellent and easy to follow please keep it up.

   Reply ↓
4. Azhar September 16, 2015 at 4:08 pm

   Dear brother you are doing very good job please continue it.
   Thanks

   Reply ↓
   1. Arif November 5, 2015 at 6:56 am

      Please give me some solution
      ex. form textbox value store in a table field
      ex. calculated field in form as “net amount” store in a table field “Invoice Amount”

      Reply ↓
      1. amir parmar Post authorNovember 9, 2015 at 11:32 am

         I have given some tip in another comment. And if you have all your data, than there is not much of a need to store the Total Amount, as they can be created with calculation. So best to create the Total in Report, you don’t need that data in your table.

         Reply ↓
5. Arif Hathisingwala November 6, 2015 at 5:58 am

   Please give some solution
   I am created Invoice database
   created FORM with SubForm
   some caculation for textbox
   how to store form textbox value in main table
   ex. calculated textbox value store in table [Invoice Amount]
   subform [item amount] total store in table [Item Amount]
   Please send me Solution

   Reply ↓
   1. amir parmar Post authorNovember 9, 2015 at 11:28 am

      If the Field has calculation, than it is not possible to save the data in table, as the Control Source is filled up with the calculation. You may need to create a query and add the calculation in query.

      Reply ↓
6. Arif Hathisingwala November 9, 2015 at 7:50 am

   I am creating a form that has a unbound texbox. I would
   like the value inputted into the texbox to be saved to a
   table. The value would be a single record that would be
   replaced every time the form is accessed and the data is
   inputted into the textbox. If anyone can point me in the
   right direction or provide some sample code, I would
   appreciate it.
   Thanks
   Arif

   Reply ↓
   1. amir parmar Post authorNovember 9, 2015 at 11:27 am

      If you go to the Property of the Text box, than to Data and look in Control Source and pick the Field in the table that will hold the data.

      Reply ↓
      1. Arif Hathisingwala December 14, 2015 at 1:27 pm

         Thanks

         Reply ↓
7. Robert December 31, 2015 at 6:24 pm

   do you have a tutorial for creating a stand alone access 2013 database either compiling or runtime. your tutorials are excellent and easy to follow

   Reply ↓
   1. amir parmar Post authorJanuary 4, 2016 at 10:46 am

      Sorry don’t have a tutorial on that topic. I think Microsoft website has some documents on it.

      Reply ↓
8. Nasser Amin August 11, 2016 at 4:40 am

   I Appreciate your effort,actually I learned alot of things in Access from you and you explain professionaly…
   Please I need to know the formula in access that explain the balance like in Bank statement you will see Credit,Debit and balance…
   Regards,,

   Reply ↓
9. Ijlal Hussain January 10, 2017 at 6:09 am

   MR. Amir, wonderful efforts for educating peoples. Referring to your video on Access DvdDatabase, I am kind of confuse in understanding the actual use of relationship creation through Database Tools, Relationships. Whereas this can be done very well via Lookup. Is there specific difference between these two ways of creating relationships. Please reply. Thank You. Ijlal Hussain.

   Reply ↓
   1. amir parmar Post authorJanuary 10, 2017 at 7:00 pm

      Hi Ijlal, Both process will create the relationships. The benefit with using the Lookup wizard is that, you will get the Drop down option, that will show the records from the other table. If you create the Relationship via Database Tools, you will not get the drop down. And once you create Relationship using Lookup, you still need to go to Database Tools; and add the Check box for “Maintaining database integrity” and other options.
      Hope this helps.

      Reply ↓
10. Vinay barthwal March 14, 2018 at 8:29 am

    Hello sir,
    I m a proud student of yours uploaded tutorial..and best things is that you replied also here.
    Sir all i want to display a specific form (in ms word) and fields in ms word form is required to be fetch from access table.
    May be its wrong..but is it possible?

    Reply ↓
    1. amir parmar Post authorMarch 14, 2018 at 9:15 pm

       never done that, but here is a link that offers some VB code
       https://www.techrepublic.com/blog/microsoft-office/how-do-i-fill-word-form-fields-with-access-data/

       also see this link to see way to create User Form in Word
       https://gregmaxey.com/word_tip_pages/create_employ_userform.html

       Reply ↓