ExcelＶＢＡクイズ講座 中級Ⅲ Access連携

Excel VBA (macro) Access collaboration intermediate level tutorial course and quiz questions.This is the version of Excel that has been confirmed to work in this course.Excel (Windows version) 2007 to 2024 Microsoft365(Disclaimer)The Excel VBA (macro) sample will work even if Access is not installed, but since we will be using Access in the learning process, we will lecture assuming that it is installed.The final part of the intermediate course trilogy! (First step: data aggregation, second step: user form)This times theme is collaboration between Excel VBA (macro) and Access files.As case studies, "Intermediate I Data Aggregation" and "Intermediate II User Form" used an Excel list format table as a database, but in this course, we will use an Access file as a database.Finally, we will tackle research on multi-user support such as file sharing. This is the course outline.In this course, we will study the following intermediate level courses for Excel VBA (macro) and Access collaboration.(reference)It is assumed that you have already taken the following courses offered by our school in advance.・Excel VBA Course Intermediate Course I Data Collection・Excel VBA Course Intermediate Course II User Form1. DB routine processing patternAccess is often said to be difficult to understand, difficult to understand, or difficult to use.We will discuss the formalities of databases in detail in a separate chapter later.First, lets start by giving you an overview of what an Access database is by looking at "DB routine processing patterns."2. User form address book DB versionBased on the above "DB standard processing pattern", we will modify the code of "Excel VBA Course Intermediate Course II User Form Address Book" to be compatible with the DB version linked with the Access database file.3. Table creation and integrity constraintsThis article explains how to create tables using Access and the associated integrity constraints.4. Queries and SQLIntroducing commonly used queries and SQL statements in Access.5. Data aggregation DB versionBased on the above-mentioned "Query and SQL" example, we will modify the code to support the DB version linked with the Access database file.6. Multi-user support - ResearchIntroducing multi-user support using Access database files.(Disclaimer)The multi-user compatible samples introduced in this course do not reproduce all patterns, nor are they 100% confirmed to work. The operation check patterns vary widely depending on the PC environment, program specifications, and operating conditions. Please consider the examples introduced here for reference only. That is why the chapter title is "-Research." If you wish to tackle this as an actual problem, please conduct your own research using this course as a reference.