استيراد البيانات من الاكسيس

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00Peace be upon you and a video message from the Asal video

00:04We will learn later how to import data from the Asl program.

00:08When we work on the original database or the original database

00:13Sometimes we import data from another program.

00:17So that we can work on it instead of getting tired of writing it again manually.

00:23Here I start importing data from the software.

00:27I start using a very simple method.

00:30I'm going to a foodie place, and for example, this place

00:34I will start by clicking on the tab called Data

00:37Okay

00:39In this section, I will start that I

00:42I find a set of tools that will help me with the part that concerns me.

00:46Get and transform data far right

00:49Find the data here

00:52Of course, more than one source of data is useful to me.

00:55I will select them from the database.

00:57From Microsoft Access database

01:00He starts to see where my device is.

01:04Where are the data bases located?

01:06I will tell him, for example, that it is on the desktop.

01:09Here is the import database.

01:11I will tell him to import

01:12Of course, the Access database contains several tables.

01:16Usually inquiries and many things oh

01:20So he starts to bloom my database

01:23It blossoms for me the things that contain it

01:26About table one and about table two

01:28I will tell him, for example, to choose one table for me.

01:30He examines it and tells me this is what it looks like.

01:33I tell him to download or change the order if it is not this way because we want

01:37Download here

01:39So she will start going down with me

01:42Ok here I am fetching the data

01:45And he still carries it

01:47I will give him his time until he finishes downloading

01:50And you will come down with me

01:52So I downloaded the database or table that I brought from the database in Access.

01:57Okay, let's take another issue to hit on it more.

02:01I start standing in any empty place

02:03I will tell him from the data

02:05Get data

02:07From Access database

02:09I choose the database I want

02:13I will tell him to import

02:15He starts showing me what's in it.

02:18The wife chose two tables for him.

02:20Because we already have one table with us.

02:22Give me the following preview and I will tell him to download it.

02:26It takes time to download the data to me in this form.

02:31We would have known how to download data, upload data, or import data from Access. Let's try it.

Category

Transcript

Recommended