Microsoft Access for Data Management
Microsoft Access is a database management system with a wide range of applications. This course is about using this system to manage your data efficiently and effectively regardless of the type of data you are dealing with.
Almost all of us deal with data, often on a daily basis. For example, in the SSC we have a database for our short course programme, a database for consultancy work and an inventory database for our IT equipment and software. We also have a great deal of experience running surveys of various sizes, and have used Microsoft Access to manage the data from these surveys. All these databases have been designed in-house and this course is a direct result of over 30 years of experience in creating such databases.
The course takes participants through the process of design and implementation of databases using MS-Access. We aim to disprove misconceptions that databases are mysterious entities and make an effor to clarify the jargon often associated with them. The course is a combination of demonstrations and practical work where the skills are acquired by 'doing'.
Techniques taught during the course can be applied to all recent versions of MS Access. The key differences between versions will be highlighted.
Who Should Attend?
Most of us regularly deal with data of one type or another; you might be in business and need to keep names and addresses of customers; you might be a supplier needing to manage stock levels and customer orders; those in education would need to keep student records; you might be a technician needing to keep track of equipment and supplies; or a researcher managing data from surveys or experiments; or you may simply wish to keep a catalogue of your ever-increasing collection of DVDs. Access can be used in all these situations. Even if you believe you don't have much data at the moment it is worthwhile considering using a database system as you are likely to find the amount of data you have increases exponentially with time and this increase is easier to deal with if you are already using a well-designed database.
How You Will Benefit
You will gain hands-on experience in designing databases and knowledge of key VBA programming techniques for ensuring data quality. You will also gain experience of developing a secure data entry system within your database for end-users.
What Do We Cover?
The course is divided into 3 one-day sessions:
Day one - Data Modelling: data concepts; database structure; E-R diagrams; relationships; table creation; primary keys; referential integrity
Day two - Data Querying: the query design grid; complex multiple criteria; queries for data checking; parameter queries; summarising data; SQL; update and append; merging data in different databases
Day three - Building the user interface: form design; sub-forms; linking forms with command buttons; VBA code for ensuring data quality using event procedures; customising your application for use as a data entry system
Practical work will be done in: Access
Note: For practical work, participants must bring their own laptop with a fully licensed version of the software.