Introduction to Relational Databases with Microsoft Access, VBA and SQL offered by Oxford University
- Public University
1 Campus- Estd. 1096
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Overview
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
Developing the logic to analyse relationships in a relational exercise or situation
Duration | 2 months |
Total fee | ₹21,000 |
Mode of learning | Online |
Course Level | UG Certificate |
Introduction to Relational Databases with Microsoft Access, VBA and SQL
Table of content
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Highlights
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
- Earn a certificate of completion from Oxford university
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Course details
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
Skills you will learn
What are the course deliverables?
- To introduce and develop the concept of relational database systems
- To introduce database design principles within the framework of Microsoft Access, using tables, queries, forms, and reports
- To introduce and develop Visual Basic for Applications (VBA) and Structured Query Language (SQL) programming skills
- Development of knowledge and understanding of relational database systems
- Development of various skills, including SQL and VBA programming
More about this course
- This practical course introduces relationships - why they are needed and how they are designed and created - and develops techniques required for relational design
- These techniques include creating suitable tables for storing and linking data, and developing suitable user interfaces for entering and accessing data; the latter requires some Access programming
- Access contains two programming languages - Visual Basic for Applications (VBA) and Structured Query Language (SQL)
- SQL's commands query data whilst VBA is used for macro and module programming; both enhance forms (used mainly for data input) and reports (for data output). Combining VBA and SQL is the most efficient way to write Access programs
- During the course we will consider and develop a multi-table application, from design of tables and relationships to design of user interface forms for input; and forms, queries, and reports for data output
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Curriculum
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
The basic concepts of a relational database
Defining and designing table objects for a relational database system
Defining relationships - use of key fields
Different types of relationships - one to one; one to many
Design rules, data integrity and validation
Building a practical relational database system with Microsoft Access
The user interface: creating multi-table queries; forms for data input; and 'smart' forms and reports for data output
An introduction to VBA and SQL
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Faculty details
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
Ms Judith A Harley
Judith Harley, MA, is a physics graduate and freelance computer consultant who advises on, and designs, commercial and private database, spreadsheet, and Visual Basic applications. She has taught computing courses at Oxford University for over 20 years.
Other courses offered by Oxford University
3 years
6 years
3 years
View Other 607 Courses
Study in UKUniversities in UKUniversities in OxfordOxford UniversityIntroduction to Relational Databases with Microsoft Access, VBA and SQLIntroduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Popular & recent articles
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
View more articles
Introduction to Relational Databases with Microsoft Access, VBA and SQL at Oxford University Contact Information
Introduction to Relational Databases with Microsoft Access, VBA and SQL
at Oxford University
Address
University Offices, Wellington Square, Oxford OX1 2JD, United Kingdom
Oxford ( Oxfordshire)
Phone
Go to College Website ->