Microsoft Access 2013 Tutorial -A Definitive Guide To Access
4.7 (78 ratings)
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.
1,042 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2013 Tutorial -A Definitive Guide To Access to your Wishlist.

Add to Wishlist

Microsoft Access 2013 Tutorial -A Definitive Guide To Access

Master Access 2013. A comprehensive guide from Infinite Skills that shows how to get the most from Access 2013
4.7 (78 ratings)
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.
1,042 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master Microsoft Access 2013
View Curriculum
Requirements
  • Access 2013
Description

Master Microsoft Access 2013 quickly with this practical hands-on 10 hour course - A comprehensive resource for users of all levels

This Microsoft Access 2013 training course from Infinite Skills teaches you how to use Access to create a database and build an interface to retrieve and report on your data. This course is designed for the absolute beginner; no prior database design or Microsoft Access experience is necessary in order to get the most out of this video tutorial.


Starting with a tour of the interface, this computer based training video will show you how to design and create a table, build queries, and comprehensively demonstrates the creation, and functions, of forms and reports. As you move through the video tutorial, the course covers other topics such as; how to create advanced forms, customizing your reports, and building action queries. Finally, he will take you through the process of creating your own custom web app with Access 2013.

By the completion of this training course, you will be capable of creating databases as well as reports and forms in Microsoft Access 2013, and you will have in-depth knowledge of the tools and functions available to you in this software. Working files are included, allowing you to follow along with the author throughout the lessons.

Who is the target audience?
  • Beginners and Intermediate Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
104 Lectures
09:59:43
+
Before We Get Started
9 Lectures 35:34



0103 Managing The Navigation Pane
05:52

0104 Customize The Quick Access Toolbar
04:46

0105 Setting And Using A Trusted Location
03:18

0106 Make A Choice From Overlapping Or Tabbed Windows
04:17

0107 What Is A Custom Web App
03:35

0108 Using The Working Files
02:22
+
Database Theory And Design
4 Lectures 19:55
0201 What Is A Database?
04:23

0202 Why Do We Need A Relational Database?
06:03

0203 Create A Database Using Database Templates
05:49

0204 Creating Your First Database
03:40
+
Tables
13 Lectures 01:22:41
0301 Data Types Explained
03:00

0302 Why Do We Need A Primary Key
04:58

0303 Design And Then Create Tables
07:59

0304 Editing The Common Field Properties
07:48

0305 Field Properties Unique To Date/Time Data Type
05:01

0306 The Field Size Property
05:29

0307 Using The Lookup Wizard On A Field
06:50

0308 Safeguard Data Entry With Input Masks
09:28

0309 Safeguard Data Using Validation Rules
05:28

0310 Using The Calculated Field Type
04:41

0311 Enter, Delete, And Edit Data In Tables
09:06

0312 Finding And Replacing Data In A Table
06:48

0313 Sorting And Filtering Data
06:05
+
Queries
16 Lectures 01:35:06
0401 Exploring Queries
02:35

0402 Creating, Saving, And Running A Select Query
06:44

0403 Sorting Data Within Queries
05:21

0404 Filtering Text Fields
06:09

0405 Operators For Numeric Filtering
05:57

0406 Querying Date/Time Fields
07:00

0407 Use Of Wildcards In Criteria
06:19

0408 Locating Empty Fields: Is Null
03:30

0409 Multiple Criteria On The Same Fields: Or
04:48

0410 Multiple Criteria On Different Fields: And
06:13

0411 Why Do I Need SQL View?
06:35

0412 Add Calculating Fields To A Query
09:00

0413 Using Text Fields In Calculated Fields
05:10

0414 Calculated Fields Based On Date/Time Fields
07:02

0415 Calculating Age With A Query
05:57

0416 Producing Totals In Access
06:46
+
Forms
12 Lectures 01:07:53
0501 Using The Wizard To Create A Form
06:20

0502 The Super Quick Form
03:41

0503 Viewing, Editing, And Deleting Records
05:22

0504 Adding Records Through Forms
05:16

0505 Searching For Records
04:25

0506 Sorting And Filtering Records
05:56

0507 Layout And Design View Explained
05:54

0508 Adding Colour To Forms
06:20

0509 Adding Fields And Controlling Alignment And Spacing
06:52

0510 Controlling Tab Order Of Added Fields
04:22

0511 Add Images To Forms
04:31

0512 Adding Calculated Fields
08:54
+
Reports
5 Lectures 30:52
0601 Creating A Report Using The Wizard
07:02

0602 Grouping Within Wizard Reports
06:29

0603 A Report In A Hurry: Quick Report
04:31

0604 Editing The Layout Of A Wizard Generated Report
07:34

0605 Print Or Convert A Report To PDF
05:16
+
Multiple Table Databases
8 Lectures 52:36
0701 Designing A Multi-Table Database
09:41

0702 Relationships Between Tables
03:10

0703 Creating Relationships In Access
06:36

0704 Why Do I Need Referential Integrity?
06:55

0705 The Subdatasheet Tool
04:38

0706 Queries With Multiple Tables
06:20

0707 More Than One Table In A Form
07:48

0708 Reports On Multiple Tables
07:28
+
Database Normalization
2 Lectures 11:57
0801 What Is Database Normalization
02:49

0802 Normalizing The Customer Database
09:08
+
Advanced Tables
8 Lectures 46:17
0901 Using Lookups In Data Tables
08:28

0902 Converting Access Databases Between Versions
04:55

0903 Introduction To Indexing Fields
08:32

0904 Using More Than One Field As The Primary Key
04:33

0905 Creating And Printing Relationship Reports
04:18

0906 Importing Or Linking Data Into Access From Access
04:33

0907 Importing And Linking Excel Data
06:35

0908 Importing Data From Text Files
04:23
+
Advanced Select Queries
5 Lectures 27:35
1001 Using More Than One Table In A Query
07:01

1002 Changing The Join Type Of Links In Queries
03:53

1003 Watch Out For Cartesian Or Cross Join
03:59

1004 Using Parameters In Queries
06:12

1005 The Crosstab Query
06:30
5 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
46,783 Reviews
735,475 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.