Access 2016基础教程
本课程共96集 翻译完 欢迎学习
课程介绍：Lynda Access 2016 Essential Training Tutorial
立即播放
用手机看
课程免费缓存，随时观看～
扫码下载网易公开课APP
收藏
课程列表
【第1集】_01-Welcome 译
【第2集】_02-Using the exercise files 译
【第3集】_03-Challenges explained 译
【第4集】_01-Key database concepts 译
【第5集】_02-Launching Access and the backstage screen 译
【第6集】_03-Creating the database file 译
【第7集】_04-Understanding the Trust Center 译
【第8集】_05-Digging into Ribbon tabs 译
【第9集】_06-Using the Navigation pane 译
【第10集】_07-Using the Tell Me feature 译
【第11集】_08-Using the Quick Access Toolbar 译
【第12集】_09-Signing in to a Microsoft account 译
【第13集】_10-Making backups 译
【第14集】_11-Accessing Access help 译
【第15集】_01-Understanding table structure and relationships 译
【第16集】_02-Creating a table and setting data types 译
【第17集】_03-Entering data 译
【第18集】_04-Understanding primary and foreign keys 译
【第19集】_05-Importing tables 译
【第20集】_01-Establishing relationships and maintaining referential integrity 译
【第21集】_02-Editing table structure in Design view 译
【第22集】_03-Controlling input with masks 译
【第23集】_04-Setting the default value 译
【第24集】_05-Establishing validation rules 译
【第25集】_06-Creating lookup fields 译
【第26集】_07-Setting additional field properties 译
【第27集】_08-Challenge Creating tables 译
【第28集】_09-Solution Creating tables 译
【第29集】_01-Formatting columns 译
【第30集】_02-Sorting table data 译
【第31集】_03-Filtering table data 译
【第32集】_04-Searching and replacing values 译
【第33集】_01-Understanding queries 译
【第34集】_02-Creating queries with the Simple Query Wizard 译
【第35集】_03-Building queries in Design view 译
【第36集】_04-Establishing constraints with criteria 译
【第37集】_05-Specifying criteria with wildcards 译
【第38集】_06-Leveraging multiple criteria with AND and OR statements 译
【第39集】_07-Filtering with mathematical comparisons 译
【第40集】_08-Creating flexible queries with parameter requests 译
【第41集】_09-Building expressions 译
【第42集】_10-Obtaining summary statistics 译
【第43集】_11-Challenge Creating queries 译
【第44集】_12-Solution Creating queries 译
【第45集】_01-Using update queries 译
【第46集】_02-Using make table queries 译
【第47集】_03-Finding unmatched records 译
【第48集】_04-Using delete queries 译
【第49集】_05-Using append queries 译
【第50集】_06-Creating a union query in SQL view 译
【第51集】_07-Getting a different look with crosstab queries 译
【第52集】_01-Understanding the role of forms 译
【第53集】_02-Generating forms from tables 译
【第54集】_03-Adjusting form elements in Layout view 译
【第55集】_04-Using the Form Wizard 译
【第56集】_01-Creating forms in Design view 译
【第57集】_02-Exploring the form property sheet 译
【第58集】_03-Setting data sources 译
【第59集】_04-Adding components with form controls 译
【第60集】_05-Understanding input boxes 译
【第61集】_06-Record navigation 译
【第62集】_07-Adding buttons 译
【第63集】_08-Assigning a tab order 译
【第64集】_09-Checking out the More Forms options 译
【第65集】_10-Creating a navigation form 译
【第66集】_11-Challenge Creating forms 译
【第67集】_12-Solution Creating forms 译
【第68集】_01-Introducing reports 译
【第69集】_02-Using the Report Wizard 译
【第70集】_03-Creating a report in Design view 译
【第71集】_04-Editing a report in Layout view 译
【第72集】_05-Grouping and sorting records 译
【第73集】_06-Creating calculated totals 译
【第74集】_07-Applying conditional formatting rules 译
【第75集】_08-Creating labels 译
【第76集】_09-Adjusting print settings 译
【第77集】_10-Challenge Creating reports 译
【第78集】_11-Solution Creating reports 译
【第79集】_01-Creating macros 译
【第80集】_02-Embedding macros into buttons 译
【第81集】_03-Attaching data macros to tables 译
【第82集】_04-Launching macros at startup 译
【第83集】_01-Exporting tables to Excel 译
【第84集】_02-Emailing with macros 译
【第85集】_03-Linking to data in an Outlook database 译
【第86集】_04-Setting up labels and mail merge documents in Word 译
【第87集】_01-Organizing the Navigation pane with custom groups 译
【第88集】_02-Compacting and repairing the database 译
【第89集】_03-Examining database object dependencies 译
【第90集】_04-Documenting your work 译
【第91集】_05-Printing the blueprint of your database with the Database Documenter 译
【第92集】_06-Splitting a database into front and back ends 译
【第93集】_07-Protecting the database with a password 译
【第94集】_08-Creating custom Ribbon tabs 译
【第95集】_09-Setting startup options and custom icons 译
【第96集】_01-Next steps 译
查看全部课程
相关推荐
