تصميم قاعدة بيانات على access [ دورة كاملة في فيديو واحد] ✅
112.1 هزار بار بازدید -
پارسال
-
In this video tutorial we
In this video tutorial we will learn about "designing a database" step by step, designing a database on access, designing a database for a company, how to hide access and show forms only, how to create a database and make a main interface - data entry interface - login form with username and password, and how to create tables How to create queries, how to create forms, and how to create reports. By the end of this video, you will understand the basics of working with databases in Access and you will learn how to hide the Access screen and show only forms. You will also learn how to insert images into the Access program and display images on the form, create an Access database from start to finish, enter data, create an Excel database Excel database design, excel vba, access, [database design]
00:00 Introduction
00:30 Database design
01:59 Create a new database
06:12 Determine the types of fields in the table
07:41 Create a new template
10:35 Create a login form
13:32 Select a model to open first
16:37 Hide the access screen and show only the form
19:16 How to enter design mode
19:45 Creating the main interface of the program
20:32 Changing the shape and style of the buttons
21:57 The program exit button worked
21:57 The program exit button worked
25:25 Register user data
26:23 Create a drop-down list that displays the usernames
28:34 Solving the problem of opening the program in the background and not being able to close it
29:56 Make a background for the model
31:15 Data entry interface design
33:37 How to insert a picture of the table from the form
36:21 Make a navigation button between destinations
37:28 Make a button to go to a new record
38:33 Make a button to go to a specific record
42:32 Create a report
48:27 The order to open the report
50:20 Macro playback settings
51:52 Arabic language settings inside Windows
We will also learn together how to design a database with the inclusion of an image in the Access program, how to create a database with an image in the Access program, and the way to hide the main interface of Access and show only the templates, and we will also learn the advantages of the Access program as a large database that holds the largest possible number of data, Access is considered One of the most important service programs in the field of databases, sales, personnel and business affairs.
In this video, we will learn how to use the Microsoft Access program in an easy and enjoyable way, God willing, and how to create a database, create a database for work, and design databases for workers, companies, and stores.
00:00 Introduction
00:30 Database design
01:59 Create a new database
06:12 Determine the types of fields in the table
07:41 Create a new template
10:35 Create a login form
13:32 Select a model to open first
16:37 Hide the access screen and show only the form
19:16 How to enter design mode
19:45 Creating the main interface of the program
20:32 Changing the shape and style of the buttons
21:57 The program exit button worked
21:57 The program exit button worked
25:25 Register user data
26:23 Create a drop-down list that displays the usernames
28:34 Solving the problem of opening the program in the background and not being able to close it
29:56 Make a background for the model
31:15 Data entry interface design
33:37 How to insert a picture of the table from the form
36:21 Make a navigation button between destinations
37:28 Make a button to go to a new record
38:33 Make a button to go to a specific record
42:32 Create a report
48:27 The order to open the report
50:20 Macro playback settings
51:52 Arabic language settings inside Windows
We will also learn together how to design a database with the inclusion of an image in the Access program, how to create a database with an image in the Access program, and the way to hide the main interface of Access and show only the templates, and we will also learn the advantages of the Access program as a large database that holds the largest possible number of data, Access is considered One of the most important service programs in the field of databases, sales, personnel and business affairs.
In this video, we will learn how to use the Microsoft Access program in an easy and enjoyable way, God willing, and how to create a database, create a database for work, and design databases for workers, companies, and stores.
پارسال
در تاریخ 1402/02/24 منتشر شده
است.
112,126
بـار بازدید شده