نرم افزار 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