登录
首页 » Others » VBA:Excel员工管理系统

VBA:Excel员工管理系统

于 2019-10-13 发布
0 244
下载积分: 1 下载次数: 2

代码说明:

本示例主要实现利用Excel操作Access数据库功能,包含以下功能:一、向数据库中新添数据;二、修改数据库中数据;三、删除数据库中数据;四、高级查询数据库中数据;(包含精确、模糊查询,可选择显示字段)五、批量操作数据库;六、采用在Excel表的导航栏中增加管理菜单的方式来实现操作功能;使用方法:1、Info.xls文件与Info.mdb文件在同一文件夹下;2、打开Info.xls文件后选择“启用宏”,如果没有该提示,请查看Excel->工具->宏->安全性  里的设置;3、正确启用宏之后,在Excel表的顶部菜单上会增加一个“信息管理菜单”的新菜单,具体操作在该菜单中实现; 本示例由黄云原创,仅供大家学习研究使用,在编写VBA时黄云尽量采用注释的方法来描述各部分作用,以期大家能够看懂。转载请保留宏中的注释信息。

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • 基于蒙特卡罗法的二维随机裂隙模拟Matlab
    基于蒙特卡罗法的二维随机裂隙Matlab程序,需要输入参数。
    2020-06-26下载
    积分:1
  • 【完整版】计算机考研408参考教材pdf
    内含操作系统、计算机组成原理、计算机网络、数据结构考研参考教材pdf,以及相应科目的习题解析或辅导书 【文件目录】 408教材 ├── 操作系统 │   ├── 计算机操作系统(第3版)汤子瀛.pdf │   └── 操作系统考研辅导教程.pdf ├── 数据结构 │   ├── 数据结构  C语言版.第2版.严蔚敏.pdf │   ├── 数据结构习题集答案(C语言版严蔚敏).pdf │   └── 算法与数据结构考研试题精析.第3版.完整版.pdf ├── 计算机网络 │   ├── 计算机网络.第五版.谢希仁.pdf │   └── 计算机网络第7版谢希仁.pdf └── 计算机组成原理     ├── 计算机组成原理.第二版.唐朔飞.pdf     └── 计算机组成原理学习指导与习题解答.第2版.唐朔飞.pdf 4 directories, 9 files
    2021-07-03 00:31:14下载
    积分:1
  • Building Trading Bots Using Java [2016]
    Building Trading Bots Using JavaEnglish | 6 Jan. 2017 | ISBN: 1484225198 | 300 Pages | PDF | 6.22 MBBuild an automated currency trading bot from scratch with java. In this book, you will learn about the nitty-gritty of automated trading and have a closer look at Java, the Spring Framework, event-Building Trading Bots Using Javahekhar VarshneyGrangesSwitzerlandISBN13(pbk):978-1-4842-2519-6ISBN-13(electronic): 978-1-4842-2520-2DOI10.1007/978-1-4842-2520-2Library of Congress Control Number: 2016961228Copyright o 2016 by Shekhar VarshneyThis work is subject to copyright All rights are reserved by the Publisher, whether the wholeor part of the material is concerned, specifically the rights of translation, reprinting, reuse ofillustrations, recitation, broadcasting, reproduction on microfilms or in any other physicalway, and transmission or information storage and retrieval, electronic adaptation, computersoftware, or by similar or dissimilar methodology now known or hereafter developedTrademarked names, logos, and images may appear in this book. Rather than use a trademarksymbol with every occurrence of a trademarked name, logo, or image we use the names, logos,nd images only in an editorial fashion and to the benefit of the trademark owner, with nointention of infringement of the trademarkThe use in this publication of trade names, trademarks, service marks, and similar terms, even ifthey are not identified as such, is not to be taken as an expression of opinion as to whetheror notthey are subject to proprietary rightsWhile the advice and information in this book are believed to be true and accurate at thedate of publication, neither the authors nor the editors nor the publisher can accept any legalresponsibility for any errors or omissions that may be made. The publisher makes no warranty,express or implied, with respect to the material contained hereinManaging Director: Welmoed SpahrLead Editor: Steve AnglinEditorial Board: Steve Anglin, Pramila Balan, Laura Berendson, Aaron Black, Louise Corrigan,Jonathan gennick, Robert Hutchinson, Celestin Suresh John, Nikhil KarkalJames Markham, Susan McDermott, Matthew Moodie, Natalie Pao, Gwenan SpearingCoordinating Editor: Mark PowersCopy Editor: Kezia EndsleyCompositor: SPi GlobalIndexer: SPi GlobaArtist: SPi GlobalDistributed to the book trade worldwide by Springer Science+ Business Media New York,233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax(201)348-4505e-mailorders-ny@springer-sbm.comorvisitwww.springeronline.com.ApressMedia,Llcisa California LlC and the sole member(owner) is Springer Science Business Media FinanceInc(SSBM Finance Inc). SSBM Finance Inc is a Delaware corporationForinformationontranslationspleasee-mailrights@apress.comorvisitwww.apress.comApress and friends of ed books may be purchased in bulk for academic, corporate, or promotionaluse eBook versions and licenses are also available for most titles For more information referenceourSpecialbUlkSales-ebookLicensingwebpageatwww.apress.com/bulk-salesAny source code or other supplementary materials referenced by the author in this text areavailabletoreadersatwww.apress.com.Fordetailedinformationabouthowtolocateyourbookssourcecodegotowww.apress.com/source-code/.ReaderscanalsoaccesssourcecodeatSpringerlink in the Supplementary Material section for each chapter.Printed on acid-free paperedicated to the angels in my lifemy mother, my wife Preshita, and my two daughters Mihika and anyaLast but not the least, my college professor, Dr. Rajat Moona,who sowed the seeds of computer programming in my dnaContents at a glanceAbout the authorChapter 1: Introduction to Trading Bota.Chapter 2: Account Management27Chapter 3: Tradeable Instruments47Chapter 4: Event Streaming: Market Data EventsChapter 5: Historic Instrument Market Data aeEERaar75Chapter 6: Placing Orders and trades97Chapter 7: Event Streaming: Trade/Order/Account Events159Chapter 8: Integration with Twitter aamna■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■175Chapter 9: Implementing Strategies.am.203Chapter 10: Heartbeating ammmmmmmmmmmn 219Chapter 11: E-Mail Notifications ammmmatmmammmmmmmnmamman 231Chapter 12: Configuration, Deployment, and Running the Bot 243Chapter 13: Unit Testing■■■■■■■■■■■■口■■■■■■■■■■■■■■■■■■■口■■■■■■■■■■■■■■■■■■口■■■■■263Index…277ContentsAbout the author,i币Chapter 1: Introduction to Trading Bot m mmmemmIRD■■■■■■■■■■■■■■■■■■■■■■■■■What Is a Trading Bot?Why do We need a trading bot?...3The capabilities of the Trading BotDesign goalsCode organization and software Stack Used .OANDA REST API as Reference Implementation.m....ammann. 8Opening an oanda practice Account80 ANDA JS0 N Keys…………Constructor Dependencies for OANDA Implementations15Event-Driven architectureG0 ogle eventBus…18Provider helper Interface20Trading Config class.........mmonann......mtnonnn.......tnn 22Obtaining the Source Code.aaeeaaaee... 24Try It Yourself section..aaaaaa.. 24Chapter 2: Account Managementa27Account provider interface31A Concrete Implementation for AccountDataProvider32Encapsulating Everything Behind a Generic AccountlnfoService37Try It yourself43VIlCONTENTSChapter 3: Tradeable Instruments47InstrumentA Concrete Implementation for InstrumentDataProvider52Encapsulating Everything Behind a Generic Instrumentservice56Try It yourself58Chapter 4: Event Streaming: Market Data Events mmmmmmmmmm. 61Streaming Market Data Interface.A Concrete Implementation for MarketData StreamingService .m..63Downstream Market data event disseminationMarketEventcallback……69Try It Yourself,…70Chapter 5: Historic Instrument Market Data mmmmmmmm 75How to read a candlestick75Enum Defining the Candlestick Granularity76Define pojo to hold candlestick information77Historical Data Provider Interface79A Concrete Implementation for HistoricMarketDataProvidern81Discussion An Alternate Database Implementation85Candlesticks for Moving Average Calculations....88MovingAverage calculation Service89Try lt YourselfChapter 6: Placing Orders and Trades■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■97Order pojo definition98Order Management provider Interface101A Concrete Implementation for Order ManagementProvider,103A Simple orderInfoService,115CONTENTSValidating Orders Before Execution: PreOrderValidationService... 116Putting It All Together in an OrderExecution Service .mmmm... 121Trade pojo definition124Trade Management provider Interface127A Concrete Implementation for TradeManagementProvider129Encapsulating Read Operations Behind TradelnfoService.....m. 136Try It yourself144Chapter 7: Event Streaming: Trade/order/Account Events m 159Streaming Event Interface161A Concrete Implementation for Events StreamingService162Try It Yourself171Chapter 8: Integration with Twitter■■■■■■■■■■■■■■■■■■■■175Creating a Twitter Application175Spring Social180Using and Configuring Spring Social180Harvesting FX Tweets181Tweetharvester Interface wmmm. 185XTWeethandler Interface,,,………AbstractFxtweethandler base class186User-Specific TweetHandlersTry lt Yourself.Chapter 9: Implementing Strategies.aa203Copy Twitter Strategy204Fade the Move Strategy210Try It Yourself214CONTENTSChapter 10: Heartbeating ammammmmmmmmmmmmmmm 219HeartBeatPayload. ..m......m. 219Streaming the Heartbeat Interface220A Concrete Implementation for HeartBeatstreamingService221HeartBeatcallback Interface223DefaultheartBeatservice223Try It Yourself226Chapter 11: E-Mail notifications n231Notification Design.EmailPayLoad poJoEmailContentgenerator interface……232Sample Implementations.EventEmailNotifier service mm...m. 235Try It Yourself.237Chapter 12: Configuration, Deployment, and running the bot m 243Configuring the Trading Bot243Core Beans configuration244Twitter-Related Beans Configuration.....................247Provider Beans Configuration248Strategies configuration…254Services Configuration254Building the Bot...,,,,,…,,……256Running the bot.....,,……259CONTENTSChapter 13: Unit Testinga263Using Mockito as a Mocking Framework.Mocking Http iNteraction..............m....................e........................ 264Mocking Streams.The versatile verify Mockit0…....,.,,…271Mocking Twitter Interaction .EclEmma Code Coverage Tool for Eclipse ide.nDDDDDDDDDm274Index■■■■■■■■■■■■■■■■■■■口En277
    2020-12-07下载
    积分:1
  • 汽车仿真之电池模型-适合新手入门.zip
    【实例简介】进行整车仿真时电池的电压和SOC是十分重要的考虑因素,虽然电池的simulink建模比较简单,大多数都是基于查表的算法,但是电池BMS中能够准确的计算SOC却是一个难点,因此从建模开始慢慢的学习很有必要。 结合网址学习https://blog.csdn.net/qq_33125039/article/details/89299584
    2021-11-24 00:46:35下载
    积分:1
  • 卡尔曼SOC算法源代码
    基于卡尔曼的电池SOC算法源代码实现过程,可以自由改写。
    2020-11-28下载
    积分:1
  • C#窗体三种方法生成二维码并打印的小
    利用三种方式实现生成二维码,并且打印的功能
    2020-12-04下载
    积分:1
  • C++开发的OPENGL立方体,支持鼠标拖拽.rar
    【实例简介】课堂作业,C++开发的OPENGL立方体,有光照,支持鼠标拖拽和键盘按键响应,希望对大家有帮助
    2021-12-10 00:36:19下载
    积分:1
  • C#winform库存管理系统
    使用C#语言,VS2012+SqlServer2008R2开发的一款数据库管理软件,适合C#winform入门者学习,内容主要是数据库的操作以及一些常用控件的使用,winform多窗口切换等等。压缩包内容有VS文件和数据库备份。
    2020-07-02下载
    积分:1
  • verilog写的数字时钟、万年历、闹钟
    数字钟要求显示时间、日期、闹钟设定时间。利用切换按键进行年月日、时间、闹钟定时操作,三种状态均可用增减两个按键进行调整,对于选中的数码管调整位,通过闪烁表示已经选中,例如:首先切换至日期,选中表示“年”的数码管,那么选中的位进行0.5秒的闪烁表示选中,其次可通过增减按键进行数字的增减。另外在按键消抖后,每次按键按下,蜂鸣器响表示已经按下;设定的闹钟到时候,按下任何按键均停止蜂鸣器,若没有按键按下,蜂鸣器长响至1min时长后,自动停止
    2020-11-28下载
    积分:1
  • 实验 CCS的使用与汇语言序设计入门
    嘉应电子信息技术学院自动化专业实验指导书
    2020-11-30下载
    积分:1
  • 696516资源总数
  • 106409会员总数
  • 8今日下载