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

VBASYS塾

About this game

Excel VBA (macro) Access collaboration intermediate level quiz questions and tutorial course.

This is the version of Excel that has been confirmed to work in this course.
Excel (Windows version) Microsoft365, 2024~2007

(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 time's 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 Form

1. DB routine processing pattern
Access 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, let's 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 version
Based 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 constraints
This article explains how to create tables using Access and the associated integrity constraints.

4. Queries and SQL
Introducing commonly used queries and SQL statements in Access.

5. Data aggregation DB version
Based 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 - Research
Introducing 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.

What’s new

ホーム画面にクイズ問題の平均点を表示しました。