Explore chapters and articles related to this topic
Damage database for residential structures
Published in Peter J. Moss, Rajesh P. Dhakal, Progress in Mechanics of Structures and Materials, 2020
D.J. Heath, J. Corvetti, E.F. Gad, J.L. Wilson, F. Hodges
Following a review of the software available the following decisions were made: An internet based system would be appropriate using a web browser environment.Internet Explorer would be the browser supporting data entry.Microsoft Access would provide the database environment for tabulating data.The ability to export data into a versatile “csv” (text file) format.A multi level access system would be used to provide security and restrict access.
Information systems and communications
Published in Jeffrey O. Grady, System Integration, 2020
Some systems provide on-line access to document libraries as illustrated on Figure 5-6. The Applicable Document System (ADS), for example, provides legalistic tailoring for several hundred documents but the same database can be used to call the actual text of several documents that have been scanned and corrected. The operator may edit and highlight the text and store it as an in-context tailored document for a specific program. As new products come on line permitting Microsoft Windows access to dBase data (such as Microsoft Access and Foxbase 2.5), the author intends to extend this experiment into the graphical user interfaces (GUI) world.
Microsoft Access 2.0
Published in Paul W. Ross, The Handbook of Software for Engineers and Scientists, 2018
Microsoft Access 2.0 is a relational database authoring system that was designed to run under Microsoft Windows 3.1. With Access, one can create database systems that can include not only data, but also programs to compile and process those data. A database is “a comprehensive collection of related data organized for convenient access, generally in a computer” according to The Random House Dictionary of the English Language. Databases are generally used to facilitate the manipulation of data, e.g., adding, deleting, and modifying data quickly and easily. The data portion of an Access database is organized in tables of records. A classic example of a record is the individual cards of a rolodex. The table would be the rolodex itself. Other types of information often stored in a database include financial data, statistics, and experimental results.
Methodology of developing mathematical-ANN hybrid model based mill setup model for hot strip rolling
Published in International Journal for Computational Methods in Engineering Science and Mechanics, 2021
S. Rath, P. Talukdar, A. P. Singh
The mathematical models have been integrated with feed-forward ANN modules using an innovative method described in the paper. Back-propagation algorithm has been used for training of the hybrid ANN network. The second part of the model is the mill set-up model which predicts optimized roll gap set-up and speed set-up for different finishing stands of the hot strip mill. The optimization algorithm has three distinct objective functions: Maximization of mill productivity, Minimization of motor energy consumption, and Minimization of Input Temperature. The constraints of the algorithm are allowable roll force, mill torque, motor power, target finishing temperature and target strip gauge output. The model has been integrated with Siemens S7-400 PLC and ABB 800 PEC PLC-based Level-1 system using an Object Linking and Embedding (OLE) for Process Control (OPC) based communication software module. All the mill operating data are being stored in a specifically structured Microsoft-Access based database. The model successfully rolled more than 600 hot rolled coils in the mill.
How does a team’s virtuality impact knowledge transfer effectiveness among its members?: A multi-mediator-moderator model
Published in Behaviour & Information Technology, 2021
Xiaogang Chen, Darrell Carpenter, Libo Su
Many bike rental shops are located on and around the university campus. The teams were asked to develop a relational database system for one rental shop of their choice using Microsoft Access. Based on the quality of their work, they could earn up to 30% of the available credit for their respective course. Before the task was assigned, participants from MIS classes had been taught relational database design, focusing on entity-relationship diagrams and the functioning of Access. Participants from the management class were asked to visit one bike rental shop and learn the details of its business operations, such as what the procedure is for renting a bike and what particular records were kept in running the business. Such information would be needed to determine entities, attributes, and relations between entities in the database design.
Patterns of rainy weather crashes: Applying rules mining
Published in Journal of Transportation Safety & Security, 2020
Subasish Das, Anandi Dutta, Xiaoduan Sun
To identify important contributing factors for rainy weather crashes (crashes that are defined as rainy in the weather variable) in Louisiana, a large data set containing eight years of crash records (2004–2011) was obtained from the Louisiana Department of Transportation and Development (LADOTD). The data was stored as an unsorted and unmanageable format in Microsoft Access database tables. Every crash record has many variables, and the detailed information is stored in separate data tables such as crash, driver, and vehicle. Cross-table in-depth analysis would be useful to find out hidden crash patterns, and association rules mining provides promise in exploring these patterns. The data preparation task involved the following steps:Combine eight years of crash data from LADOTD police reported crashes.Merge driver and roadway condition data with the crash data by matching with the crash identification number.Prepare the rainy weather crash database by filtering rainy weather in the weather condition variable.