Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Access 2013 Advanced
Take control of your data by learning advanced features of database design.Preview the first lesson free — get full access to all 36 lessons.
Advanced Provider : Rafiq Wayani 6 chapters · 36 Lessons · 3h 31m in Arabic, English, Spanish
Course Description
Discover the advanced features of Access 2013. Utilize Access for more than just desktop databases. Master the advanced features of Access to become more organized while storing company data. Learn to manage browser based applications, templates, tables and more.
What You'll Learn
- Build and manage table relationships, including referential integrity and data types between tables
- Design advanced queries using Query Design View, logical operators, parameter queries, and action queries
- Import data and link tables from external sources and other databases
- Create tables from templates and application parts
- Design and format forms, set tab order, and build subforms
- Use Access for browser-based applications beyond desktop databases
Key Takeaways
- The course covers the advanced features of Access 2013, extending its use beyond basic desktop databases.
- It teaches relationships between tables, referential integrity, and how data types relate to those relationships.
- It addresses advanced query construction with design view, logical operators, parameter queries, and action queries.
- It explains importing and linking data from external sources and other databases, and building tables from templates and application parts.
- It shows how to create, format, and modify forms and subforms, including setting tab order.
Frequently Asked Questions
What does this course cover?
It covers the advanced features of Access 2013, including managing browser-based applications, templates, tables, relationships, referential integrity, advanced queries, importing and linking data, and forms.
Who is this course for?
It is aimed at learners who want to master the advanced features of Access 2013 to stay organized while storing company data and to use Access for more than just desktop databases.
What skills will I gain from this course?
You will develop skills in Microsoft Access, Access query languages, advanced Access content systems, basic direct access methods, data access, and Microsoft Data Access Components.
What topics are taught in the lessons?
Lessons span table relationships and referential integrity, data types and relationships, query design view, logical operators, parameter and action queries, importing and linking data, tables from templates and application parts, and designing, formatting, and altering forms and subforms.
