Microsoft Access Beginner to Specialist (Intermediate) Level
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
14 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access Beginner to Specialist (Intermediate) Level to your Wishlist.

Add to Wishlist

Microsoft Access Beginner to Specialist (Intermediate) Level

Covers exams 77-730 (2016), 77-424 (2013), 77-885 (2010) and 77-605 (2007) certificates for Microsoft Access
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
14 students enrolled
Created by Phillip Burton
Last updated 6/2017
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8.5 hours on-demand video
  • 11 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create and manage a database
  • Build tables
  • Create queries
  • Create forms
  • Create reports
View Curriculum
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 PowerPoint 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 databases
  • Manage relationships and keys
  • Navigate through a database
  • Protect and maintain databases
  • Print and export data

Build tables, including:

  • Create and manage tables,
  • Manage records in tables, and
  • Create and modify fields.
Create queries, including:

  • Create and modify a query,
  • Create calculated fields and grouping within queries
Create forms and reports, including:

  • Create forms and reports,
  • Configure form and report controls, and
  • Format 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 , or
  • you 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!

Who is the target audience?
  • This course is for you if you want to develop your Microsoft Access skills.
  • This course will use the latest version of PowerPoint, 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
93 Lectures
08:43:40
+
Introduction
2 Lectures 06:30
+
Level 1, Section 1: Creating a database
6 Lectures 27:31

Including:

  • Create databases in older formats
Preview 07:28

Including:

  • Display objects in the Navigation Pane.
Let's take a look around
05:35

Opening the Northwind Database
07:27

Create a database from a template
04:44

Practice Activity Number 1
00:07

Practice Activity Number 1 - Solution
02:10
+
Level 1, Section 2: Create tables
5 Lectures 31:08

Including:

  • Add fields to tables
  • Add records
Create a table
11:43

Including:

  • Update records
Navigating tables
07:10

Including:

  • Delete records
  • Append records from external data
Copying and pasting data
08:52

Practice Activity Number 2
00:16

Practice Activity Number 2 - Solution
03:07
+
Level 1, Section 3: Creating forms, reports and queries
8 Lectures 38:48
Create a form
05:00

Other form types
05:16

Includes:

  • Change report orientation
Create a report based on the table
03:46

Including:

  • Create a blank report.
Create a report by using a wizard
04:04

Including:

  • Run a query
  • Create a select query
  • Add fields
  • Remove fields
  • Set filtering criteria
Create a query using the Query Design
10:52

Create a query by using a wizard
05:11

Practice Activity Number 3
00:16

Practice Activity Number 3 - Solution
04:23
+
Level 2, Section 1: Developing tables in the Datasheet view
8 Lectures 52:39
Find and replace data
04:44

Includes:

  • Sort records, and
  • filter data by selection
Manage records in tables
04:37

Advanced filter
10:30

Including:

  • Hide fields in tables,
  • Add total rows,
  • Rename tables,
  • Rename a field,
  • Freeze or Unfreeze fields,
  • Delete fields.
Managing tables
05:45

Including:

  • Rename a field,
  • Modify the field description,
  • Change field captions,
  • Change field sizes,
  • Change field data types,
  • Set default values
Create and modify fields
10:18

Includes:

  • Add validation rules to fields,
  • Add validation rules to records.
Add validation rules
07:38

Practice Activity Number 4
00:28

Practice Activity Number 4 - Solution
08:39
+
Level 2, Section 2: Developing tables in the design view
6 Lectures 39:57

Including:

  • Define data needs and types,
  • Changing views of objects.
Introducing the Design View, and changing the number field type
12:28

Using Input Masks
07:46

Including:

  • Configure fields to auto-increment,
  • Add, set, change or remove primary key fields,
Primary Keys and Autonumbers
06:29

Using Lookup Values
09:20

Practice Activity Number 5
00:12

Practice Activity Number 5 - Solution
03:42
+
Level 2, Section 3: Good table design
4 Lectures 24:06
Introducing Normal Forms
03:01

First Normal Form
12:22

Second Normal Form
04:52

Third Normal Form
03:51
+
Level 2, Section 4: Manage multiple tables, relationships and keys
10 Lectures 58:09

Includes:

  • Import external data into tables
Import data from Excel spreadsheets
09:00

Includes:

  • Create linked table from external sources
  • Import tables from other databases
Append data, and link data
05:40

Includes:

  • Create and modify relationships,
  • Edit references between tables.
Create relationships between tables
04:40

Including:

  • Edit references between tables
Enforce referential integrity
05:05

Including:

  • View relationships
Cascade Update Related Fields
08:41

Including:

  • Navigate to specific records
Cascade Delete Related Records
05:14

Including:

  • View relationships
Subdatasheets, and miscellaneous relationships options
05:35

Including:

  • Add table descriptions
Documenting your Database
05:11

Practice Activity Number 6
00:31

Practice Activity Number 6 - Solution
08:32
+
Level 3, Section 1: Modifying queries and grouping within queries
8 Lectures 35:51

Including:

  • Use the Show Table command,
  • Rename a query,
  • Rearrange fields,
  • Hide fields, and
  • Sort data within queries,
Modifying queries
06:08

Including:

  • Format fields within queries, and
  • Save a query.
Formatting in queries
03:26

Including:

  • Use the Total row,
  • Use Group By.
Group and summarize data
07:25

Set filtering criteria - Text
04:10

Set filtering criteria on results
06:12

Set filtering criteria on NULLs
04:34

Practice Activity Number 7
00:21

Practice Activity Number 7 - Solution
03:35
+
Level 3, Section 2: Create calculated fields and grouping
6 Lectures 25:13

Including:

  • Use the Zoom box,
  • Use Expression Builder.
Creating our first calculated field
05:10

Date/Time Functions
07:27

Math and Text Functions
04:10

Including:

  • Group data by using comparison operators,
  • Group data by using arithmetic and logical operators.
Group Data Using Operators
06:21

Practice Activity Number 8
00:09

Practice Activity Number 8 - Solution
01:56
7 More Sections
About the Instructor
Phillip Burton
4.4 Average rating
3,209 Reviews
45,380 Students
25 Courses
Over 45,000 students so far

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.