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.3 (49 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.
952 students enrolled
$50
Take This Course
  • Lectures 104
  • Contents Video: 10 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • Access 2013

What am I going to get from this course?

  • Master Microsoft Access 2013

What is the target audience?

  • Beginners and Intermediate Users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Before We Get Started
Important - Working Files - Download These First
Preview
Article
0101 What Is Our Target
Preview
03:15
0102 Access 2013 Interface Tour
Preview
08:08
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
Section 2: Database Theory And Design
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
Section 3: Tables
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
Section 4: Queries
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
Section 5: Forms
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
Section 6: Reports
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
Section 7: Multiple Table Databases
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
Section 8: Database Normalization
0801 What Is Database Normalization
02:49
0802 Normalizing The Customer Database
09:08
Section 9: Advanced Tables
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
Section 10: Advanced Select Queries
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
Section 11: Action Queries
1101 Make A New Table From A Query
07:44
1102 Update Queries For Amending Data
08:20
1103 Appending Records To A Table
07:44
1104 The Powerful Delete Query
06:14
Section 12: Advanced Forms
1201 Adding A Subdatasheet Or Subform
04:59
1202 Creating A Form Without The Wizard
06:34

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course