In this Microsoft Access 2013 training course, expert author Guy Vaccaro teaches you how to use Access to create a database and build an interface to retrieve and report on your data. This course is designed for the absolute beginner; no prior database design or Microsoft Access experience is necessary in order to get the most out of this video tutorial.
Starting with a tour of the interface, this computer based training video will show you how …
In this Microsoft Access 2013 training course, expert author Guy Vaccaro teaches you how to use Access to create a database and build an interface to retrieve and report on your data. This course is designed for the absolute beginner; no prior database design or Microsoft Access experience is necessary in order to get the most out of this video tutorial.
Starting with a tour of the interface, this computer based training video will show you how to design and create a table, build queries, and comprehensively demonstrates the creation, and functions, of forms and reports. As you move through the video tutorial, Guy covers other topics such as; how to create advanced forms, customizing your reports, and building action queries. Finally, he will take you through the process of creating your own custom web app with Access 2013.
By the completion of this training course, you will be capable of creating databases as well as reports and forms in Microsoft Access 2013, and you will have in-depth knowledge of the tools and functions available to you in this software. Working files are included, allowing you to follow along with the author throughout the lessons.
Before We Get Started
What Is Our Target 00:03:16
Access 2013 Interface Tour 00:08:08
Managing The Navigation Pane 00:05:53
Customize The Quick Access Toolbar 00:04:46
Setting And Using A Trusted Location 00:03:18
Make A Choice From Overlapping Or Tabbed Windows 00:04:17
What Is A Custom Web App 00:03:35
Using The Working Files 00:02:22
Database Theory And Design
What Is A Database? 00:04:23
Why Do We Need A Relational Database 00:06:03
Create A Database Using Database Templates 00:05:50
Creating Your First Database 00:03:40
Tables
Data Types Explained 00:03:01
Why Do We Need A Primary Key 00:04:58
Design And Then Create Tables 00:08:00
Editing The Common Field Properties 00:07:48
Field Properties Unique To Date/Time Data Type 00:05:02
The Field Size Property 00:05:29
Using The Lookup Wizard On A Field 00:06:50
Safeguard Data Entry With Input Masks 00:09:28
Safeguard Data Using Validation Rules 00:05:29
Using The Calculated Field Type 00:04:41
Enter, Delete, And Edit Data In Tables 00:09:06
Finding And Replacing Data In A Table 00:06:48
Sorting And Filtering Data 00:06:05
Queries
Exploring Queries 00:02:35
Creating, Saving, And Running A Select Query 00:06:44
Sorting Data Within Queries 00:05:21
Filtering Text Fields 00:06:09
Operators For Numeric Filtering 00:05:57
Querying Date/Time Fields 00:07:00
Use Of Wildcards In Criteria 00:06:19
Locating Empty Fields: Is Null 00:03:30
Multiple Criteria On The Same Fields: Or 00:04:48
Multiple Criteria On Different Fields: And 00:06:13
Why Do I Need SQL View? 00:06:35
Add Calculating Fields To A Query 00:09:00
Using Text Fields In Calculated Fields 00:05:10
Calculated Fields Based On Date/Time Fields 00:07:03
Calculating Age With A Query 00:05:58
Producing Totals In Access 00:06:46
Forms
Using The Wizard To Create A Form 00:06:21
The Super Quick Form 00:03:41
Viewing, Editing, And Deleting Records 00:05:23
Adding Records Through Forms 00:05:17
Searching For Records 00:04:26
Sorting And Filtering Records 00:05:57
Layout And Design View Explained 00:05:55
Adding Colour To Forms 00:06:21
Adding Fields And Controlling Alignment And Spacing 00:06:52
Controlling Tab Order Of Added Fields 00:04:22
Add Images To Forms 00:04:32
Adding Calculated Fields 00:08:55
Reports
Creating A Report Using The Wizard 00:07:03
Grouping Within Wizard Reports 00:06:29
A Report In A Hurry: Quick Report 00:04:32
Editing The Layout Of A Wizard Generated Report 00:07:35
Print Or Convert A Report To PDF 00:05:16
Multiple Table Databases
Designing A Multi-Table Database 00:09:41
Relationships Between Tables 00:03:11
Creating Relationships In Access 00:06:36
Why Do I Need Referential Integrity? 00:06:55
The Subdatasheet Tool 00:04:38
Queries With Multiple Tables 00:06:21
More Than One Table In A Form 00:07:48
Reports On Multiple Tables 00:07:28
Database Normalization
What Is Database Normalizatio 00:02:49
Normalizing The Customer Database 00:09:08
Advanced Tables
Using Lookups In Data Tables 00:08:29
Converting Access Databases Between Versions 00:04:55
Introduction To Indexing Fields 00:08:32
Using More Than One Field As The Primary Key 00:04:34
Creating And Printing Relationship Reports 00:04:18
Importing Or Linking Data Into Access From Access 00:04:33
Importing And Linking Excel Data 00:06:36
Importing Data From Text Files 00:04:24
Advanced Select Queries
Using More Than One Table In A Query 00:07:02
Changing The Join Type Of Links In Queries 00:03:53
Watch Out For Cartesian Or Cross Join 00:04:00
Using Parameters In Queries 00:06:12
The Crosstab Query 00:06:30
Action Queries
Make A New Table From A Query 00:07:44
Update Queries For Amending Data 00:08:20
Appending Records To A Table 00:07:44
The Powerful Delete Query 00:06:15
Advanced Forms
Adding A Subdatasheet Or Subform 00:05:00
Creating A Form Without The Wizard 00:06:34
Add A Drop Box (Combo Box) 00:06:25
Special Use Of A Combo Box 00:04:58
Using A Blank Form As A Menu 00:06:43
Advanced Reports
Creating A Blank Report Without The Wizard 00:07:30
Sorting Records In A Report 00:03:03
Grouping Within Reports 00:05:49
Adding Calculated Fields 00:06:34
Creating And Using A Subreport 00:06:24
Add Summaries To Groups 00:07:31
Custom Web Apps
Prerequisites For Running A Custom Web App 00:02:18
Creating Your First Web App 00:06:49
Adding Tables To The Web App 00:04:17
Create And Edit Views 00:06:35
Queries Are Possible In Web Apps 00:04:37
Add A Blank Menu Form 00:04:14
Conclusion
Summary And Beyond 00:04:02
About The Author 00:01:39