Lisa Friedrichsen

5:19

Microsoft Access: Modifying values in the drop-down list of a Lookup field

7 ай бұрын

4:21

Microsoft Access: Modifying a Lookup field by adding a column to a drop down list

7 ай бұрын

8:39

Microsoft Access: Creating a Lookup table (breaking a single table into two related tables)

7 ай бұрын

9:01

Microsoft Access: Analyzing table relationships in the Nutrition tracking template

9 ай бұрын

3:38

Microsoft Access: Studying the table relationships in the Vehicle maintenance template

9 ай бұрын

6:18

Microsoft Access: Enforcing referential integrity, the cascade options, and orphan records

9 ай бұрын

4:54

Microsoft Access: Analyzing 1-to-many and many-to-many relationships using Students and Classes

10 ай бұрын

5:37

Microsoft Access: 1-to-1, 1-to-many, and many-to-many relationships

10 ай бұрын

3:20

Microsoft Access: What is a relational database and why are one-to-many relationships important?

10 ай бұрын

1:08

Microsoft Access: How to add or edit the Caption on a form or report tab

10 ай бұрын

3:39

Microsoft Access: Fixing a report that is too wide (or prints blank pages)

10 ай бұрын

2:42

Microsoft Access: "Data Integrity Rules Have Changed" message and the Validation Rule property

10 ай бұрын

2:41

Microsoft Access: Understanding and fixing the "Data type mismatch" error message

10 ай бұрын

2:51

Microsoft Access: The error message "Some Data May Be Lost" - calculating the length of a text field

10 ай бұрын

4:49

Microsoft Access: How to display the expand / collapse buttons to display a table subdatasheet

10 ай бұрын

3:22

Microsoft Access: What is the .laccdb file and how do I use it?

10 ай бұрын

4:28

Microsoft Access: Troubleshooting poor Access database application performance

10 ай бұрын

3:15

Microsoft Access: The SQL statement could not be executed - ambiguous outer joins

11 ай бұрын

1:21

Microsoft Access: Troubleshooting a query that selects fewer fields than expected

11 ай бұрын

4:24

Microsoft Access: Troubleshooting a query that selects fewer records than expected

11 ай бұрын

4:27

Microsoft Access: Troubleshooting a query that selects too many records

11 ай бұрын

2:29

Microsoft Access: Troubleshooting a query that displays too many fields

11 ай бұрын

2:19

Microsoft Access: Fixing the #Name? Error

11 ай бұрын

2:51

Microsoft Access: Enter Parameter Value dialog box (on a form or report)

11 ай бұрын

1:10

Microsoft Access: Missing Query Grid

11 ай бұрын

1:39

Microsoft Access Query Error: Enter Parameter Value

11 ай бұрын

1:47

Microsoft Access: The specified field could refer to more than one table

11 ай бұрын

2:40

Microsoft Access: Control can't be edited it's bound to AutoNumber field

11 ай бұрын

6:19

Microsoft Access: Can't create this relationship and enforce referential integrity

11 ай бұрын

Пікірлер

@RussellDeniega Күн бұрын

Hi! Im having a problem, why is my Notepadd++ website keeps getting messy when i open the website in a another other gadgets? and there are no picture appearing, and when i click on the files in the website, its not working and said your file couldn't be accessed?

@bjornclaeys3266 3 күн бұрын

Hi Lisa, I am learning access with your videos. I am pretty handy in excel, but this is a different way of thinking. I had a similar enter value (error) message. I had a query with columns of sums. In the next colums i used these "sums-of" for the next calculations. This created the enter value message. I solved it by creating another, separate query, functioning "as the next step"... Best regards Bjorn

@omsm1363 5 күн бұрын

Great job. Very informative learning. Many thanks

@Seif_Ahmed. 7 күн бұрын

3 years and this video still helped me thank you!

@robertloh108 17 күн бұрын

I have tried your Index option "3 fields "FName, LName, MI" without success. I tried entering duplicate records in Datasheet View.

@lfriedrichsen 17 күн бұрын

@@robertloh108 I need more information to provide good feedback. What is the specific problem or error message you are receiving? When does it happen?

@iridescent.fluorescence 20 күн бұрын

soooo helpful - thank you!!!

@lfriedrichsen 20 күн бұрын

Thank you! You can find a listing of all of my KZbins at learncs.w3spaces.com

@thesusanest Ай бұрын

You are a great instructional designer and educator, thanks! This video helped me see how I can import my very wide spreadsheets (covering multiple topics) into a staging table, then divide out those fields into their appropriate separate tables. 1 Mass import, an append queries for each permanent table, then clear the staging table via a delete query. Next up, VBA code to automation the process. 😊

@lfriedrichsen Ай бұрын

@@thesusanest you are so kind to make this comment. Ty! See all of my youtubes organized at learncs.w3spaces.com

@beholderer Ай бұрын

Does this field uses the storage size of the Access database or does it use another way to store the files so that the database storage will not get consumed so fast? I understand that the maximum size of an Access database is just like 2Gb

@lfriedrichsen Ай бұрын

@@beholderer yes the Attachment field data type works as if it stores the file directly within the .accdb database file. If you have so many pictures that you would push to the maximum access database file size, then you might go with the Hyperlink data type which only stores a path to the file.

@TheNetbug Ай бұрын

@@lfriedrichsen Can this be done in such a way that the image is still displayed within the access form (as opposed to an icon or hyperlink)? For example, could I maintain a directory of images that the DB could access and display in the Access form? We're attempting to create a new parts inventory system for my father and right now all the data is in Excel and jpg images, but the images would exceed the 2GB cap quite handily.

@lfriedrichsen Ай бұрын

Some thoughts -- 1. Would very low quality .jpg images be acceptable? If so, you store the .jpg images in an Attachment field data type. That would be very straight forward and simple. Often, pictures we take with our cameras and phones are at a much higher quality than needed for viewing on a screen. 2. If you stored the .jpg images in another folder and used the Hyperlink data type to store the path to the file all it would take is another click on the form or report to open that Hyperlink which would bring up that image. 3. One time I worked with images in a database that we only needed for a short period of time. So we inserted them in the database using the Attachment field data type so we could run our reports, but then ran a macro each Friday that deleted older images we didn't need any more. (We also had the images stored in an external folder just in case we needed to insert them into the database again). I don't think this sounds like it would be your best option, but sometimes these types of ideas are helpful too. Best wishes!

@EricPeelMusic Ай бұрын

For MIDI data, I have an array of arrays of objects and some of their keys have arrays. Its fun.

@lfriedrichsen Ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@mehranbarahouei2346 2 ай бұрын

Very helpful ❤❤❤

@lfriedrichsen Ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@Gayannable 2 ай бұрын

it helps a lot. Thank-you

@lfriedrichsen Ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@GT3Chef 2 ай бұрын

Awesome video, thanks!

@lfriedrichsen 2 ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@arkanx7759 2 ай бұрын

thanks dear

@lfriedrichsen 2 ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@jeffyeung1405 2 ай бұрын

Hi lisa, cannot solve the issue as 1. Microsoft has blocked macros from running because the source of this file is untrusted 2. The path cannot be added into Trusted Location for security reason How could I solve this? Thank you

@lfriedrichsen 2 ай бұрын

Try this: Check the "Allow Trusted Locations on my network (not recommended)" check box at the bottom of the Trusted Locations dialog box in the Trust Center. File|Options|Trust Center|Trust Center Settings|Trusted Locations

@zeblock 3 ай бұрын

Can you print a report with an Attached file (jpg) with the preview of the file as appears in the table? Or is mandatory to be Bitmap OLE object?

@lfriedrichsen 3 ай бұрын

@@zeblock a jpg image will print very nicely from a form or report

@zeblock 3 ай бұрын

@@lfriedrichsen hmmmmm i just cant find the way how to make it in a report form...the attached file field is not shown as an option for the report

@zeblock 2 ай бұрын

@@lfriedrichsen Maybe you could show us in a new video?🥰🥰

@lfriedrichsen 2 ай бұрын

A .jpg file in an Attachment field can/will show up on either a form or a report, but it sounds like your problem may be that you do not know how to add new fields to an existing report. Try starting with the Report Wizard, and then choosing the fields you want on that report including the Attachment field that contains your .jpg. That will create a starting report that shows the .jpg file that you can modify later as needed.

@zoomingby 3 ай бұрын

Thank you! This was really helpful in understanding this concept. Why I've been working with access for over three years without seeing this and related concepts explained before is beyond me. Subscribed!

@lfriedrichsen 2 ай бұрын

Thanks for the nice comment!! See all of my KZbins organized at learncs.w3spaces.com

@taylorshealey01 3 ай бұрын

Thank you so much. You've saved the day.

@lfriedrichsen 3 ай бұрын

Great!! See all of my KZbins organized at learncs.w3spaces.com

@lfriedrichsen 2 ай бұрын

@@taylorshealey01 you are welcome! See all of my KZbins organized at learncs.w3spaces.com

@davb9514 3 ай бұрын

Thanks, help me out with a problem :)

@lfriedrichsen 3 ай бұрын

You are welcome! See all of my KZbins organized at learncs.w3spaces.com

@christineencrypt3892 3 ай бұрын

this didn't fix my problem; I'm so annoyed right now

@christineencrypt3892 3 ай бұрын

I finally fixed mine. In Print Preview - Click on Columns and for column size check the box for same as detail. Boom! Fixes this two page problem

@HusnaSadat-fo4zt 4 ай бұрын

Solution to fix the #name error in the access form, please record the video more clearly, thank you

@HusnaSadat-fo4zt 4 ай бұрын

Thanks

@helenarozane3653 4 ай бұрын

es jus updatoshu vai es dabusu sekmigi programmesana #pray for me

@michaeltodd2012 4 ай бұрын

Have used MS Access since version 1.1, right after Microsoft bought it. It was much speedier with version 2.0 as they incorporated indexing technology they acquired from another purchased company. That company had created FoxBase and FoxBase Mac and a few users later put out Microsoft FoxPro. All good databases along with Paradox, Reflex, Clarion, Alpha Four and others in the 1990s.

@yeseniaarredondo4016 4 ай бұрын

Dear Lisa, Thank you for sharing. It's been the most useful video on access I've seen so far. Kudos.

@lfriedrichsen 4 ай бұрын

Thank you for taking the time to make such an encouraging comment! See all of my KZbins organized at learncs.w3spaces.com :)

@stopthink9000 4 ай бұрын

Great video! I have more questions. What makes this better than Excel? I can do all of these things with Excel using Power query and building a data model. How is Access intended to be used by stakeholders? Is there a stand alone app or web interface for the forms for data entry that they use? Can you automate reports by email? How does Access compare to MS SQL Server? How well does Access play with BI products like PowerBI, Tableau, etc?

@lfriedrichsen 4 ай бұрын

Access is superior to Excel in two major ways: 1. the power and benefits of managing data in a relational database vs. a flat file and 2. it is an application development tool (queries, forms, and reports) as opposed to a spreadsheet view (see the first two KZbins in my "Microsoft Access A to Z playlist for explanations of both of these)

@lfriedrichsen 4 ай бұрын

stakeholders -- exactly who are you referring to? Access is primarily used as an internal tool. Again, see the first 2 videos in my "Access A to Z" playlist for a better explanation of where, why, and how Access is the best tool for the job.

@lfriedrichsen 4 ай бұрын

web interface -- yes, if used with SharePoint.

@lfriedrichsen 4 ай бұрын

automate reports by email -- yes, Access does that inherently using macros and VBA through Outlook

@lfriedrichsen 4 ай бұрын

compare with MS SQL Server -- that's also a relational database management product but not an application development platform. SQL Server is intended for enterprise-level applications and has a much larger data storage capacity

@xylophone3764 5 ай бұрын

Mine still not working

@lfriedrichsen 4 ай бұрын

What are you trying to do? Exactly what is not working? Without more specific information, it's extremely difficult to provide a helpful response. Sometimes it is helpful to watch the KZbin again and refer to it in your question. That way, you can say "at time x:x I cannot do y" ... you get the idea.

@TheForgotten366 5 ай бұрын

umm hello i have a problem i changed the default application for it and it is now notepad how do i change it back to default?

@lfriedrichsen 5 ай бұрын

I think you're asking about the .laccdb file. If so, first off I have to explain that you don't want to open it or modify it in any way. It is a temporary file that takes care of itself (opening, then closing and deleting itself) when you open an Access .accdb file properly. Yes, there are times when the .laccdb file persists even after you've opened and closed an Access .accdb file properly. If that happens, so problem, just delete it. It will recreate itself when you open the .accdb Access database file again. But to directly answer your question, find the .laccdb file in Windows Explorer. Right-click, Show More Options, Properties. On the General tab, Change, and you can then find the application that you want to open the file with that specific extension. But again -- you should not ever need to do this. Please watch the KZbin again in its entirety to have a sense of how the .laccdb file works and why you really never need to directly interact with it.

@shahd193 5 ай бұрын

thank u for the encouragement u did save my day! I have been searching for it for so long u are the only one that explains it neatly.

@maliksalih6457 6 ай бұрын

GREAT WORK

@lfriedrichsen 5 ай бұрын

Thanks! See a listing of all of my KZbins at learncs.w3spaces.com

@griffibr1961 6 ай бұрын

Thanks for sharing

@lfriedrichsen 6 ай бұрын

You're welcome! See all of my KZbins organized at learncs.w3spaces.com

@thechoosen4240 6 ай бұрын

Good job bro, JESUS IS COMING BACK VERY SOON; WATCH AND PREPARE

@lfriedrichsen 5 ай бұрын

You are welcome! See a listing of all of my KZbins at learncs.w3spaces.com

@BusinessParties 6 ай бұрын

helpful

@lfriedrichsen 6 ай бұрын

Great! See all of my KZbins organized at learncs.w3spaces.com

@sajeebmehedi278 6 ай бұрын

Thank You Lisa.

@lfriedrichsen 6 ай бұрын

You are welcome! See all of my KZbins organized at learncs.w3spaces.com :)

@shamaddistube6902 6 ай бұрын

Thank you You saved my time

@lfriedrichsen 6 ай бұрын

Great! See all of my KZbins organized at learncs.w3spaces.com :)

@everybodyshinetogether9266 7 ай бұрын

what version of access do you have?

@lfriedrichsen 7 ай бұрын

Microsoft 365 Apps for enterprise Version 2401

@denisea3465 7 ай бұрын

This was absolutely fabulous! Clear instructions, good easy explanation of why and how, and you and solved my problem. Thank you so much!

@lfriedrichsen 7 ай бұрын

What a nice comment, thank you! See all of my KZbins organized at learncs.w3spaces.com

@abdulhamidalhaddadi2255 7 ай бұрын

Thank you

@lfriedrichsen 7 ай бұрын

You're welcome! See all of my KZbins organized at learncs.w3spaces.com

@Jojosmith342 7 ай бұрын

Excellent tutorial. Learn a lot from your video. all thumbs up & definately subscribe! thank you for teaching

@lfriedrichsen 7 ай бұрын

Thanks for taking the time to comment! All of my KZbins are organized at learncs.w3spaces.com. Take care and best wishes.

@Jojosmith342 7 ай бұрын

Thank you so much Lisa for your valuable link. i am checking it out now. Will thumbs up for all your videos

@beatrixbujak1571 8 ай бұрын

Thank you

@lfriedrichsen 7 ай бұрын

Thank you for taking the time to write. All of my KZbins are organized at learncs.w3spaces.com. Take care.

@cospittner3526 8 ай бұрын

thank you I was trying to solve that problem for hours. So helpful!

@lfriedrichsen 7 ай бұрын

Glad to hear this!! Thanks for taking the time to write. All of my KZbins are organized at learncs.w3spaces.com. Take care and best wishes.

@RobPearlman 8 ай бұрын

Hi Lisa, these videos are really valuable. Thank you so much for sharing your knowledge. I am an Operations Manager at a Land Surveying firm and we need to update our equipment inventory system. To date it was a clunky excel spreadsheet that really lacked alot of functionality. I've got a rudimentary database up and running after only a couple hours of work thanks to your videos!

@lfriedrichsen 8 ай бұрын

Glad to hear this!! Thanks for taking the time to write. All of my KZbins are organized at learncs.w3spaces.com. Take care and best wishes.