Advanced Interactive Interfaces with Access: Building Interactive Interfaces with VBA
暫譯: 進階互動介面與 Access:使用 VBA 建立互動介面
Grimaldi, Alessandro
商品描述
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.
作者簡介(中文翻譯)
阿萊桑德羅·格里馬爾迪出生於義大利羅馬,於1982年首次接觸電腦世界。自1998年以來,他一直是一名專業的VBA開發人員。幾年來,阿萊桑德羅曾為聯合國的一個主要機構——世界糧食計劃署(WFP)提供諮詢服務,並在阿富汗、北韓、埃塞俄比亞和義大利工作。他還曾在奧地利維也納的全面禁止核試驗組織(CTBTO)工作,這也是一個聯合國機構。自2014年以來,他居住在德國法蘭克福,並在歐洲中央銀行工作了約五年。在這些地方,他開發了VBA工具,範圍從簡單的自動化工具到複雜的多用戶分佈式企業級應用程式。
近年來,阿萊桑德羅製作了幾個有關拖放和滾動時間軸的視頻,並舉辦了現場工作坊和演示,解釋這些技術。他擁有一個在線VBA商店(AlessandroGrimaldi.com/Shop),在那裡他銷售VBA教程、工作坊和工具。他還擁有一個YouTube頻道(@AlxGrim),在那裡發布與VBA相關的視頻。