페이지 정보

작성자행복발전소 조회 16회 작성일 2020-11-27 17:45:19 댓글 0


16. Microsoft Access 2016: Using Logical Operators (AND & OR) In SQL

In this video on Microsoft Access 2016: Using Logical Operators (AND \u0026 OR) In SQL, Steve Bishop gives you a tutorial on how to filter your table data using logical operators such as AND and OR in a SQL query. After watching this lesson you will know how to find records according to multiple criteria in your tables. You will also know how to group logical operators to ensure the data results are correctly identified.

This how to video tutorial is part of a series of videos that are tutorials on various topics involving Access 2016, visual basic for applications (vba), structured query language (SQL), and basic form design (UI). These lessons on Access 2016 will help you create applications for your business or personal use that will make you more efficient at organizing your data.

Click here for the Work Files for this series:

Click here for the Microsoft Access 2016 Basics Playlist:

#MicrosoftAccess #VBA #SQL #Access2016 #Programming
Become a member today for only $5 a month!

When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

Coffee With Steve:

Access 2016 for Beginners Part 16: Compact and Repair an Access 2016 Database

Get my FREE 3-hour MS Access 2016 for beginners course here ►

Get the complete 9-hour Access 2016 training course here ►

Get the complete 8-hour Access 2016 advanced course here ►

During this Microsoft Access 2016 training tutorial video, we will talk about how to compact and repair a database. This is very useful in repairing corrupted files or broken database without having to restore.

Checkout some of our other training on YouTube:

Access 2016 training tutorials:

PowerPoint 2016 training tutorials:

VBA for Excel tutorials:

Excel 2016 training for beginners:

Project 2016 training:

Stay in touch:
YouTube Channel:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Welcome back to our course on Access 2016.
In the preceding section we talked about backups. And it’s absolutely essential that you get a backup regime in place before your Access databases start having too much of your time and effort invested into them. Something else you need to know about is the fact that over time Access databases can become what we call bloated. I’ll come back to bloated in a moment. And also over time you may get to situations where your databases get broken in some way. Now I mentioned databases getting broken in the preceding section in relation to needing to restore a database. But sometimes when a database gets broken it’s possible to repair it without having to restore. So in this section we’re going to talk about compact and repair.

Now once again there’s a very good Help topic that gives you the background information on compact and repair. And first of all let’s talk about compact.

Now as it says here database files grow with use. Generally speaking as you store more and more data it’s not surprising that an ACCDB file gets bigger. But when you delete records from tables in an Access database the space is not automatically reclaimed. It just occupies what is in effect empty space. There are also various pieces of coded data that Access uses when it’s working on a database. And over time some of these which strictly speaking could be deleted are not deleted. And we get this effect called Bloat. And in order to remove the unneeded, unused, wasted space you compact a database. And compacting not only reduces the size of the database file but it can improve the speed of performance as well.

Now the other factor here is that database files can become corrupted. There are various ways that corruption can happen. Many of them are associated with an incomplete write to a database. So you only get part of some data written to a database. There are some ways of minimizing the chance of this happening but it still happens from time to time and there are certain situations when it happens most often. For instance if you’re using a network database and a network connection is broken, maybe you’re connected to a database over a network and your connection is broken. You might also, for instance, have a situation where you’re using linked tables that I explained earlier in the course. And the database or computer or server which is holding the tables you’re linked to gets rebooted. Somebody doesn’t realize that somebody else is linked to those tables. So that computer gets restarted and corruption occurs.

Now if a database file becomes corrupted sometimes Access will realize that corruption has happened and it will prompt you to repair the database file. Sometimes it doesn’t realize that the database is corrupted. Sometimes you’ll be able to carry on happily working on a database for a long period of time doing lots of things to it without realizing that it’s actually corrupted.

Now one way of dealing with both the bloat problem and any corruptions is to run a process called Compact and Repair. Now you would definitely run this if Access said that it believed that there was a corruption. But you should also run it as part of a general regular maintenance procedure.

Now to run a compact and repair it’s actually pretty straight

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.

Access 2016 - How to Make a Database - Part 1 - Tables

Audio vastly improves beginning with Part 3. However, here is an updated version:

Creating and linking tables.

I have added some one-off videos for features that can be added whenever. Here is one for a City/State selector :




등록된 댓글이 없습니다.

전체 1,317건 1 페이지
게시물 검색
Copyright © All rights reserved.  Contact :