Append Quary PDF
Document Details
Uploaded by LucidCelebration2654
Ram Narayan Intermediate College
Tags
Summary
This document provides instructions for appending data in MS Access tables. It involves steps for opening a database, adding new information, and running queries for appending data from different tables, such as OSC IT, PGDCA, and OLAVEL tables.
Full Transcript
APPEND QUARY 1. Add OSC IT information on OSC IT Table? 2. Add PGDCA information on PGDCA Table? 3. Add OLAVEL information on OLAVEL Table? Stpe-1 Open ms access database and table Stat->access->database name->open Right click on table-1 and select open Step-2 Add new information o...
APPEND QUARY 1. Add OSC IT information on OSC IT Table? 2. Add PGDCA information on PGDCA Table? 3. Add OLAVEL information on OLAVEL Table? Stpe-1 Open ms access database and table Stat->access->database name->open Right click on table-1 and select open Step-2 Add new information on table-1 such as new regd of o lavel ,oscit,& pgdca Step-3 Click on create menu select quarry design add table -1 press ok Step-4 Select append quarry from quarry design, select table such as oscit,olavel,pgdca and press ok Step-5 Step-6 Click on run quary
