Access 365 Foundations Everything you need to create a DB
What you’ll learn
You will learn what Relational Databases are and how to build one from scratch.
Learn to create tables with various properties and controls.
Understand how to create relationships between all those tables.
Learn to create queries to questions those tables and return data sets.
Learn to create forms for your users to collect all your data.
Create reports based on those queries or tables and generate PDFs.
Requirements
No Database knowledge is required for this course.
Having strong Excel skills in functions will greatly enhance your learning experience.
You must have MS Access installed on your system – subscription to O365 will be necessary.
Description
If you are a small organization or self employed and need to move beyond using Excel to hold your data, then you need MS Access 365. Access 365 is a desktop relational database that has been around for 30 years and does the job needed to hold your data. But in fact, it does more than just hold your data – you can execute complex queries to run your reports and get the data analysis you need on your organization.But it all starts with a good foundation and learning from the beginning on how to create a rock-solid database with proper relationships and referential integrity, so your tables hold correct data and not create windows and orphans.Microsoft Access 365 is a desktop database application that provides the ability to store large amounts of data and the objects within the database – Queries, Forms, Reports, and Code Modules enable the user to add or extract data easily and present the data in different formats.The term Relational Database refers to the idea that the data collected in the various tables are related to each other in one fashion or another. The database could hold information about customers and each of the table would have information about those customers like their personal info, all the transactions they have generated and all the products they purchased.Students will learn to create an entire database with Tables, Forms, Queries and Reports and build a foundation of knowledge of how databases of any kind work. Knowledge of Excel functions and the ability to problem solve will be required assets for this course. Students must also have MS Access 365 version installed on their local computer.Your InstructorRobin Solonenko
Overview
Section 1: Getting Started
Lecture 1 Coruse & Instructor Introductions
Lecture 2 Support Notes for Students
Lecture 3 Courses Resource Files & PDF Manual
Lecture 4 Contacting the Instructor
Lecture 5 Let’s Set Some Expectations
Lecture 6 PDF Manual & Video Correlation
Section 2: Introduction to Databases
Lecture 7 What is a Database?
Lecture 8 Database Objects
Lecture 9 Access Environment
Lecture 10 Basic Actions
Lecture 11 Working in Datasheet View
Lecture 12 Design View of Any Object
Lecture 13 Section 2 / Lession 1 Exercise
Section 3: Creating Access Tables
Lecture 14 Creating a Database
Lecture 15 Creating Tables & Assigning Data Types
Lecture 16 Setting Primary Key
Lecture 17 Setting Field Properties
Lecture 18 Copying / Pasting Existing Tables
Lecture 19 Section 3 / Lession 2 Exercise
Section 4: Data Normalization & Relationships
Lecture 20 What is Data Normailization
Lecture 21 Setting Table Relationships
Lecture 22 Foreign Keys & Integrity Rules
Lecture 23 Creating Relationships
Lecture 24 Section 4 / Lesson 3 Exercise
Section 5: Creating Forms to Collect Data
Lecture 25 The Basics of Forms
Lecture 26 Creating Forms w/Form Wizard
Lecture 27 Working with Controls
Lecture 28 Working with Property Sheet
Lecture 29 Modifying Form Layout
Lecture 30 Creating a Calculated Control
Lecture 31 Setting the Form Tab Order
Lecture 32 Creating a Split Form
Lecture 33 Instructions to Create the Next Forms
Lecture 34 Creating the Cars Form
Lecture 35 Creating the Tickets Form
Lecture 36 Creating the Mechanics Form
Lecture 37 Creating the Service Orders Form
Lecture 38 Section 5 / Lesson 4 Exercise
Section 6: Selecting Data with Queries
Lecture 39 Select Queries
Lecture 40 Creating a Query
Lecture 41 Creating a Multi-Table Query
Lecture 42 Adding Criteria to a Query
Lecture 43 Performing Calculations in Queries
Lecture 44 Creating a Parameter Query
Lecture 45 Adding Totals to Datasheets
Lecture 46 Section 6 / Lesson 5 Exercise
Section 7: Presenting Data with Reports
Lecture 47 Using the Report Wizard
Lecture 48 Using Controls & Report Views
Lecture 49 Report Sorting & Grouping Levels
Lecture 50 Adding Page Breaks & PDF
Lecture 51 Section 7 / Lesson 6 Exercise
Section 8: Next Steps
Lecture 52 Instructor Thankyou
Lecture 53 Access Foundations Project
Anyone who needs to create a database to hold all your data for your business.,Anyone who has outgrown using Excel to hold and collect your data.,Anyone who wants a better understanding of Relational Databases
Course Information:
Udemy | English | 5h 51m | 3.14 GB
Created by: Robin Solonenko
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com