SQL with Microsoft Access 2016 lesson 2 - Inserting records

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=RF3awz2uhwo


Duration: 5:32
162,268 views
962

In this video we cover the Insert Into SQL statement to insert some data into a table. We ran into some problems already - some phone numbers got stripped off a zero at the front, and it accepted some numbers with incorrect number of digits. All these will be fixed in the next tutorial.



Other Videos By Magic Monk


2016-03-07SQL with Microsoft Access 2016 Lesson 11 - Joining tables
2016-03-07SQL with Microsoft Access 2016 Lesson 10 - Group By, Max, Min, Average
2016-03-07SQL with Microsoft Access 2016 Lesson 9 - Arithmetical operators, functions
2016-03-07SQL with Microsoft Access 2016 Lesson 8 - Sorting
2016-03-06SQL with Microsoft Access 2016 Lesson 7 - Subqueries
2016-03-06SQL with Microsoft Access 2016 Lesson 6 - In, Between, Brackets
2016-03-06SQL with Microsoft Access 2016 Lesson 5 - AND, OR, LIKE
2016-03-06SQL with Microsoft Access 2016 Lesson 4 - Select query
2016-03-06Samsung Galaxy S5 phone case doesn't fit
2016-03-05SQL with Microsoft Access 2016 lesson 3 - Alter Table
2016-03-05SQL with Microsoft Access 2016 lesson 2 - Inserting records
2016-03-05SQL with Microsoft Access 2016 lesson 1 - Create table
2016-03-04Installing Office We'll be done in just a moment
2016-03-04Automatic configuration of the current version of Microsoft Access has failed
2016-03-04Income lesson 4 - Working overtime
2016-03-03Income lesson 3 - Commission and royalties
2016-03-03Income Lesson 2 - Wages and Allowances
2016-03-03Income Lesson 1 - Salary
2016-03-02Pythagoras theorem explained + practice questions
2016-03-02Degrees, minutes, seconds angle conversion demonstration / explanation
2016-03-01Hard simultaneous equation problem solving question involving speed and quadratics


Tags:
SQL insert into
SQL microsoft access