{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MS ACC_Lesson 11_DAO.pdf - 14-Aug-17 Microsoft Access 2013...

Info icon This preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
14-Aug-17 1 Microsoft Access 2013 Lesson 11: Data Access Object (DAO) 1 Introduction to Variables A small portion of memory that temporarily stores a piece of information. To declare a variable : Dim VariableName To declare some variables with Data Type : Dim VariableName1 As DataType1, VariableName2 As DataType2, Dim VariuableName3 As DataType3 2
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
14-Aug-17 2 Introduction to Variables Data Type Data Type Description ទិន្នន្័យដែលអាចផ្ទ (Range) Byte 1-byte binary data លលខចំន្ួន្គត់វិជ្ជមាន្ (0 to 255) Integer 2-byte integer លលខចំន្ួន្គត់ ( 32,768 to 32,767) Long 4-byte integer លលខចំន្ួន្គត់ ( 2,147,483,648 to 2,147,483,647) Single 4-byte floating-point number លលខចំន្ួន្ទសភាគ ( 3.402823E38 to 1.401298E 45 (negative values)) 1.401298E 45 to 3.402823E38 (positive values) 3 Introduction to Variables Data Type Data Type Description ទិន្នន្័យដែលអាចផ្ទ (Range) Double 8-byte floating-point number លលខចំន្ួន្ទសភាគ ( 1.79769313486231E308 to 4.94065645841247E 324 (negative values)) 4.94065645841247E 324 to 1.79769313486231E308 (positive values) Currency 8-byte number with fixed decimal point លលខរូបិយប័ណ្ ( 922,337,203,685,477.5808 to 922,337,203,685,477.5807) String String of characters តូរអកសរ ឬ ្្ល (Zero to approximately two billion characters) Date 8-byte date/time value កាលបរិលចេត រឺ លេលវាលា (January 1, 100 to December 31, 9999) 4
Image of page 2
14-Aug-17 3 What is Data Access Object (DAO)? Class Object មួយដែលបល្ ើតល ើ្លោយក្កុមហុន្ Microsoft កន លោលបំណ្្ល្វ ើការជាមួយ Microsoft Jet Database File ដែលជា Database File របស់ Microsoft Access 5 Enable DAO 1. ចូល VBA Code Editor Tools Preferences 2. ដសវ្រក ន្ិ្លក្ជ្ ើសលរើស Microsoft DAO 3.6 Object library OK 6 OR: Microsoft Office 15.0 Access database engine Object Library
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
14-Aug-17 4 ការលក្ប ើក្ាស់ DAO ជាមួយ Current Database Syntax : Dim dbVariableName As DAO.Database Set dbVariableName =CurrentDB() 7 ការលក្ប ើក្ាស់ DAO ជាមួយ Access Database លផ្ស្ User Interface Database (Front End) - Form, Report, Database File (Back End) - Table Front End Back End 8
Image of page 4
14-Aug-17 5 ការភា ជ ប់ Database File ដែលមិន្មាន្ Password 1. ក្បកាស់អញ្ ញតលចញេី DAO.Database Syntax : Dim dbVariableName As DAO.Database
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern