Access 2016 - How to Make a Database - Part 4 - Queries

We will look at two types : Select Queries and Update Queries.

[@mcjacko3747]

Your access series is so helpful! Much better than any other ones I've watched. Nice job.

[@azahrakeith1568]

You are fantastic. No fluff and straight to the point

[@AreebSuhail19]

Thanks for the time you put into this series!

[@michihyde8433]

Perfect introduction series. Thank you!

[@brianabecerra2952]

Fantastic job of introducing me to Access. Subscribed and look forward to any videos showing me how to transfer my visual studio database to Access hopefully with my indexes and procedures?. Thanks!

[@koreyphan]

Thank you for the videos! They are great and have helped me learn Access.

[@smile.6108]

Thank you so much, you were moderate enough in speech for me to understand and grasp what you were explaining .

[@aishiteru-od4im]

thank you for this tutorial.. i was able to make my project.. yeheey.

[@mcheng7021]

Thanks for this! I am stuck with my DBMS assignment and I found this really helpful

[@krismaly6300]

I enjoyed watching this video and recommend to others Host seem to be an expert in Access Database Teacher tone is also good Please keep post some more videos Thanks for educating the community and appreciate your volunteership. Than a bunch

[@alizhanaskargaliyev7422]

tnx! very useful tutorial,keep it up

[@joedou6922]

I have a question. I have two dataset of our customers in 2016 and 2017. There are duplicates because some of the records were updated both in 2017 and before 2016. I have columes of customer ID(which is how I find duplicates) and update date. So how can I append and delete the duplicates before 2016? I think delete query might help but dont know how. Thanks!!

[@moonene3197]

useful....

[@TAINTxSTAIN]

thank you so much learnt alot today

[@annaovs2209]

Thank you!

[@jacquelinewellington4889]

How to you merge large multiples of spreadsheet into one data with different columns header

[@reyniertasico1119]

Got a problem with creating queries and the running. Hue hue. I got this blank.

[@ariostecellquest2839]

Hi and thanks for your tutorial. I'm watching it in order to find out whether Access would be an interesting solution for the creation of terminological records, which would be a kind of bilingual dictionary, each record containing info on a single term in two or more languages. So, after watching your tutorial, I'm wondering how querying would work. Basically I would need to look up a word just like in any dictionary, but this word could either be a main term or a keyword from another field in my record template, as opposed to a selection of types of fields like you just showed. Would that be possible at all? Thanks in advance for your answer!

[@designanddeploy5991]

This might help. The specific example is city/state but you may be able to adjust it for your purposes. So rather than city and state it would be target language and term that is being researched. kzbin.info/www/bejne/aZ3NoH6XiJuAb7M

[@805surfgirl]

How do you add a find a record field. Also how do you have multiple forms that are connected to each other. Example I have a database that the first form I just want to enter the practice location. I have a second form for the provider office. But to get to my second form i have to click on the form and perform a search of the provider.

[@nixwhat]

Nice Video! Do you know if there is a way to prevent it from allowing duplicate values? like having EMP103 for 2 different people?

[@designanddeploy5991]

When you have the table in Design View, at the bottom there are several properties. One is the Indexed property that defaults to No but you can change to Yes-No Duplicates.

[@icepack7336]

Hey Great Tutorial However I recently have had a project for designing a database for a videogame hire store i am making a query and i want it to show all games that arent occupied(being rented out) I know you have to link the Customer ID to another table then make a query from there but i cant seem to work it out Nevermind Figured it out still great vids :)

[@emmavanveckhoven7702]

Back on video one or two how do you remove a relation if you need to edit

[@huisun1371]

Could you please help to clarify: When using the Select Queries, is there a way to search for part of the entry? for example, in the original table the values are "Professor", if use "Prof" as Criteria no items will be found, it seems only can search for the exact match. Thank you very much!

[@chriszhang3079]

I think you can use LIKE "Prof*" as your criteria. other DBMS may have different syntax.

[@muhtadialbandar9549]

Let's say i had a table which documented movies and their ID's. How do i create a query that DELETES a movie by giving a movie id via criteria. The hope is that the query will delete the movie record from the table.

[@designanddeploy5991]

Here you go : kzbin.info/www/bejne/gHbcYaiLfr6YjpY

[@tboyleterp]

Access cross tab query

[@gerbenpol2887]

I followed your course, thanks for that! but i have an question: i dont get it to work: i can make a search query, also within a form, with different search options: like type, gender, name etc..etc.. but i want to have them work independently, like one time i want to search on gender and name, but another time just on name and type of account. how can i do that?

[@designanddeploy5991]

I haven't tried it but I am wondering if you could use one combo box to set the data source for another. So, the first combo you would chose (for example) Gender and that would set the values for the second. That may require setting up a whole new table with all the possible combinations.

[@gerbenpol2887]

@@designanddeploy5991 that could work, but than im still bound by the value in the first combobox. what i want, is 3 comboboxes, all linked in a database. but if i dont need to, i dont want to fill in all parameters, there must be filled in 1, and max 3. so if there is an option to tell the query the value must be X or blank. that would work i think

[@edithbarragan2694]

Can you please help me to know how to update a table by changing the fild value from a query datasheet.?

[@designanddeploy5991]

When you run a query, if you change the value of a field in the results, it changes it in the corresponding table unless the query is run in read only mode.

[@edithbarragan2694]

thanks so much

[@jodiewhite7718]

I am trying to create a database that will track loyalty points for a client. It will need to add points as they earn them and subtract them as they use them. does that sound remotely possible? :)

[@designanddeploy5991]

Depends. Manually changing, yes very easy. That is just data entry via a Form which I have several tutorials about. However, if you're looking for integration with a POS system, I am quite underqualified to assist.

[@jodiewhite7718]

Game Design HQX I actually would be keying in the info thru a form. Would I be able to have a cell that calculates and displays the sum of the entries? If so...please direct me to those tutorials!

[@ordemeprogresso12]

@@jodiewhite7718 7 months too late probably but you can set fields to be "calculated" and then use an =IIf expression to automatically calculate the loyalty points

[@jeffroll7878]

Question, I'm trying to create some kind of report or query that you basically select said thing from a drop down menu and all things that it's applicable to show in a table or report. Any suggestions on how to go about that process?

[@designanddeploy5991]

Something like this? kzbin.info/www/bejne/Y36qoGaoaLKirpo

[@jeffroll7878]

Game Design HQX Exactly, thanks man

[@gurdevsingh9707]

Is it possible to operate on android phone?

[@designanddeploy5991]

To the best of my knowledge Access does not run on Android.

[@Scottiesabeast]

Resident evil names 🤣

[@sanjivsharan]

Thank you. A very helpful presentation. In my database I have created a table CompanyMaster and appended data from excel using inbuilt wizard. Now I added a few records to that table manually. However in my query on another table TradeDeal , which is linked to a field in CompanyMaster, the newly added records are not being sorted with earlier existing records. They are being placed at bottom if sorted ascending and at top if being sorted descending manner. What could be the mistake in my table. Or the query ?