Microsoft Access 2013 for Database Managers

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 15 Hours | Lec: 72 | 4.33 GB

Genre: eLearning | Language: English

This explores modern database systems while getting familiarized with utilities used to explore and explain data sets

This course explores the modern database systems while getting familiarized with utilities used to explore and explain data sets. In this course, learners will also acquire the essential skills needed to use a database, including entering data into forms and tables, running queries to search data, and producing meaningful reports.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

An overview of databases, database objects and terminology

Planning a database structure and tables

Describe the Relational Database Design Process

Understand concepts of Data Normalization

Determine Table Relationships and Designate Primary / Foreign Keys

Explore Types of queries – Select, Make Table, Append, Delete, Update

Developing Forms using Wizard and Layout views

Using Design and Layout views to create simple reports

Developing Simple Macros using Macro Builder and Code Builder