Results for:
database

  • Women’s History Month: Trailblazers in technology

    7 Mar 2011
    March is Women's History Month, with March 8th being the traditional day International Women's Day is celebrated. There are many, many women who have contributed to the technological advances and work regarding mathematics, computers, and software. Today I've chosen three to highlight. Grace Murray Hopper...

  • Updated! Interactive Excel files on web pages: An Excel PM explains

    25 Feb 2011
    Update: See near the end of this post for the latest Office how-tos on embedding Excel and PowerPoint files. Hi everyone, My name is Larry Waldman and I'm a program manager on the Excel team. This week, the Crabby Office Lady was nice enough to let me combine a couple of Office's cool features to highlight...

  • Queries, forms, & reports: Access jargon demystified

    14 Feb 2011
    It's Valentine's Day and because I love you, I'm going to go over some very basic terms that you need to know when using Access (or, frankly, any database software). YES the terms I’m demystifying today are quite basic and there's a reason for this: I have found that many people are using Excel...

  • PivotCharts: Your data with a view

    3 Nov 2010
    Take a look at the image below— it's a PivotTable AND a PivotChart (which gives your data graphical representation). Steve, a salon owner (and manager of my tresses), wanted to see how much his salon made off me during the months of January, February, and March this year. He took his spreadsheet...

  • Crabby's Monday favorite: Using the right program for the job

    30 Aug 2010
    Excel and Access have a lot in common when it comes to managing data. However, there are some key differences that you need to know. Let's say you're planning a massive family reunion (a job for the family's well-organized masochist). Figuring out who can sit next to whom (thus avoiding last year's scandals...

  • Won't you access my Access?: Crabby's Daily Tip

    29 Mar 2010
    People who love Access just love it. People who don't love it, just don't understand it. There's no time like the present to get to know your friendly database program.... To create a shortcut, drag a database object in an Access project or Access database to the desktop. To stop a macro while it's running...

  • For your eyes only: Encrypt your Access database

    1 Mar 2010
    If you've got an Access database and you want to ensure that you have compete control of who does and does not have access to it, encrypting it with a password is the way to go. Open the database in Exclusive mode. (This is so no one else can open it while you're in there. Read more about opening a database...