Companies Home Search Profile

Access 2019 Power Users

Focused View

Shari Oswald

1:49:52

68 View
  • 0. Reviewing Database Basics.mp4
    01:06
  • 1. Understanding the Primary Key.mp4
    01:11
  • 2. Understanding Database Relationships.mp4
    02:10
  • 3. Planning a Database.mp4
    01:50
  • 4. Planning Your Tables.mp4
    01:30
  • 5. Planning Your Fields.mp4
    02:12
  • 6. Using Naming Conventions.mp4
    02:29
  • 7. Using Excel to Plan Your Tables.mp4
    01:57
  • 8. Creating a Database from a Template.mp4
    01:54
  • 9. Creating a Blank Database.mp4
    00:45
  • 10. Saving a Database.mp4
    00:45
  • 0. Creating a Blank Table.mp4
    00:51
  • 1. Creating a Table in Design View.mp4
    01:12
  • 2. Importing Tables from Other Sources.mp4
    02:04
  • 3. The Table Design Ribbon.mp4
    01:55
  • 4. Editing a Table.mp4
    01:30
  • 5. Renaming a Table.mp4
    01:25
  • 6. Deleting a Table.mp4
    00:55
  • 0. Auto Number.mp4
    01:51
  • 1. Text Fields (Long and Short).mp4
    01:29
  • 2. Number Fields.mp4
    01:35
  • 3. Currency.mp4
    01:17
  • 4. Date-Time.mp4
    03:42
  • 5. Yes-No.mp4
    00:57
  • 6. Attachment.mp4
    00:32
  • 7. Hyperlink.mp4
    00:46
  • 8. Calculated.mp4
    02:52
  • 9. Lookup Wizard.mp4
    04:07
  • 0. Understanding Fields.mp4
    01:02
  • 1. Adding a Field to a Table.mp4
    02:52
  • 2. What Are Field Properties-.mp4
    01:25
  • 3. Renaming a Field.mp4
    02:02
  • 4. Field Descriptions.mp4
    01:58
  • 5. Using the Property Pane.mp4
    04:12
  • 6. Changing Field Captions.mp4
    01:22
  • 7. Deleting Fields from a Table.mp4
    01:39
  • 0. Using Query Naming Conventions.mp4
    02:00
  • 1. Creating a Query in Design View.mp4
    02:36
  • 2. The Run Command.mp4
    01:36
  • 3. Using Query Views.mp4
    01:11
  • 4. Editing a Query.mp4
    00:50
  • 5. Adding Fields to a Query.mp4
    00:54
  • 6. Saving a Query.mp4
    00:59
  • 7. Saving a Copy of a Query.mp4
    01:13
  • 8. Removing Fields from a Query.mp4
    01:39
  • 9. Renaming a Query.mp4
    01:13
  • 10. Duplicating a Query.mp4
    01:08
  • 11. Deleting a Query.mp4
    01:35
  • 0. Using Form Naming Conventions.mp4
    01:16
  • 1. Using Form Views.mp4
    00:58
  • 2. Creating a Form in Design View.mp4
    01:10
  • 3. Saving a Form.mp4
    00:54
  • 4. Renaming a Form.mp4
    01:12
  • 5. Saving a Copy of a Form.mp4
    01:17
  • 6. Editing a Form in Layout View.mp4
    02:48
  • 7. Editing a Form in Design View.mp4
    02:04
  • 8. Duplicating a Form.mp4
    00:54
  • 9. Deleting a Form.mp4
    01:42
  • 0. Using Report Naming Conventions.mp4
    00:58
  • 1. Using Report Views.mp4
    01:10
  • 2. Create a Report Using Design View.mp4
    01:43
  • 3. Page Setup Options.mp4
    01:00
  • 4. Saving a Report.mp4
    02:00
  • 5. Renaming a Report.mp4
    01:00
  • 6. Saving a Copy of a Report.mp4
    01:04
  • 7. Editing a Report in Layout View.mp4
    02:25
  • 8. Editing a Report in Design View.mp4
    01:38
  • 9. Duplicating a Report.mp4
    00:47
  • 10. Deleting a Report.mp4
    01:37
  • Description


    In this course, you’ll learn the deeper aspects of working with Access 2019. You will gain a greater understanding of databases, tables, queries, forms, and reports and move toward becoming a “power user” of Access.

    What You'll Learn?


      In this course, Access 2019 Power Users, you will dive further into the world of Access 2019. First, you’ll continue your understanding of working with databases and tables. Then, you’ll begin learning about data types and learn how to work with fields. Finally, you’ll discover more about creating and managing queries, forms, and reports. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to expand your development (and continue preparation for the Microsoft Office exams).

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Shari Oswald
    Shari Oswald
    Instructor's Courses
    Shari majored in Business Administration and minored in Communication at the University of Colorado. She has over 12 years of training experience in the areas of Leadership, Team Building, and Personal Development in addition to a wide range of computer software programs and operating systems. She began her career in training in her role as Human Resources Manager, became an adjunct professor for Regis University and transferred those skills into technical training, consulting, and courseware development. Shari has delivered training for several large corporations in Colorado, Oregon, California, and Minnesota as well as for individuals and small businesses. Her philosophy in training is that it's her job to make my student's job easier and she enjoys helping them find more efficient ways to perform their daily tasks. Shari's expertise in the applications she teaches makes her an excellent resource as a subject matter expert. This often leads to consulting engagements. Shari specializes in the data driven applications such as Microsoft Access, Microsoft SQL Server, and Crystal Reports. Her newest passion is the wonderous world of SharePoint to help organizations communicate and collaborate more effectively. Most recently, Shari's expertise has brought her into the world of eLearning Development. Her largest project included over 200 lessons developed for a software application used to manage medical practices where she managed the project and developed about 60% of the content. Shari developed a SharePoint site which tracked the progress of the lessons and modules through 6 phases of development.
    Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.
    • language english
    • Training sessions 69
    • duration 1:49:52
    • level average
    • English subtitles has
    • Release Date 2023/10/11