SQL for Microsoft Access 2007 to 2016
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn how to write SQL code in Microsoft Access, so you can create more advanced Access queriesDescription
Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?
In this course learn how to:
- Write SQL code, using the six SELECT clauses.
- Use functions and formulas in your SELECT statements.
- Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.
- Write action queries and cross-queries.
Requirements
- Requirements
- You need to know how to use a computer, and hopefully know how to use a spreadsheet.
- You need to know the basics of how to use Microsoft Access.
- You should have MS Access 2007, 2010, 2013, 2016 or 365 installed on your computer.
SQL Server 2016 Advanced Security and Administration
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn and implement advanced skills to be a SQL Server professional This course will assist a database administrator in understanding the advanced security features that protect data within databases....
C# Database Driven WinForm Apps (step by step projects)
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Project-based Learning: how to use C# Windows Forms and Microsoft Access Database to create small database driven apps I created this course with a C# beginner in mind....
Microsoft Excel Essentials (Bookkeeping & Accounting)
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Microsoft Excel templates included. Microsoft Excel From Beginner to Professional. Microsoft Excel Tips and Tricks. In this course you will learn the basics of Microsoft Excel as quickly as possible....
Microsoft SQL Server 2016 Certification (70-764)
- 4.3
-
![]()
![]()
![]()
![]()
![]()
A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-764) exam. This exam is intended for database professionals who perform installation, maintenance, and configuration tasks....
