O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Office 2013 Access

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

Table of Contents

  1. Introduction
    1. Access 2013 - Introduction 00:01:07
  2. Module 1
    1. Section 1-1 - Creating Databases 00:00:13
    2. Creating New Databases 00:04:15
    3. Create Databases Using Templates 00:04:28
    4. Create Databases In Older Formats 00:03:37
    5. Section 1-2 - Creating Tables 00:00:21
    6. Create New Tables 00:06:31
    7. Import External Data Into Tables 00:09:49
    8. Create Linked Tables From External Sources 00:04:40
    9. Import Tables From Other Database 00:03:47
    10. Create Tables From Templates And Application Parts 00:03:43
    11. Section 1-3 - Format A Table 00:00:18
    12. Hide Fields In Tables 00:03:29
    13. Change Data Formats 00:04:40
    14. Add Total Rows 00:04:09
    15. Add Table Descriptions 00:03:48
    16. Rename Tables 00:04:47
    17. Section 1-4 - Manage Records 00:00:22
    18. Update Records 00:03:04
    19. Add New Records 00:03:03
    20. Delete Records 00:03:04
    21. Append Records From External Data 00:03:13
    22. Find And Replace Data 00:04:19
    23. Sort Records 00:04:38
    24. Filter Records 00:03:30
    25. Section 1-5 - Create And Modify Fields 00:00:34
    26. Add Fields To Tables 00:04:42
    27. Add A Validation Rules To Fields 00:08:23
    28. Change Field Captions 00:05:37
    29. Change Field Sizes 00:07:06
    30. Change Field Data Types 00:05:14
    31. Configure Fields To Auto-Increment 00:03:54
    32. Set Default Values 00:03:49
    33. Use Input Masks 00:07:13
    34. Delete Fields 00:03:51
  3. Module 2
    1. Section 2-1 - Create A Query 00:00:22
    2. Run Queries 00:11:28
    3. Create Crosstab Queries 00:04:18
    4. Create Parameter Queries 00:03:12
    5. Create Action Queries 00:04:30
    6. Create Multi Table Queries 00:03:52
    7. Save Queries And Delete Queries 00:03:41
    8. Section 2-2 - Modify A Query 00:00:20
    9. Rename Queries 00:02:51
    10. Add New Fields 00:02:45
    11. Remove Fields 00:03:35
    12. Hide Fields 00:03:03
    13. Sort Data Within Queries 00:04:17
    14. Format Fields Within Queries 00:03:11
    15. Section 2-3 - Utilize Calculated Fields And Grouping Within A Query 00:00:20
    16. Add Calculated Fields 00:04:30
    17. Add Conditional Logic 00:04:16
    18. Group And Summarize Data 00:04:59
    19. Use Comparison Operators 00:03:36
    20. Use Basic Operators 00:03:22
  4. Module 3
    1. Section 3-1 - Create A Form 00:00:15
    2. Create New Forms 00:09:18
    3. Create Forms With Application Parts 00:03:17
    4. Save And Delete Forms 00:04:02
    5. Section 3-2 - Set Form Controls 00:00:21
    6. Move Form Controls 00:06:27
    7. Add Form Controls 00:04:34
    8. Modify Data Sources 00:06:38
    9. Remove Form Controls 00:02:22
    10. Set Form Control Properties 00:06:26
    11. Manage Labels 00:06:18
    12. Section 3-3 - Format A Form 00:00:31
    13. Modify Tab Order In Forms And Auto-Order Forms 00:06:57
    14. Format Print Layouts 00:04:45
    15. Sort Records 00:03:49
    16. Apply Themes 00:02:14
    17. Change Margins 00:04:23
    18. Insert Backgrounds 00:04:15
    19. Insert Headers And Footers 00:03:59
    20. Insert Images 00:03:20
    21. Modify Existing Forms 00:03:51
  5. Module 4
    1. Section 4-1 - Create A Report 00:00:14
    2. Create New Reports 00:06:16
    3. Create Reports With Application Parts 00:04:27
    4. Delete Reports 00:02:27
    5. Section 4-2 - Set Report Controls 00:00:19
    6. Group Data By Fields 00:04:07
    7. Sort Data 00:02:06
    8. Add Sub-Forms 00:06:05
    9. Modify Data Sources 00:05:43
    10. Add Report Controls 00:04:52
    11. Manage Labels 00:04:26
    12. Section 4-3 - Format A Report 00:00:30
    13. Format Reports Into Multiple Columns 00:04:48
    14. Add Calculated Fields 00:02:54
    15. Set Margins 00:03:42
    16. Add Backgrounds 00:02:51
    17. Change Report Orientation 00:03:36
    18. Change Sort Order 00:03:04
    19. Insert Headers And Footers 00:01:37
    20. Insert Images & Insert Page Numbers 00:05:40
    21. Apply Themes 00:02:21
    22. Modify Existing Reports 00:04:10
  6. Module 5
    1. Section 5-1 - Manage Relationships And Keys 00:00:20
    2. Create And Modify Relationships & View Relationships 00:08:42
    3. Set Primary Key Fields 00:04:12
    4. Set Foreign Keys 00:02:28
    5. Enforce Referential Integrity 00:03:28
    6. Section 5-2 - Navigate Through A Database 00:00:17
    7. Navigate To Specific Records 00:03:28
    8. Set A Form As The Startup Option 00:02:53
    9. Use Navigation Forms 00:02:46
    10. Set Navigation Options 00:04:33
    11. Change Views 00:06:24
    12. Section 5-3 - Protect And Maintain A Database 00:00:21
    13. Compact Databases & Repair Databases 00:04:47
    14. Back Up Databases 00:03:52
    15. Split Databases 00:03:49
    16. Encrypt Databases With A Password 00:03:17
    17. Merge Databases 00:02:37
    18. Recover Data From Backups 00:03:53
    19. Section 5-4 - Print And Export A Database 00:00:21
    20. Print Reports 00:02:58
    21. Print Records 00:01:57
    22. Maintain Backward Compatibility 00:02:50
    23. Save Databases As Templates 00:04:01
    24. Save Databases To External Locations 00:02:48
    25. Export To Alternate Formats 00:06:23
    26. Program Close 00:00:16