Learn Access from scratch to the point where you'll be able to work through complex databases!
What you'll learn
Create and manage databases
Build tables
Create queries
Create forms
Part V: Create reports
Requirements
None!
Description
Microsoft Access is one of the most used database management software and one with a high demand on the market. It's a perfect tool that helps you store all kinds of information for reporting, analysis, and reference. It is also an important application to understand how SQL works. If you have no knowledge whatsoever in this software, this course is for you You will be gaining all the required skills to be a complete professional in no time. It is worth noting that such courses allow you to quickly gain required skills, without having to enroll in a full semester course.This course is divided into 5 sections, and made up of 17 chapters. All the exercise files are provided with the videos so you can follow along with the instructor. Some files are also in Excel format which can easily be imported in Microsoft Access. This shows the versatility between the different software of the Microsoft Office suite.The course is divided into the following sections and chapters:Create and Manage DatabasesCreate and Modify DatabasesManage Relationships and KeysNavigate through a DatabaseProtect and Maintain DatabasesPrint and Export DataBuild TablesCreating TablesManage TablesModify FieldsCreate QueriesCreate QueriesModify QueriesCalculated FieldsCreate FormsCreate FormsConfigure ControlsFormat FormsCreate ReportsCreate ReportsReports ControlFormat Report
Overview
Section 1: Create and manage databases
Lecture 1 Chapter 1: Create and modify databases
Lecture 2 Chapter 2: Manage relationships and keys
Lecture 3 Chapter 3: Navigate through a database
Lecture 4 Chapter 4: Protect and maintain databases
Lecture 5 Chapter 5: Print and export data
Section 2: Build tables
Lecture 6 Chapter 6: Introducing Formulas and Functions
Lecture 7 Chapter 7: Manage tables
Lecture 8 Create and modify fields
Section 3: Create queries
Lecture 9 Chapter 9: Create queries
Lecture 10 Chapter 10: Modify queries
Lecture 11 Chapter 11: Create calculated fields and grouping within queries
Section 4: Create forms
Lecture 12 Chapter 12: Create forms
Lecture 13 Chapter 13: Configure form controls
Lecture 14 Chapter 14: Format forms
Section 5: Create reports
Lecture 15 Chapter 15: Create reports
Lecture 16 Chapter 16: Configure report controls
Lecture 17 Chapter 17: Format reports
People who want to learn Access and get to a very good level in no time!


Homepage

https://www.udemy.com/course/microsoft-access-from-zero-to-advanced/

Related Downloads :

{related-news}