【教程】Access 2016 基础教程 (Lynda 无字幕)

01_01-Welcome

01_02-Using the exercise files

01_03-Challenges explained

02_01-Key database concepts

02_02-Launching Access and the backstage screen

02_03-Creating the database file

02_04-Understanding the Trust Center

02_05-Digging into Ribbon tabs

02_06-Using the Navigation pane

02_07-Using the Tell Me feature

02_08-Using the Quick Access Toolbar

02_09-Signing in to a Microsoft account

02_10-Making backups

02_11-Accessing Access help

03_01-Understanding table structure and relationships

03_02-Creating a table and setting data types

03_03-Entering data

03_04-Understanding primary and foreign keys

03_05-Importing tables

04_02-Editing table structure in Design view

04_03-Controlling input with masks

04_04-Setting the default value

04_05-Establishing validation rules

04_06-Creating lookup fields

04_07-Setting additional field properties

04_08-Challenge Creating tables

04_09-Solution Creating tables

05_01-Formatting columns

05_02-Sorting table data

05_03-Filtering table data

05_04-Searching and replacing values

06_01-Understanding queries

06_02-Creating queries with the Simple Query Wizard

06_03-Building queries in Design view

06_04-Establishing constraints with criteria

06_05-Specifying criteria with wildcards

06_06-Leveraging multiple criteria with AND and OR statements

06_07-Filtering with mathematical comparisons

06_08-Creating flexible queries with parameter requests

06_09-Building expressions

06_10-Obtaining summary statistics

06_11-Challenge Creating queries

06_12-Solution Creating queries

07_01-Using update queries

07_02-Using make table queries

07_03-Finding unmatched records

07_04-Using delete queries

07_05-Using append queries

07_06-Creating a union query in SQL view

07_07-Getting a different look with crosstab queries

08_01-Understanding the role of forms

08_02-Generating forms from tables

08_03-Adjusting form elements in Layout view

08_04-Using the Form Wizard

09_01-Creating forms in Design view

09_02-Exploring the form property sheet

09_03-Setting data sources

09_04-Adding components with form controls

09_05-Understanding input boxes

09_06-Record navigation

09_07-Adding buttons

09_08-Assigning a tab order

09_09-Checking out the More Forms options

09_10-Creating a navigation form

09_11-Challenge Creating forms

09_12-Solution Creating forms

10_01-Introducing reports

10_02-Using the Report Wizard

10_03-Creating a report in Design view

10_04-Editing a report in Layout view

10_05-Grouping and sorting records

10_06-Creating calculated totals

10_07-Applying conditional formatting rules

10_08-Creating labels

10_09-Adjusting print settings

10_10-Challenge Creating reports

10_11-Solution Creating reports

11_01-Creating macros

11_02-Embedding macros into buttons

11_03-Attaching data macros to tables

11_04-Launching macros at startup

12_01-Exporting tables to Excel

12_02-Emailing with macros

12_03-Linking to data in an Outlook database

12_04-Setting up labels and mail merge documents in Word

13_01-Organizing the Navigation pane with custom groups

13_02-Compacting and repairing the database

13_03-Examining database object dependencies

13_04-Documenting your work

13_05-Printing the blueprint of your database with the Database Documenter

13_06-Splitting a database into front and back ends

13_07-Protecting the database with a password

13_08-Creating custom Ribbon tabs

13_09-Setting startup options and custom icons

14_01-Next steps