2013
Lynda
Adam Wilbert
5:04
English
Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.
Introduction 1m 47s
Welcome 1m 5s
Using the exercise files 42s
1. Getting Started 23m 43s
Key database concepts 4m 21s
Launching Access and the Backstage screen 1m 41s
Creating the database file 3m 25s
Understanding the Trust Center 3m 2s
Digging in to Ribbon tabs 3m 39s
Using the Navigation pane 3m 36s
Using the Quick Access Toolbar 1m 14s
Signing in to Microsoft Live 50s
Taking backups 47s
Accessing help 1m 8s
2. Creating Tables 23m 54s
Understanding table structure and relationships 4m 18s
Creating a table and setting data types 4m 15s
Entering data 4m 0s
Understanding primary and foreign keys 6m 24s
Importing tables 4m 57s
3. Setting Field Properties 29m 37s
Establishing relationships and maintaining referential integrity 6m 28s
Editing table structure in Design view 3m 58s
Controlling input with masks 5m 4s
Setting the default value 2m 15s
Establishing validation rules 3m 21s
Creating lookup fields 4m 29s
Setting additional field properties 4m 2s
4. Organizing Records 11m 3s
Formatting columns 2m 52s
Sorting table data 3m 18s
Filtering table data 2m 21s
Searching and replacing values 2m 32s
5. Using Queries 39m 35s
Understanding queries 2m 2s
Creating queries with the Simple Query Wizard 4m 24s
Building queries in Design view 4m 58s
Establishing constraints with criteria 4m 14s
Specifying criteria with wildcards 3m 50s
Leveraging multiple criteria with AND and OR statements 4m 32s
Filtering with mathematical comparisons 2m 20s
Creating flexible queries with parameter requests 3m 45s
Building expressions 5m 23s
Obtaining summary statistics 4m 7s
6. Working with Specialty Queries 19m 13s
Using update queries 3m 21s
Using make table queries 2m 57s
Using delete queries 2m 48s
Using append queries 2m 49s
Getting a different look with crosstab queries 2m 58s
Creating a union query in SQL view 4m 20s
7. Creating Forms 12m 47s
Understanding the role of forms 2m 52s
Generating forms from tables 3m 10s
Adjusting form elements in Layout view 4m 7s
Using the Form Wizard 2m 38s
8. Designing Forms 44m 23s
Creating forms in Design view 3m 50s
Exploring the form property sheet 3m 13s
Setting data sources 5m 39s
Adding components with form controls 6m 8s
Understanding input boxes 3m 31s
Recording navigation 2m 36s
Adding buttons 4m 18s
Assigning tab order 4m 5s
Checking out the More Forms options 7m 27s
Creating a navigation form 3m 36s
9. Creating Reports 32m 56s
Introducing reports 2m 15s
Using the Report Wizard 5m 9s
Creating a report in Design view 5m 20s
Grouping and sorting records 4m 5s
Creating calculated totals 3m 32s
Applying conditional formatting rules 5m 19s
Creating labels 4m 18s
Adjusting print settings 2m 58s
10. Working with Macros 25m 0s
Creating macros 5m 3s
Embedding macros into buttons 7m 50s
Attaching data macros to tables 9m 5s
Launching macros at startup 3m 2s
11. Integrating Access with the Office Suite 12m 12s
Exporting tables to Excel 3m 8s
Emailing with macros 4m 4s
Linking to data in an Outlook database 2m 18s
Setting up labels and mail-merge documents in Word 2m 42s
12. Maintaining the Database 27m 23s
Organizing the Navigation pane with custom groups 2m 59s
Compacting and repairing the database 1m 20s
Examining database object relationships 2m 58s
Documenting your work 4m 41s
Printing the blueprint of your database with the Database Documenter 2m 40s
Splitting a database into front and back ends 2m 33s
Protecting the database with a password 2m 55s
Creating custom Ribbon tabs 3m 35s
Setting startup options and custom icons 3m 42s
Conclusion 1m 6s
Next steps 1m 6s
http://www.lynda.com/Access-tutorials/Access-2013-Essential-Training/115857-2.html

Download File Size:876.38 MB

---