Lynda Office 365 Access
آموزش استفاده از اکسس در فضای Office 365

کاربرد : آموزش استفاده از اکسس در فضای Office 365
نوع فایل : فیلم آموزشی
زبان : انگلیسی
سیستم عامل : Windows-Mac-Linux-Android-iOS
تولید کننده : Lynda
سال تولید : 2015

توضیحات

با مشاهده این مجموعه آموزش می توانید به طور کامل استفاده از اکسس را در فضای Office 365 یاد بگیرید. این مجموعه آموزش برای کاربران نرم افزار اکسس 2013 که می خواهند دانش خود را برای استفاده از این نرم افزار در فضای Office 365 بروز نمایند بسیار مفید و کاربردی است.

Description

Spreadsheets can only go so far. Databases are the next best step for complex data sets. Access 2016, Microsoft's powerful database software included with Office 365, is the perfect introduction for those new to relational databases. This course provides an overview for first-time users. Adam Wilbert explains the best uses for Access, tours the interface, and guides viewers through various Access conventions and tasks, like understanding how objects interact, adding data to a table, and running a report. He also shows how to get going quickly with Access templates, create queries and reports to pull insights from data, and even use data from existing sources like Excel.

If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
Topics include:
Loading a premade template database
Exploring the interface
Defining data types
Creating tables
Defining table relationships
Editing forms
Creating queries and reports
Editing reports in Layout view

بخش های فایل

این فایل شامل 85 بخش می باشد که بخش های آن به صورت جداگانه در زیر آمده است.

Row	Title	Size
01. Introduction
1	01_01-Welcome	6.51 MB
2	01_02-Using the exercise files	1.42 MB
02. Getting Started
3	02_01-Key database concepts	5.95 MB
4	02_02-Launching Access and the Backstage screen	5.82 MB
5	02_03-Creating the database file	5.33 MB
6	02_04-Understanding the Trust Center	5.13 MB
7	02_05-Digging in to Ribbon tabs	5.11 MB
8	02_06-Using the Navigation pane	5.50 MB
9	02_07-Using the Quick Access Toolbar	2.66 MB
10	02_08-Signing in to Microsoft Live	1.42 MB
11	02_09-Taking backups	1.43 MB
12	02_10-Accessing help	1.87 MB
03. Creating Tables
13	03_01-Understanding table structure and relationships	5.60 MB
14	03_02-Creating a table and setting data types	6.11 MB
15	03_03-Entering data	5.95 MB
16	03_04-Understanding primary and foreign keys	9.53 MB
17	03_05-Importing tables	9.78 MB
04. Setting Field Properties
18	04_01-Establishing relationships and maintaining referential integrity	11.44 MB
19	04_02-Editing table structure in Design view	7.96 MB
20	04_03-Controlling input with masks	9.61 MB
21	04_04-Setting the default value	4.73 MB
22	04_05-Establishing validation rules	7.71 MB
23	04_06-Creating lookup fields	8.84 MB
24	04_07-Setting additional field properties	6.82 MB
05. Organizing Records
25	05_01-Formatting columns	6.73 MB
26	05_02-Sorting table data	9.11 MB
27	05_03-Filtering table data	5.18 MB
28	05_04-Searching and replacing values	6.53 MB
06. Using Queries
29	06_01-Understanding queries	2.77 MB
30	06_02-Creating queries with the Simple Query Wizard	8.05 MB
31	06_03-Building queries in Design view	8.77 MB
32	06_04-Establishing constraints with criteria	8.56 MB
33	06_05-Specifying criteria with wildcards	6.96 MB
34	06_06-Leveraging multiple criteria with AND and OR statements	8.59 MB
35	06_07-Filtering with mathematical comparisons	4.18 MB
36	06_08-Creating flexible queries with parameter requests	6.50 MB
37	06_09-Building expressions	10.80 MB
38	06_10-Obtaining summary statistics	7.44 MB
07. Working with Specialty Queries
39	07_01-Using update queries	6.76 MB
40	07_02-Using make table queries	6.22 MB
41	07_03-Using delete queries	5.27 MB
42	07_04-Using append queries	6.18 MB
43	07_05-Getting a different look with crosstab queries	5.86 MB
44	07_06-Creating a union query in SQL view	8.24 MB
08. Creating Forms
45	08_01-Understanding the role of forms	5.63 MB
46	08_02-Generating forms from tables	5.71 MB
47	08_03-Adjusting form elements in Layout view	7.59 MB
48	08_04-Using the Form Wizard	4.83 MB
09. Designing Forms
49	09_01-Creating forms in Design view	10.07 MB
50	09_02-Exploring the form property sheet	9.41 MB
51	09_03-Setting data sources	13.71 MB
52	09_04-Adding components with form controls	16.42 MB
53	09_05-Understanding input boxes	8.20 MB
54	09_06-Recording navigation	7.43 MB
55	09_07-Adding buttons	14.11 MB
56	09_08-Assigning tab order	11.26 MB
57	09_09-Checking out the More Forms options	17.92 MB
58	09_10-Creating a navigation form	7.62 MB
10. Creating Reports
59	10_01-Introducing reports	4.50 MB
60	10_02-Using the Report Wizard	10.09 MB
61	10_03-Creating a report in Design view	12.03 MB
62	10_04-Grouping and sorting records	10.43 MB
63	10_05-Creating calculated totals	7.69 MB
64	10_06-Applying conditional formatting rules	11.94 MB
65	10_07-Creating labels	8.44 MB
66	10_08-Adjusting print settings	6.03 MB
11. Working with Macros
67	11_01-Creating macros	10.00 MB
68	11_02-Embedding macros into buttons	15.90 MB
69	11_03-Attaching data macros to tables	16.84 MB
70	11_04-Launching macros at startup	5.93 MB
12. Integrating Access with the Office Suite
71	12_01-Exporting tables to Excel	6.06 MB
72	12_02-Emailing with macros	7.73 MB
73	12_03-Linking to data in an Outlook database	5.16 MB
74	12_04-Setting up labels and mailmerge documents in Word	5.48 MB
13. Maintaining the Database
75	13_01-Organizing the Navigation pane with custom groups	5.44 MB
76	13_02-Compacting and repairing the database	2.13 MB
77	13_03-Examining database object relationships	4.92 MB
78	13_04-Documenting your work	9.79 MB
79	13_05-Printing the blueprint of your database with the Database Documenter	5.87 MB
80	13_06-Splitting a database into front and back ends	4.45 MB
81	13_07-Protecting the database with a password	5.71 MB
82	13_08-Creating custom Ribbon tabs	8.20 MB
83	13_09-Setting startup options and custom icons	7.78 MB
14. Conclusion
84	14_01-Next steps	2.46 MB
15. فایل های تمرینی
85	Ex Files Office365 Access EssT	1.76 KB

شما می توانید مجموعه کامل بخش های این فابل را نیز به صورت مجموعه کامل دریافت نمایید.

اگر شما نسبت به این اثر یا عنوان محق هستید، لطفا از طریق "بخش تماس با ما" با ما تماس بگیرید و برای اطلاعات بیشتر، صفحه قوانین و مقررات را مطالعه نمایید.

دیدگاه کاربران

لطفا در این قسمت فقط نظر شخصی در مورد این عنوان را وارد نمایید و در صورتیکه مشکلی با دانلود یا استفاده از این فایل دارید در صفحه کاربری تیکت ثبت کنید.

(اختیاری)

تعداد کاراکتر مجاز: 1000