Microsoft Access 2010: Beginner to Advanced

(4 customer reviews)
Sale!

Leading the way

Microsoft Access 2010: Beginner to Advanced

(4 customer reviews)

| Total Course Video Hours: 4 Hrs 36 Min
|  Videos: 33
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute

Course Fee:

R1600,00

Current Special Ends in:

  • 00Days
  • 00Hours
  • 00Min
  • 00Sec

Overview

Microsoft Access 2010 course covers basic, intermediate, and advanced features of MS Access 2010 software. Access 2010 is a database application, design, and deployment tool that users use to keep track of important information. Users of this software can keep data on their computer, or they can publish it to the Web, so that other users may access the database with a web browser. Access databases can help the user store and track just about any kind of information, such as inventory, contacts, or business processes. Microsoft Access makes its easier to analyze substantial amounts of information and relational data more efficiently than using Excel or other spreadsheet applications.

Claim your FREE R500 Gift Voucher

FREE R500 gift voucher, especially for you 🎁

Join our mailing list and get your free exclusive R500 discount voucher.

This Voucher can be used for any of our Bundle Courses.

Curriculum

Introduction
„ Instructor Introduction
„ Access Overview
„ Course Outline

Section 1: Access Basics
„ Section Overview
„ What Does Access Do?
„ Access Application Window
„ Database Objects
„ Basic Database and Table Management
„ Customizing Access
„ Keyboard Shortcuts
„ Section Review

Section 2: Designing a Database
„ Section Overview
„ Database Design Process
„ Normalizing Data
„ Setting Primary and Foreign Keys
„ Section Review

Section 3: Building a Database
„ Section Overview
„ Creating A New Database
„ Creating Tables
„ Inserting Field’s in Tables
„ Setting Up Field Properties
„ Formatting the Datasheet View
„ Creating Relationships
„ Keyboard Shortcuts
„ Section Review

Section 4: Managing Table Data
„ Section Overview
„ Updating and Deleting Records
„ Finding and Replacing Values
„ Adding a Total Row
„ Using Sub-datasheets
„ Sorting Data
„ Filtering Data
„ Keyboard Shortcuts
„ Section Review

Section 5: Creating Selection Queries
„ Section Overview
„ Creating Queries Using the Query Wizard
„ Creating Queries Using the Query Design View
„ Adding Criteria
„ Add Calculated Fields to Query
„ Section Review

Section 6: Creating and Managing Forms
„ Section Overview
„ Form Basics and Creating Forms
„ Contextual Tabs Design and Layout View
„ Managing Table Data with Forms
„ Modifying the Look and Design
„ Design Tab Controls
„ Section Review

Section 7: Creating and Managing Reports
„ Section Overview
„ Creating Reports, Report Views, and Managing Report Sections
„ Adding Calculated Fields and Formatting The Report Controls
„ Section Review

Section 8: Controlling Data Entry
„ Section Overview
„ Setting Field Properties
„ Validation Rules
„ Input Mask
„ Create Lookup Field
„ Section Review

Section 9: Finding and Joining Data
„ Section Overview
„ Inner and Outer Joins
„ Joining Unrelated Tables and Relating Data Within Tables
„ Section Review

Section 10: Creating Flexible Queries
„ Section Overview
„ Select Query Properties
„ Parameter Queries
„ Using Wild Cards
„ Creating Action Queries
„ Section Review

4 reviews for Microsoft Access 2010: Beginner to Advanced

  1. Penelope

    The knowledge I gained from this course is invaluable. Thank you!

  2. Liam

    This course has been a game-changer for me.

  3. Nontobeko

    The instructor’s engaging teaching style made the course enjoyable and kept me actively learning.

  4. Kholeka

    Easy to learn and great content

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.