create account

SQL with Microsoft Access 2016 lesson 2 - Inserting records by magicmonk

View this thread on: hive.blogpeakd.comecency.com
· @magicmonk ·
$5.22
SQL with Microsoft Access 2016 lesson 2 - Inserting records
<figure class="wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio"><div class="wp-block-embed__wrapper">
https://www.youtube.com/watch?v=RF3awz2uhwo
</div></figure>
<p>

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.

</p>
 <br /><center><hr/><em>Posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://magicmonktutorials.com/blog/2019/09/22/sql-with-microsoft-access-2016-lesson-2-inserting-records/ </em>
<br />
<img src="http://magicmonktutorials.com/images/logo_medium.jpg"><br />
<b>Mathematics & Digital Technologies Education</b><br />
<b>Videos, quizzes, and other learning resources</b><br />
Eddie the Magic Monk has 14 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts. <br /> 
Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 19+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance. <br /> 
<hr/>
</center>           
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 450 others
properties (23)
authormagicmonk
permlinksqlwithmicrosoftaccess2016lesson2-insertingrecords-3vbitq4p3q
categorysteempress
json_metadata{"community":"steempress","app":"steempress","image":[""],"tags":["steempress","palnet","steemiteducation","steemstem","technology"],"canonical_url":"http://magicmonktutorials.com/blog/2019/09/22/sql-with-microsoft-access-2016-lesson-2-inserting-records/"}
created2019-09-22 10:38:36
last_update2019-09-22 10:38:36
depth0
children4
last_payout2019-09-29 10:38:36
cashout_time1969-12-31 23:59:59
total_payout_value2.441 HBD
curator_payout_value2.780 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,486
author_reputation1,107,410,202,946,554
root_title"SQL with Microsoft Access 2016 lesson 2 - Inserting records"
beneficiaries
0.
accountsteempress
weight1,500
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id90,815,413
net_rshares16,423,793,807,118
author_curate_reward""
vote details (514)
@cnbuddy ·
吃了吗?@wherein邀请您来参加[美味就是家常味](https://steemit.com/steempress/@iguazi123/28steem-4z8bo9xnbf)和[带我看看,你的城市](https://steemit.com/steempress/@iguazi123/28steem-6dudhs300h)活动,展现您的精彩生活瞬间。如果不想再收到我的留言,请回复“取消”。
properties (22)
authorcnbuddy
permlinkre-magicmonk-sqlwithmicrosoftaccess2016lesson2-insertingrecords-3vbitq4p3q-20190922t182053467z
categorysteempress
json_metadata""
created2019-09-22 18:20:54
last_update2019-09-22 18:20:54
depth1
children0
last_payout2019-09-29 18:20:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length197
author_reputation-1,449,160,991,441
root_title"SQL with Microsoft Access 2016 lesson 2 - Inserting records"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id90,828,307
net_rshares0
@steem-ua ·
#### Hi @magicmonk!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your **UA** account score is currently 4.711 which ranks you at **#1629** across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 114 contributions, your post is ranked at **#17**.
##### Evaluation of your UA score:

* Some people are already following you, keep going!
* The readers like your work!
* Try to work on user engagement: the more people that interact with you via the comments, the higher your UA score!


**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**
properties (22)
authorsteem-ua
permlinkre-sqlwithmicrosoftaccess2016lesson2-insertingrecords-3vbitq4p3q-20190922t221506z
categorysteempress
json_metadata"{"app": "beem/0.21.0"}"
created2019-09-22 22:15:06
last_update2019-09-22 22:15:06
depth1
children0
last_payout2019-09-29 22:15:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length699
author_reputation23,214,230,978,060
root_title"SQL with Microsoft Access 2016 lesson 2 - Inserting records"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id90,834,346
net_rshares0
@steemitboard ·
Congratulations @magicmonk! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

<table><tr><td><img src="https://steemitimages.com/60x60/http://steemitboard.com/img/notifications/postallweek.png"></td><td>You published a post every day of the week</td></tr>
</table>

<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@magicmonk) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=magicmonk)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>


To support your work, I also upvoted your post!


**Do not miss the last post from @steemitboard:**
<table><tr><td><a href="https://steemit.com/steemfest/@steemitboard/steemitboard-supports-the-steemfest-travel-reimbursement-fund"><img src="https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmXDHs9xfx8ZZ3DESFUqHRUQAcQT5kUWobArsRoJg2Yz1F/image.png"></a></td><td><a href="https://steemit.com/steemfest/@steemitboard/steemitboard-supports-the-steemfest-travel-reimbursement-fund">SteemitBoard supports the SteemFest⁴ Travel Reimbursement Fund.</a></td></tr></table>

###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-magicmonk-20190923t060832000z
categorysteempress
json_metadata{"image":["https://steemitboard.com/img/notify.png"]}
created2019-09-23 06:08:30
last_update2019-09-23 06:08:30
depth1
children0
last_payout2019-09-30 06:08:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,390
author_reputation38,975,615,169,260
root_title"SQL with Microsoft Access 2016 lesson 2 - Inserting records"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id90,844,139
net_rshares0
@steemstem ·
$0.09
re-magicmonk-sqlwithmicrosoftaccess2016lesson2-insertingrecords-3vbitq4p3q-20190923t222300039z
<div class='text-justify'> <div class='pull-left'> <center> <br /> <img width='200' src='https://res.cloudinary.com/drrz8xekm/image/upload/v1553698283/weenlqbrqvvczjy6dayw.jpg'> </center>  <br/> </div> 

This post has been voted on by the **SteemSTEM curation team** and voting trail. It is elligible for support from @curie and @minnowbooster.<br /> 

If you appreciate the work we are doing, then consider supporting our witness [@stem.witness](https://steemconnect.com/sign/account_witness_vote?approve=1&witness=stem.witness). Additional witness support to the [curie witness](https://steemconnect.com/sign/account_witness_vote?approve=1&witness=curie) would be appreciated as well.<br /> 

For additional information please join us on the [SteemSTEM discord]( https://discord.gg/BPARaqn) and to get to know the rest of the community!<br />

Please consider using the <a href='https://www.steemstem.io'>steemstem.io</a> app and/or including @steemstem in the list of beneficiaries of this post. This could yield a stronger support from SteemSTEM.
👍  
properties (23)
authorsteemstem
permlinkre-magicmonk-sqlwithmicrosoftaccess2016lesson2-insertingrecords-3vbitq4p3q-20190923t222300039z
categorysteempress
json_metadata{"app":"steemstem-bot"}
created2019-09-23 22:23:03
last_update2019-09-23 22:23:03
depth1
children0
last_payout2019-09-30 22:23:03
cashout_time1969-12-31 23:59:59
total_payout_value0.043 HBD
curator_payout_value0.043 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,050
author_reputation262,017,435,115,313
root_title"SQL with Microsoft Access 2016 lesson 2 - Inserting records"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id90,868,404
net_rshares407,498,339,489
author_curate_reward""
vote details (1)