LearnNowOnline_Access_2013_Part_1_UI_Tables_and_Forms

این دوره آموزشی محصول موسسه LearnNowOnline است.

سرفصل های دوره:

  • مقایسه با MS Excel
  • گزارش و فرم
  • ویژگی های عمومی رابط
  • رابط و جداول
  • ایجاد تب
  • کار با جداول
  • نمایش Query
  • نمایش SQL
  • پیش نمایش از فرم
  • پیش نمایش از گزارش
  • فرم های پیچیده
  • الگوی Northwind
  • و…

عنوان دوره:  LearnNowOnline Access 2013, Part 1: UI, Tables and Forms

مدت زمان: 1 ساعت و 23 دقیقه

نویسنده:  John Wiley & Sons


توضیحات:

LearnNowOnline Access 2013, Part 1: UI, Tables and Forms

John Wiley & Sons
1h 23m

Course description
In this eight parts leaning series you'll see how Access 2013 is Microsoft's database management software that allows users to enter, manage, and build reports on large amounts of data. Get to know the Access work environment, master tables, Data Fields, and Data Types; understand queries and create a simple select query; build a simple UI with forms; and learn how to create simple reports. Advanced topics include automating tasks with macros and Importing, linking, and exporting external data.
Prerequisites
This course assumes very little familiarity with Microsoft Access. This course is part of 8 courses; Access 2013: UI, Tables and Forms; Access 2013: Queries, Reports and Data; Access 2013: Navigation, View and Keys; Access 2013: Masks, Lookup and Queries; Access 2013: Groups, Joins and Action; Access 2013: Queries and Forms; Access 2013: Forms and Reports; and Access 2013: Reports, Macros and Importing. Please be sure to view the courses in order if you are new to the material.

Introduction to Access
25:06
Introduction
00:10
What Is and Why Use Access?
03:51
Comparison with MS Excel
04:42
Reports & Forms
05:16
General Interface Features
03:31
The Ribbon & File Tab
02:32
Templates, Navigation, & Views
04:52
Summary
00:10
Interface and Tables
29:49
Introduction
00:10
Access Interface
04:56
Property Sheets
05:12
The Navigation Pane
03:30
The Create Tab
01:59
Working with Tables
03:35
The Design View
04:31
Input Mask
03:11
The Lookup
02:31
Summary
00:10
Views and Forms
28:30
Introduction
00:10
Document Views
05:00
Query Views
03:03
The SQL View
02:47
Preview of Form Views
02:29
Preview of Report Views
04:38
Basic Forms
04:45
Complex Forms
01:51
The Northwind Template
03:34
Summary
00:10