LearnNowOnline_Access_2013_Part_3_Navigation_View_and_Keys

 

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

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

  • ورود اطلاعات به یک جدول
  • حرکت از یک سلول به سلول دیگر
  • برش، کپی، چسباندن
  • مرتب سازی و فیلتر
  • پیدا کردن و جایگزین
  • مرتب سازی و فیلتر
  • ابزار Totals
  • طراحی جداول
  • خواص نوع داده
  • کلید اولیه و روابط
  • نقشه روابط
  • حذف آبشاری
  • و…

عنوان دوره:  LearnNowOnline Access 2013, Part 3: Navigation, View and Keys

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

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


توضیحات:

LearnNowOnline Access 2013, Part 3: Navigation, View and Keys

expert John Wiley & Sons
1h 17m

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.
Data Entry and Navigation 27:34

Introduction
00:10
Data Entry into a Table
04:22
Moving From Cell to Cell
04:27
Cut, Copy, & Paste
05:02
Navigate the Datasheet View
04:18
Sorting & Filtering
03:04
Find & Replace
02:14
The Navigation Tool
03:44
Summary 00:10
Sort-Filter and Design View
26:47
Introduction
00:10
More Sorting & Filtering
03:46
Apply Filter & Sort Query
02:38
The Totals Tool
02:59
Tables Design View
03:43
Data Type Properties
04:40
Numbers & Data-Time
02:53
Lookup
03:06
Property Sheet 02:38
Summary 00:10
Primary Keys and Relationships
23:24
Introduction
00:10
The Primary Key
03:44
Create Table Design
04:13
Lookup Relationship
03:58
Relationships Map
02:27
Cascading Delete
03:23
Create via Drag & Drop
05:17
Summary
00:10