77-730 Microsoft Access - From Beginner To Specialist

What you'll learn
Create and manage a database
Build tables
Create queries
Create forms
Create reports
Requirements
Before beginning, you will need to know how to use a Windows computer, including a mouse.
It would be good if you have used a database or Microsoft Excel before, but this is not essential.
You should have MS Access 2007, 2010, 2013, 2016 or 365 installed on your computer.
Description
All the training you need to take (and hopefully) pass your Microsoft Office Specialist exam - and one step towards the Master certification.Most people who use Access are working at Level 1. Why not go all the way to Level 5?In this course, learn how to:Create and manage a database, including:Create and modify databasesManage relationships and keysNavigate through a databaseProtect and maintain databasesPrint and export dataBuild tables, including:Create and manage tables,Manage records in tables, andCreate and modify fields.Create queries, including:Create and modify a query,Create calculated fields and grouping within queriesCreate forms and reports, including:Create forms and reports,Configure form and report controls, andFormat forms and reports.This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Access The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Access, and this course teaches you all of them.Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.You should take this course if:you want to learn more about Microsoft Access , oryou want to learn the skills you need to become a certified Microsoft Office Specialist.Regardless whether you have Access 2007, Access 2010, Access 2013, Access 2016 or Office 365, this course will help you get to a good level, and maybe even want you to get more!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Welcome to Udemy
Lecture 3 Introduction to Udemy
Lecture 4 Do you want auto-translated subtitles in more languages?
Lecture 5 Curriculum
Lecture 6 Final Databases
Section 2: Level 1, Section 1: Creating a database
Lecture 7 Opening Microsoft Access, and Creating a blank database
Lecture 8 Let's take a look around
Lecture 9 Opening the Northwind Database
Lecture 10 Create a database from a template
Lecture 11 Practice Activity Number 1
Lecture 12 Practice Activity Number 1 - Solution
Section 3: Level 1, Section 2: Create tables
Lecture 13 Create a table
Lecture 14 Navigating tables
Lecture 15 Copying and pasting data
Lecture 16 Practice Activity Number 2
Lecture 17 Practice Activity Number 2 - Solution
Section 4: Level 1, Section 3: Creating forms, reports and queries
Lecture 18 Create a form
Lecture 19 Other form types
Lecture 20 Create a report based on the table
Lecture 21 Create a report by using a wizard
Lecture 22 Create a query using the Query Design
Lecture 23 Create a query by using a wizard
Lecture 24 Practice Activity Number 3
Lecture 25 Practice Activity Number 3 - Solution
Section 5: Level 2, Section 1: Developing tables in the Datasheet view
Lecture 26 Find and replace data
Lecture 27 Manage records in tables
Lecture 28 Advanced filter
Lecture 29 Managing tables
Lecture 30 Create and modify fields
Lecture 31 Add validation rules
Lecture 32 Practice Activity Number 4
Lecture 33 Practice Activity Number 4 - Solution
Section 6: Level 2, Section 2: Developing tables in the design view
Lecture 34 Introducing the Design View, and changing the number field type
Lecture 35 Using Input Masks
Lecture 36 Primary Keys and Autonumbers
Lecture 37 Using Lookup Values
Lecture 38 Practice Activity Number 5
Lecture 39 Practice Activity Number 5 - Solution
Section 7: Level 2, Section 3: Good table design
Lecture 40 Introducing Normal Forms
Lecture 41 First Normal Form
Lecture 42 Second Normal Form
Lecture 43 Third Normal Form
Section 8: Level 2, Section 4: Manage multiple tables, relationships and keys
Lecture 44 Import data from Excel spreadsheets
Lecture 45 Append data, and link data
Lecture 46 Create relationships between tables
Lecture 47 Enforce referential integrity
Lecture 48 Cascade Update Related Fields
Lecture 49 Cascade Delete Related Records
Lecture 50 Subdatasheets, and miscellaneous relationships options
Lecture 51 Documenting your Database
Lecture 52 Practice Activity Number 6
Lecture 53 Practice Activity Number 6 - Solution
Section 9: Level 3, Section 1: Modifying queries and grouping within queries
Lecture 54 Modifying queries
Lecture 55 Formatting in queries
Lecture 56 Group and summarize data
Lecture 57 Set filtering criteria - Text
Lecture 58 Set filtering criteria on results
Lecture 59 Set filtering criteria on NULLs
Lecture 60 Practice Activity Number 7
Lecture 61 Practice Activity Number 7 - Solution
Section 10: Level 3, Section 2: Create calculated fields and grouping
Lecture 62 Creating our first calculated field
Lecture 63 Date/Time Functions
Lecture 64 Math and Text Functions
Lecture 65 Group Data Using Operators
Lecture 66 Practice Activity Number 8
Lecture 67 Practice Activity Number 8 - Solution
Section 11: Level 3, Section 3: Create various types of queries
Lecture 68 Create a multi-table query
Lecture 69 Searching for missing information
Lecture 70 Create a parameter query
Lecture 71 Create a crosstab query
Lecture 72 Create an action query
Lecture 73 Create an append query
Lecture 74 Practice Activity Number 9
Lecture 75 Practice Activity Number 9 - Solution
Section 12: Level 4, Section 1: Create and configure forms
Lecture 76 Create a report - Recap
Lecture 77 Move form controls
Lecture 78 Add form controls
Lecture 79 Set form control properties - Data, Event and Other tabs
Lecture 80 Set form control properties - Format tab
Lecture 81 Applying table layouts
Lecture 82 Practice Activity Number 10
Lecture 83 Practice Activity Number 10 - Solution
Section 13: Level 4, Section 2: Sub-forms and data sources
Lecture 84 Add sub-forms
Lecture 85 Modify data sources
Lecture 86 Create a form from a template with application parts
Lecture 87 Create Navigation forms
Section 14: Level 4, Section 3: Format a form
Lecture 88 Modify tab order in forms
Lecture 89 Insert headers and footers
Lecture 90 Themes, sorting and print settings
Section 15: Level 5, Section 1: Create reports
Lecture 91 You already know how to do this!
Lecture 92 Practice Activity Number 11
Lecture 93 Practice Activity Number 11 - Solution
Lecture 94 Group and Sort fields
Section 16: Level 5, Section 2: Protect and maintain databases
Lecture 95 Protect and maintain databases
Lecture 96 Print and export data
Section 17: The End
Lecture 97 Thank you very much
Lecture 98 Bonus Lecture
This course is for you if you want to develop your Microsoft Access skills.,This course will use the latest version of Access, but is ideal for you if you use any modern version - Access 2007, 2010, 2013, 2016 or 365.,This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.,This course is for you if you want to become certified in Microsoft Access, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.,You will cover the content tested in Microsoft Office Specialist Exams 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core),This course may not be for you if you want to learn Microsoft Access for Macintosh computers, or if you already have advanced knowledge of Access.


Homepage

https://www.udemy.com/course/microsoft-access-beginner-to-specialist-intermediate-level/

77-730 Microsoft Access - From Beginner To Specialist Fast Download
77-730 Microsoft Access - From Beginner To Specialist Full Download