Access 2010: The Missing Manual by Matthew MacDonald

By Matthew MacDonald

Go from entry beginner to real grasp with the pro database layout assistance and crystal-clear factors during this booklet. You'll study the entire secrets and techniques of this robust database software so that you can use your facts in inventive methods -- from growing product catalogs and publishing details on-line to generating invoices and reviews.
* Build a database with ease. shop info to trace numbers, items, files, and extra
* Customize the interface. construct your personal types to make info access a snap
* Find what you wish fast. seek, kind, and summarize large quantities of data
* Put your information to use. flip uncooked details into revealed experiences with beautiful formatting
* Share your data. Collaborate on-line with SharePoint and the brand-new entry internet database
* Dive into entry programming. Get methods and methods to automate universal projects
* Create wealthy info connections. construct dynamic hyperlinks with SQL Server, SharePoint, and different structures
<span class="h1"> Five Touchstones to knowing Access </span>

Let’s face it--learning the tips and methods of database layout could be a little bit of a slog. but when you’re simply beginning out with entry, listed below are 5 key insights which may assist you know the way the database global works. hold those issues in brain, and you’ll be at the within music to learning Access.
<table align="right" bgcolor="#ffffff" cellpadding="2" cellspacing="2"> <tbody><tr> <td align="right"><img src="http://g-ecx.images-amazon.com/images/G/01/books/orly/Figure2.giff"; align="center" border="0"></td> </tr> </tbody></table>
1. Databases carry database objects. most folks are acquainted with tables, the grid-like grouping of knowledge that shops your info (for instance, lists of things you personal, associates you might have, or items you promote via your small business). yet tables are only one kind of item that an entry database can carry. the opposite key parts are queries (customized seek workouts that pull out the data you wish on the drop of a hat), reports (similar to queries, yet well formatted and prepared for printing), forms (windows that make it effortless to check and edit the information on your tables), and macros and modules (miniature courses which could do exactly approximately anything—from updating 10,000 files right now to firing off an email).

2. Relationships carry all of it together. entry beginners occasionally commence pondering a database is simply a glorified spreadsheet. in spite of everything, can’t Excel carry lengthy lists with thousands of rows? (And definite, it can.) despite the fact that, entry has a characteristic Excel can’t replica: relationships. a customary entry database holds a number of tables, and relationships hyperlink those tables jointly. for instance, a desk of shoppers could hyperlink to a desk of orders, which might hyperlink to a desk of goods, permitting you to reply to questions like “What consumers spent the main money?” and “What is the preferred product for patrons dwelling in New York?” Relationships additionally guard your data--for instance, they make it very unlikely for somebody to incidentally position an order for a product or a shopper that doesn’t exist.

3. There are how you can paintings with a database: as a dressmaker and as a user. The database designer is the individual that units up the database. The database fashion designer has the accountability of laying out the tables, construction the queries, and knocking jointly a few great experiences and varieties (assuming you will want all these features). by way of comparability, the database person is the person that makes use of the tables, queries, stories, and varieties in daily lifestyles. The person reports documents, makes adjustments, and fills the tables up with data.

looking on what kind of database you’re developing (and what you must accomplish), you can be either the database dressmaker and the database consumer. yet it’s vital to gain that those are special initiatives. actually, whilst utilizing a thoroughly designed database, database clients don’t have to be rather expert with entry. they could simply paintings with the kinds and experiences that the database dressmaker created.
<table align="left" bgcolor="#ffffff" cellpadding="2" cellspacing="2"> <tbody><tr> <td align="left"><img src="http://g-ecx.images-amazon.com/images/G/01/books/orly/Figure3.gif"; align="center" border="0"></td> </tr> </tbody></table>
4. in the end, you’ll desire macros. To turn into an entry specialist, you want to first learn how to layout a logical, constant set of tables and upload the relationships that hyperlink them jointly. subsequent, you need to discover ways to construct the opposite forms of objects--queries, varieties, and reports--that provide help to practice universal initiatives. at some point soon, whereas tackling this moment level, you’ll run right into a problem that forces you to step as much as the 3rd point of entry mastery: macros.

Macros are miniature courses that practice customized projects. the good news is that during entry 2010, you could layout your personal macros with out changing into a programmer. you simply have to drag, drop, and organize a series of ready-made macro instructions into the entry macro clothier. for instance, you should use macros to construct buttons that ship emails, begin printouts, make updates, or simply take you round your database.

5. specialist person, meet visible Basic. a few humans cease their entry trip at this element, content material to take advantage of tables, types, reviews, and macros to do all their paintings. but when you must see every little thing entry has to provide, you must look at its high-powered visible uncomplicated engine. utilizing VB code, you are able to do virtually something, from validating a bank card to best a buyer via an order technique (two examples which are mentioned in Access 2010: The lacking Manual). And if you’re keen to select up a few easy programming recommendations, you should use code to rework an easy database right into a cohesive database application—for instance, whatever that appears extra just like the conventional computer courses you run in your machine.

Show description

Read or Download Access 2010: The Missing Manual PDF

Similar databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This publication is a brief reference for the SQL dialect supported by way of the Teradata Relational Database administration approach. The ebook is usually a brief connection with the supported info description words for the Teradata RDBMS and the information Dictionary. The viewers for this fast reference is all clients of Teradata SQL who want fast, non-detailed information regarding the right way to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make types and experiences precious enhance types to entry the information you wish and make stories that make experience! should you inspiration you needed to use a spreadsheet software to provide studies and types, wager what! entry can prove great-looking kinds and reviews that really exhibit what is going on together with your information -- in the event you understand how to invite it well.

Additional resources for Access 2010: The Missing Manual

Example text

In Access 2010, you just need a leisurely trip to the Customize Ribbon section of the Access Options dialog box (page 788), where you can add, remove, and reorder Access’s panoply of buttons to suit your preferences. About This Book Despite the many improvements in software over the years, one feature hasn’t improved a bit: Microsoft’s documentation. In fact, with Office 2010, you get no printed user guide at all. To learn about the thousands of features included in this software collection, Microsoft expects you to read the online help.

It’s cleanly organized, with helpful pop-up tips, a collapsible display that lets you home in on the important stuff, and a drag-and-drop feature that lets you rearrange your actions with the mouse (see Chapter 15). All these changes reflect Microsoft’s new vision—that macros will become an increasingly useful part of the database developer’s toolkit, not just a poor substitute for Visual Basic code. • Data macros. Data macros are macros that leap into action when someone inserts, edits, or deletes a record.

If you’re fast enough, you can use the Undo feature to reverse your last change (Figure 1-11). However, the Undo feature reverses only your most recent edit, so it’s no help if you edit a series of records and then discover the problem. It also doesn’t help if you close your table and then reopen it. 38 Access 2010: The Missing Manual Saving Databases Figure 1-11: The Undo command appears in the Quick Access toolbar at the top left of the Access window, so it’s always available. For these reasons, it’s a good idea to make frequent database backups.

Download PDF sample

Rated 4.65 of 5 – based on 44 votes