论文部分内容阅读
为解决油田单井生产数据管理不规范、提取过程繁杂费时等问题 ,利用美国微软公司推出的新一代数据库软件MicrosoftAccess研制开发了单井数据库查询系统软件。通过建立必要的窗体及其对象 ,使得查询过程方便、快捷且可视 ;建立辅助表 ,在查询语句中添加谓词“Distinct” ,利用“Docmd”对象的“Output”方法使查询结果完全汉化 ,唯一化。数据查询结果可存为数据库、Excel等文件格式 ,也可直接切换到MicrosoftExcel环境下进行数据处理。实际应用表明 ,使用该软件提高了工作效率及数据的准确性和可信度 ,具有较高的推广价值
In order to solve the problems of non-standard production data management and complicated and time-consuming process of oilfield single well production, a single well database query system software was developed and developed by Microsoft Access, a new generation of database software developed by Microsoft Corporation of America. Through establishing the necessary form and its object, the query process is convenient, quick and visible. The auxiliary table is created, the predicate “Distinct” is added to the query, the “Output” method of the “Docmd” object is used to make the query result completely finished, Only Data query results can be saved as a database, Excel and other file formats, but also can be directly switched to the Microsoft Excel environment for data processing. Practical application shows that the use of the software to improve work efficiency and data accuracy and credibility, with a high promotional value