تفاصيل الدورة

A successful database is efficient quick accurate and easy to use. This course covers how to create such a database with MS Access.

COURSE CONTENT

Module 1: Get Acquainted with Access

  • What is access
  • Introduction to Database
  • Relational Database management system
  • Introduction to Database objects
  • Components of Access User interface
  • Ribbon, Navigation pane, Back stage view

Module 2: Access startup screen

  • Creating new blank Database
  • Closing Database
  • Creating Database from Template
  • Opening an existing Database
  • Backing up Database

Module 3: Using Navigation Pane

  • Viewing object, Copying object
  • Renaming Object, Deleting object

Module 4: Access Tables

  • Planning Tables
  • Planning fields
  • Creating tables in Design view
  • Modifying Tables in Design view
  • Selecting a primary key
  • Importing data from excel into new table
  • Importing data as a linked table

Module 5: Table Relationship

  • Relationship types
  • Creating relationship in database
  • Creating look up field
  • Viewing related data

Module 6: Creating Queries

  • Creating Query in design view
  • Creating Query with Query Wizard
  • Modifying Queries
  • Adjusting Query field
  • Sorting Query field
  • Hiding Query field
  • Adding Query criteria
  • Adding calculated field to Query
  • Creating crosstab Query

Module 7: Using Forms

  • Form views
  • Creating form with form Wizard
  • Working with forms in design view
  • Working with forms in Layout view
  • Working with padding, Margins and Anchoring

Module 8: Creating Reports

  • Report sections
  • Designing a report
  • Report views, print view, and layout view
  • Using the report tool
  • Working with reports in layout view
  • Working with reports in design view
  • Creating blank report
  • The field list pane
  • Grouping and sorting report
  • Previewing and printing reports
تحديث بتاريخ 08 November, 2015

نبذة عن معهد G TEC Computer Education

we_they provides quality education in Information Technology. We focus on Programming Courses, Animation and Web Design Courses. We also provide Diploma and Post Graduate Diploma Courses.
we_they is division of Glosoft Technologies (P) Ltd, India. Glosoft is an Information Technology company in the field of Software Training, Technology resource and Knowledge Consulting. It provides solutions through application of proven platforms and adaptation of emerging technologies. Core to its offering is a solution through well documented software engineering practices, project management mile stones and quality assurance parameters for each stage of software training and development lifecycles.
عرض الجميع دورات G TEC Computer Education
Are you from G TEC Computer Education ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Access ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو