MicroSoft Access Basics

Have Queries? Ask us +91 72592 22234

Course Overview


Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In MicroSoft Access Fundamentals course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access relational database application.

Course Content


EXPLORING THE MICROSOFT OFFICE ACCESS

  • 2007 ENVIRONMENT
  • Examine Database Concepts
  • Exploring the User Interface
  • Use an Existing Access Database
  • Customize the Access Environment
  • Obtain Help

DESIGNING A DATABASE

  • Describe the Relational Database Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships
  • Setting rules to ensure valid relationship

BUILDING A DATABASE

  • Create a Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship, Delete and Apply rules
  • Save a Database as a Previous Version

MANAGING DATA IN A TABLE

  • Modify Table Data
  • Sort Records, Add, Delete Records
  • Navigate within table
  • Define key, primary key , Indexing
  • Creating one to one one to many relations
  • Work with Subdatasheets

QUERYING A DATABASE

  • Filter Records, Navigate records
  • Form headers footers
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
  • Use two table querys
  • Using operators within queries
  • Editing, running and deleting a query
  • Savinng and closing a query

DESIGNING FORMS

  • View Data Using an Access Form
  • Create a Form
  • Modify the design of a Form

GENERATING REPORTS

  • View an Access Report
  • Create a Report
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat Style to a Report
  • Prepare a Report for Print

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234