نرم افزار Access 2013 تمام امکانات مورد نیاز برای ساخت یک اپلیکیشن مبتنی بر پایگاه داده از قبیل ساخت جدول، فرم، ساخت گزارش، ساخت ماکرو، کد نویسی و …. را دارد.
در این آموزش تصویری با اصول ساخت اپلیکیشن های مبتنی بر پایگاه داده با MS Access 2013 آشنا می شوید.
این دوره آموزشی محصول موسسه Udemy است.
سرفصل های این دوره:
- درک ساختار جدول ها و روابط
- تنظیم کلید های اصلی و خارجی
- برقراری روابط و حفظ یکپارچگی ارجاعی
- مرتب سازی و فیلتر کردن داده ها
- نمایش داده ها با محدودیت ها و ضوابط
- ویرایش داده های جدول نمایش داده شده
- ایجاد فرم ها از جداول
- اضافه کردن کنترل های فرم
- ایجاد گزارش
- ساخت ماکرو
- تعمیر پایگاه داده
- محافظت از پایگاه داده ها با تعریف کلمه عبور
- و …
عنوان دوره: Udemy Create Database Applications Using MS Access 2013
مدت دوره: 2 ساعت و 30 دقیقه
نویسنده: Kelvin Mbatu
Udemy Create Database Applications Using MS Access 2013 Kelvin Mbatu 2.5 hours Beginner Level This MS Access 2013 course was designed to be easily understood by absolute beginners and at the same time offer value to somewhat proficient users of Microsoft Access. The course focuses on equipping you with the hands-on skills required to develop database applications with MS Access in as little time as possible. By the end of the course, you'll have the confidence required to get you started with developing your own database applications. What's in it for you? In this course, you will learn how to: Develop database applications by solving a real world problem. Create MS Access objects: tables, forms, queries, macros and reports Develop SQL Queries to retrieve and manipulate data from your tables Easily import data from Microsoft Excel to MS Access Quickly format forms, and restrict data that is entered into your tables. Create a switchboard for easy navigation around your database Course Structure This course was structured to first teach you the fundamentals of database design and then guide you on a step-by-step basis on how to design and create your own database applications You do not need any prior technical or programming experience to fully participate in this course, you just need the patience and willingness to learn. You'll have access to the detailed step-by-step Lab Exercises that will guide you through developing the various application components. There are quizzes at the end of each new concept learnt to validate the knowledge and skills you would have gained. What are the requirements? A computer with Microsoft Access Installed What am I going to get from this course? Over 29 lectures and 2.5 hours of content! Confidently develop database applications using Microsoft Access Understand MS Access and how it can be applied to solve real world problems Understand and Implement best practice database design concepts Create tables, forms, queries, reports, macros and relationships What is the target audience? Professionals needing to develop Microsoft access applications Students taking or preparing to take a MS Access class Anyone seeking to obtain this invaluable skill Section 1: Introduction and Objectives Lecture 1 Introduction - Course Overview 02:50 Introduction to creating databases with MS Access 2013. What to expect in the coming lectures Lecture 2 What is a database 01:56 Understand databases, and why they are important Lecture 3 What is MS Access 01:48 Understand MS Access, its uses and applications. Understand other DBMSs Lecture 4 Course database project 03:44 A discussion on the final course project and course structure Lecture 5 Getting Started with MS Access 02:06 Brief introduction to the MS Access product and interface. Quiz 1 Understand MS Access 2 questions Section 2: Components of an Access Database Application Lecture 6 Tables 01:55 Description of a table, how it is organised and its uses Lecture 7 Relationships 02:37 Description of relationships, and their uses Lecture 8 Forms 02:13 Description of a forms and their uses Lecture 9 Queries 02:59 Description of queries, and their uses Lecture 10 Reports 01:24 Description of reports, and their uses Lecture 11 Other MS Access objects 01:00 Description of other objects not covered in this class such as VBA. Quiz 2 Components of MS Access database application 5 questions Section 3: Designing the database Lecture 12 Design is key 00:57 Understand the importance of database design. Lecture 13 Database design principles 07:43 Best practice database design principles Lecture 14 The design process 07:15 A walkthrough of the process of designing a database Quiz 3 Database design concepts 5 questions Section 4: Building the database Lecture 15 Building the tables 10:16 How to build the table, and decide on data types Lecture 16 Inserting data into the tables - using datasheet view 06:21 How to insert data into your database tables using the data sheet view. Lecture 17 Inserting data into the tables - importing data from excel 06:10 How to import MS Excel data into your MS Access tables Quiz 4 Building MS Access tables 4 questions Lecture 18 Building the table relationships 03:58 How to create table relationships and enforce referential integrity Quiz 5 Building MS Access table relationships 3 questions Lecture 19 Building the forms for data Input 06:59 How to create the MS Access forms. Lecture 20 Modify the Forms Design 12:22 How to modify form's design Lecture 21 Create the Rental Reservation Form 15:50 How to create the rental reservation form which references multiple tables in our database Quiz 6 Building MS Access Forms 3 questions Lecture 22 Building Queries 04:43 How to create MS Access queries and execute them Lecture 23 Building Queries - Intro to SQL 10:19 Introduction to SQL using MS Access. Understand Joins Lecture 24 Building Queries - using query builder 08:54 Create queries in MS Access using the query builder Lecture 25 Referencing Queries in Combo boxes 03:07 How to reference queries in combo boxes Lecture 26 The Update Rental Form 07:03 Learn some more complex form design concepts Quiz 7 Building MS Access Queries 5 questions Lecture 27 Building the reports 12:48 Build the reports for our application Quiz 8 Building MS Access Reports 3 questions Section 5: Piecing it together Lecture 28 Linking forms 11:41 Create a dashboard for easy navigation around our database application Lecture 29 Conclusion 00:54