Microsoft Office 2013: 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.
19 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office 2013: Access to your Wishlist.

Add to Wishlist

Microsoft Office 2013: Access

Become an Expert
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.
19 students enrolled
Last updated 1/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will prepare you to pass the exam Microsoft Office 2013 - Access.
  • Passing this exam validates a candidate’s ability to demonstrate the correct application of the principal features of Access 2013.
View Curriculum
Requirements
  • Fundamental understanding of the Access 2013 environment
Description

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

Microsoft Office 2013 is a version of Microsoft Office, a productivity suite for Microsoft Windows.

Our MOS Access 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Access 2013 Exam 77-424, you achieve Microsoft Certified Application Specialist (MOS) status in Access 2013.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

Who is the target audience?
  • IT Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
124 Lectures
07:38:52
+
Access 2013
1 Lecture 01:07
+
Module 1
34 Lectures 02:17:56
Section 1-1 - Creating Databases
00:12

Creating New Databases
04:15


Create Databases In Older Formats
03:37

Section 1-2 - Creating Tables
00:21

Create New Tables
06:30

Import External Data Into Tables
09:49

Create Linked Tables From External Sources
04:39

Import Tables From Other Database
03:47

Create Tables From Templates And Application Parts
03:42


Hide Fields In Tables
03:28

Change Data Formats
04:40

Add Total Rows
04:08

Add Table Descriptions
03:48

Rename Tables
04:46

Section 1-4 - Manage Records
00:21

Update Records
03:04

Add New Records
03:03

Delete Records
03:04

Append Records From External Data
03:13

Find And Replace Data
04:19

Sort Records
04:38


Section 1-5 - Create And Modify Fields
00:33

Add Fields To Tables
04:42

Add A Validation Rules To Fields
08:22

Change Field Captions
05:37

Change Field Sizes
07:05

Change Field Data Types
05:14


Set Default Values
03:48

Use Input Masks
07:13

Delete Fields
03:51
+
Module 2
20 Lectures 01:12:21
Section 2-1 - Create A Query
00:22

Run Queries
11:28

Create Crosstab Queries
04:18


Create Action Queries
04:30

Create Multi Table Queries
03:52

Save Queries And Delete Queries
03:41

Section 2-2 - Modify A Query
00:19

Rename Queries
02:50

Add New Fields
02:45

Remove Fields
03:34

Hide Fields
03:03

Sort Data Within Queries
04:16

Format Fields Within Queries
03:10


Add Calculated Fields
04:30

Add Conditional Logic
04:15

Group And Summarize Data
04:58

Use Comparison Operators
03:36

Use Basic Operators
03:22
+
Module 3
21 Lectures 01:27:51
Section 3-1 - Create A Form
00:14

Create New Forms
09:18

Create Forms With Application Parts
03:16

Save And Delete Forms
04:02

Section 3-2 - Set Form Controls
00:21

Move Form Controls
06:27


Modify Data Sources
06:37

Remove Form Controls
02:21

Set Form Control Properties
06:26

Manage Labels
06:17

Section 3-3 - Format A Form
00:30

Modify Tab Order In Forms And Auto-Order Forms
06:57

Format Print Layouts
04:44

Sort Records
03:49

Apply Themes
02:13

Change Margins
04:22


Insert Headers And Footers
03:58

Insert Images
03:20

Modify Existing Forms
03:50
+
Module 4
22 Lectures 01:16:07
Section 4-1 - Create A Report
00:14

Create New Reports
06:16


Delete Reports
02:27

Section 4-2 - Set Report Controls
00:19

Group Data By Fields
04:06

Sort Data
02:06

Add Sub-Forms
06:05

Modify Data Sources
05:42

Add Report Controls
04:52

Manage Labels
04:26


Format Reports Into Multiple Columns
04:48

Add Calculated Fields
02:54

Set Margins
03:41

Add Backgrounds
02:51

Change Report Orientation
03:35

Change Sort Order
03:04

Insert Headers And Footers
01:37

Insert Images & Insert Page Numbers
05:39

Apply Themes
02:21

Modify Existing Reports
04:09
+
Module 5
26 Lectures 01:23:30

Create And Modify Relationships & View Relationships
08:41

Set Primary Key Fields
04:12

Set Foreign Keys
02:28

Enforce Referential Integrity
03:28

Section 5-2 - Navigate Through A Database
00:17

Navigate To Specific Records
03:27

Set A Form As The Startup Option
02:52


Set Navigation Options
04:33

Change Views
06:23

Section 5-3 - Protect And Maintain A Database
00:21

Compact Databases & Repair Databases
04:46

Back Up Databases
03:51

Split Databases
03:49

Encrypt Databases With A Password
03:17

Merge Databases
02:37

Recover Data From Backups
03:53

Section 5-4 - Print And Export A Database
00:20

Print Reports
02:58

Print Records
01:57

Maintain Backward Compatibility
02:50

Save Databases As Templates
04:00

Save Databases To External Locations
02:47


Program Close
00:16
About the Instructor
iCollege Certifications
4.1 Average rating
1,676 Reviews
11,316 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,628 Reviews
275,073 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.