相關主題
商品描述
Explore and learn advanced techniques for working with graphical, interactive interfaces that can be built in Access.
This book starts with best practices and tips to write code using VBA, and covers how to implement them in a real-world scenario. You will learn how to create and use VBA classes. An introduction to the binary code and the "bit vector" technique is discussed, followed by the implementation of a drag-and-drop engine. You also will learn how to design a timeline, and make it scrollable.
What You Will Learn
- Write readable, easy-to-maintain code
- Add a drag-and-drop engine to an Access application
- Apply variations to the drag-and-drop technique to create different graphical effects
- Embed a scrollable timeline in an Access application, on which objects can be dynamically placed
Who This Book Is For
VBA developers
商品描述(中文翻譯)
探索並學習在 Access 中構建圖形化、互動式介面的進階技術。
本書從最佳實踐和使用 VBA 編寫代碼的技巧開始，並涵蓋如何在實際情境中實施這些技巧。您將學習如何創建和使用 VBA 類別。書中將介紹二進位碼和「位元向量」技術，接著實作一個拖放引擎。您還將學習如何設計時間軸並使其可滾動。
您將學到的內容：
- 編寫可讀且易於維護的代碼
- 為 Access 應用程式添加拖放引擎
- 對拖放技術進行變化以創建不同的圖形效果
- 在 Access 應用程式中嵌入可滾動的時間軸，並在其上動態放置物件
本書適合的讀者：
VBA 開發人員
作者簡介
Alessandro Grimaldi was born in Rome, Italy, where he first approached the computer world in 1982. He has been a professional VBA developer since 1998. For several years Alessandro consulted for the World Food Programme (WFP), a major United Nations agency for which he worked in Afghanistan, North Korea, Ethiopia, and Italy. He has also worked in Vienna, Austria for the CTBTO, another UN agency. Since 2014 he has lived in Frankfurt, Germany, and where he worked for the European Central Bank for about five years. In all these places he has developed VBA tools, ranging from simple automation tools to complex, multi-user, distributed, enterprise-level applications.
In recent years, Alessandro has produced several videos about the drag-and-drop and the scrolling timeline, and delivered live workshops and presentations explaining these techniques. He has an online VBA shop (AlessandroGrimaldi.com/Shop) where he sells VBA tutorials, workshops, and tools. He also has a YouTube channel (@AlxGrim) where he publishes VBA-related videos.
作者簡介(中文翻譯)
Alessandro Grimaldi 出生於義大利羅馬，他在1982年首次接觸電腦世界。自1998年以來，他一直是一名專業的 VBA 開發人員。幾年來，Alessandro 曾為世界糧食計畫署（WFP）提供諮詢服務，這是一個主要的聯合國機構，他在阿富汗、北韓、埃塞俄比亞和義大利工作過。他還曾在奧地利維也納的 CTBTO 工作，這是另一個聯合國機構。自2014年以來，他居住在德國法蘭克福，並在歐洲中央銀行工作了約五年。在這些地方，他開發了各種 VBA 工具，從簡單的自動化工具到複雜的多用戶分散式企業級應用程式。
近年來，Alessandro 製作了幾個有關拖放和滾動時間軸的視頻，並舉辦了現場工作坊和演講，解釋這些技術。他擁有一個線上 VBA 商店（AlessandroGrimaldi.com/Shop），在那裡他出售 VBA 教學、工作坊和工具。他還擁有一個 YouTube 頻道（@AlxGrim），在那裡發布與 VBA 相關的視頻。
