Microsoft Access Essential Training (Office 2021/LTSC)
Focused View
4:38:30
341 View
01 - Building databases with Access.mp4
00:58
02 - What you should know.mp4
00:56
01 - Building Access databases.mp4
05:16
02 - Relational database concepts.mp4
04:51
03 - Create the database file.mp4
04:33
04 - All about the Trust Center.mp4
04:10
05 - Digging into ribbon tabs.mp4
06:47
06 - The database Navigation Pane.mp4
04:56
07 - Customize the Quick Access Toolbar.mp4
02:17
08 - Create a database backup.mp4
01:05
01 - Table structures and relationships.mp4
07:59
02 - Create a table and set data types.mp4
06:12
03 - Enter data.mp4
05:22
04 - Primary and foreign keys.mp4
05:48
05 - Importing tables.mp4
06:27
01 - Relationships and referential integrity.mp4
07:28
02 - Editing table structure in Design view.mp4
06:13
03 - Control input with masks.mp4
04:50
04 - Set a default value.mp4
03:34
05 - Data validation rules.mp4
05:31
06 - Data lookup fields.mp4
04:04
07 - Additional field properties.mp4
05:43
01 - Sorting table data.mp4
04:19
02 - Filtering table rows.mp4
03:28
03 - Deleting records.mp4
02:43
01 - What are queries.mp4
04:45
02 - The Simple Query Wizard.mp4
05:59
03 - Build queries in Design view.mp4
07:29
04 - Establishing constraints with criteria.mp4
05:50
05 - Specifying criteria with wildcards.mp4
04:35
06 - Incorporating AND and OR statements.mp4
06:43
07 - Filtering with mathematical comparisons.mp4
02:42
08 - Create flexible queries with parameters.mp4
04:58
09 - Build expressions.mp4
06:20
10 - Obtain summary statistics.mp4
06:35
01 - Understand the role of forms.mp4
02:39
02 - Generate forms from tables.mp4
06:06
03 - Adjusting form elements in Layout view.mp4
06:17
04 - Using the Form Wizard.mp4
04:22
05 - Form Design view.mp4
05:56
06 - Find records.mp4
06:36
01 - Introducing reports.mp4
05:35
02 - The Report Wizard.mp4
04:08
03 - Edit a report in Design view.mp4
08:58
04 - Edit a report in Layout view.mp4
04:59
05 - Group and sort records.mp4
06:46
06 - Creating calculated totals.mp4
02:42
07 - Apply conditional formatting rules.mp4
07:49
08 - Adjust print settings.mp4
04:03
01 - Customize groups in the Navigation Pane.mp4
03:26
02 - Compact and repair the database.mp4
01:43
03 - Examine database object relationships.mp4
03:38
04 - Document your thought process.mp4
03:44
05 - Print the blueprint of your database.mp4
04:02
06 - Split a database into front and back ends.mp4
04:27
07 - Protect the database with a password.mp4
03:37
08 - Set startup options.mp4
04:06
01 - Next steps.mp4
01:25
Description
Learn how to build Access databases to store and retrieve your data more efficiently. In this course, Access expert Adam Wilbert explains the concepts behind relational databases, before moving on to 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. Adam 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.
More details
User Reviews
Rating
average 0
Focused display
Category
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 58
- duration 4:38:30
- Release Date 2023/01/18
