December 2006
Intermediate to advanced
409 pages
8h 3m
English
Content preview from Access® 2007 For Dummies®Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 20. Making It All Better with the Analyzer Tools
In This Chapter
Converting a flat file to relational tables with Table Analyzer
Documenting your database
Fine tuning your database with Performance Analyzer
The Access Analyzer tools promise to help you set up, document, and fine tune the performance of your database. Sound too good to be true? Well, like most software tools that promises to automate, the Analyzer tools do some things well and others not so well.
Here is what the Analyzer tools promise to do:
Convert flat files into relational databases automatically
Document the database and all its parts (including tables, queries, forms, and reports)
Analyze the structure of your tables to make sure that everything is set up in the best possible way
So, which Analyzer tool makes good on its promise? It would have to be the Database Documenter. To manually do what the Database Documenter does would take the average person hours if not days. If you're using the Analyzer tools for the other two tasks, they don't quite deliver on their promise. They do have merit, though, so we cover them as well.
Convert Your Flat Files to Relational Tables with Analyzer
Doesn't this sound great? The Table Analyzer promises to take a messy flat file table (such as an imported spreadsheet) with all its repetitive data and convert it to an efficient set of relational tables. But, as the bromide goes, promises made are promises broken. Unless your flat file follows some strict rules, the Table Analyzer ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.