MS Access - Queries Part 1: Basic queries
HTML-код
- Опубликовано: 1 авг 2024
- Queries are a way of taking the mass amounts of data in a table, and getting just the data you are looking for based on specific criteria. This query can then be saved and accessed and edited at a later time. This video shows you the basics of queries and how to create and edit them.
Microsoft Access Queries Video Series
Part 1 Basic queries - • MS Access - Queries Pa...
Part 2 BETWEEN and IN in queries - • MS Access - Queries Pa...
Part 3 LIKE and NULL in queries - • MS Access - Queries Pa...
Part 4 Separate queries - • MS Access - Queries Pa...
Part 5 Grouping in queries - • MS Access - Queries Pa...
Part 6 Calculated Fields in queries - • MS Access - Queries Pa...
Part 7 More Examples of Calculated Fields - • MS Access - Queries Pa...
#MrLongEducation #Access #Query
MR Long coming in clutch for my finals
As a Grade 12 student, this helped me so much. Thank you
True😭i feel ready for finals
@@Nique-OTB This is honestly saving my grade😭
We Writing today in 8 hrs
this was explained so well, this is very helpful. thanks
“I’d be nothing, nothing , nothing with out you”
Thanks Guruji ( An Indian respective word for a great teacher!) :)
Very understandable and informative
Very informative, Thanks
ALL WORKING THANK YOU SOOOOOO MUCH BRO LOVE YOU PROFESSIONAL UNLIMITED ALL WORKING WELLL
Never seen a better explanation.woow..thank u
I'm glad it helped :)
sir you are saving my life. Thank you so much
Glad you find the videos helpful!
Thanks it's a good lesson
a life saver mate
the goat 🐐 thanks a lot man
You're the best❤
Hi,
I might sound crazy, but I had to set up another Database recently which I hadn't done for a while.
I created the Form that I wanted.
To save any change I clicked on the Save Icon at the top left of the Form page.
The problem is that it saved a duplicate page everytime!!
I now have a lot of duplicates in the Form which I have no idea how to get rid of.
Please can you help get rid of the duplicates and let me know what I am doing wrong.
Many thanks. Gordon
hayee Allah g
Is there a way to have calculated field that tells me the number of days that have passed since a reference date? For examples, I want to make sure that no projects are older than 60 days. If I have a field that has the date the project was submitted, is there a formula to have it tell me how many days old the project is?
If you subtract two dates the answer will be the number of days between the two dates. So you can use the Date() function to get the current date. For example: = DATE() - [DateSumitted]
Assuming the field DateSUbmitted is the project date then you can make the criteria for the calculated field to be
Hi, I'm from Brazil and I'm subscribed to your channel.
I like the content, because I am learning Delphi.
I would like to know if it is true that Access has limitations on the amount of data inserted in the database.
This is true? Is it possible to solve this?
Thank you!
Hi. Access has a limitation of storing 2 GB of data, which is quite a lot of data. Not much to get around it. You can make your field sizes of your text fields smaller, and use smaller number formats to conserve space. Other option is to use different database software if you want more than 2 GB of data space.
@@MrLongITandCAT i think he upload lots of aatachment in db, it's better to save attachments on a folder and use hyperlink
I need data to practice.
Check out our exam paper walkthroughs for CAT. Question 5 is normally the Access database question. Data files can be downloaded using the links in the description.
Are you South African?
Yes :)