Microsoft Access Database Short Courses
|Start Date||Start Time||Duration||Cost||Course Code||Apply|
|Tuesday 3 October 2017||18:30 - 20:30||10 weekly classes||£430.00||CS1594||Enrolment Closed|
|Monday 15 January 2018||18:30 - 20:30||10 weekly classes||£430.00||CS1594||Apply Now|
|Thursday 3 May 2018||18:30 - 20:30||10 weekly classes||£430.00||CS1594||Apply Now|
Starting from the fundamentals of how to design and build databases in Microsoft Access, the Microsoft Access Database short course is a fully hands-on evening class that moves swiftly to cover tables, relationships, forms, queries, reports and macros. It ends with an introduction to modules and Access programming.
It ends with an introduction modules and Access programming.
Why choose the Microsoft Access Database short course?
Our Microsoft Access Database short course is tutored by a professional academic at the University and provides a great introduction to programming with Access.
With classes delivered weekly from our top Central London University, students can be assured of the quality and convenience of all our courses. The course allows you to continue with full-time work whilst developing your skills and knowledge.
George K. Lekeas is a visiting lecturer with the Department of Computer Science in the School of Mathematics, Computer Science & Engineering and research collaborator with the University of Athens.
He holds a PhD in Computing and conducts research in the area of Multi-Agent Systems and Web Services.
He taught extensively at all levels courses in software development methods, programming and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS) and other computing areas. He also works as a freelance Unix and Web Scripting Languages consultant.
Working knowledge of Excel is an advantage.
Applicants must be proficient in written and spoken English.
What will I learn?
- Introduction: Course overview, a quick overview of MS Access for windows. Database theory: Define a database, table, record, field, data types, key fields, indexes and object in Access.
- Creating tables I: Define the table structure, data entry.
- Creating tables II: Copying and restructuring the table design, modifying the field properties, using formats and input masks. Renaming and deleting tables.
- Importing and Exporting Data Relationships Database Management organisation: Data sorting, indexing and validation.
- Creating Forms: Creating forms from scratch, changing the field properties on the form, calculations on forms, data entry forms.
- Using the form wizards.
- Creating Queries: Introduction to the different query types. Writing Select queries using: Logical Operators: And, Or, Not and Null. Mathematical operators and calculations.
- Creating queries for: Global Delete, change and insert, Making Tables and Appending Tables.
- Creating Reports: Creating reports from scratch, Report headers and footers, calculations on reports. Using the form wizards to create mailing lists.
- Creating Advanced/complex Forms/Reports: Creating Main/ Sub-reports from scratch. Graphs in reports/forms.
- Macros: Creating and running macros.
- Modules: Creating VBA code.
- Database Administration and Security.
Teaching and Assessment
Assessment will be by completion of set exercises.The tutor will also record the student's progress.