By Susan Sales Harkins
Microsoft entry 2002 is a strong, relational database software program package deal that makes it effortless to create and deal with advanced databases. With entry, clients can create a database fast from scratch or through the use of an entry database Wizard. as soon as the database is created, entry presents the entire instruments had to input and manage info. With assistance from absolutely the Beginner's advisor, readers may be able to quick commence a brand new database by utilizing the Database Wizard, create tables from scratch or through the use of a Wizard, upload and edit database info by utilizing either tables and kinds and control facts in a couple of tables through the use of queries and stories. The booklet assumes completely no earlier wisdom of the subject, and studying is straightforward as a result of book's lighthearted yet no-nonsense sort. It serves as a superb source for clients who're thoroughly new to entry 2002 or who're upgrading from a prior model of the software program.
Read or Download Absolute Beginner's Guide to Microsoft® Access 2002 PDF
Similar databases books
The final word Microsoft workplace entry 2007 ResourceBuild a hugely responsive a database so that you can music, record, and proportion info and make extra knowledgeable judgements. This entire source indicates you ways to layout and boost customized entry 2007 databases--even in case you have very little programming adventure.
Leverage the functions of the Microsoft Excel PowerPivot add-on to create complex BI ideas evaluate the best way to create complex BI strategies fast and successfully utilizing easy-to-follow, step by step examples comprehend the major rules of PowerPivot with the aid of real-time examples observe extra approximately a few fascinating DAX features with examples of ways they paintings intimately enterprise intelligence expertise provides a firm the facility to make judgements utilizing huge volumes of knowledge.
Extra info for Absolute Beginner's Guide to Microsoft® Access 2002
Once again, Access has compiled this information by aggregating the raw data contained in the tables in the database. If you have a printer, you can click the Print button on the Access toolbar to get a paper copy of the report. You'll find that the onscreen rendition is almost indistinguishable from the printed version. Use the Close button on the preview window to close the report when you're done investigating it. " Pages Click the Pages shortcut to see a list of pages in the database. Pages are very similar to forms, but there's a twist: They can be displayed in a Web browser as well as in Access itself.
By the end of the process, you might need to update your mission statement, but that's the whole point of the design process. For the purposes of this book, we'll create a database that stores gardening information. Specifically, we'll track flowers, plants, and vegetables. Using the previous sentence as our mission statement, we'll get started. We'll use this database for the rest of the book but don't be surprised if we enhance the database in later chapters. [ Team LiB ] [ Team LiB ] Part II: Building and Using a Database 53 54 Part II: Building and Using a Database The Discovery Process Finding the Data At this stage of the process, it isn't important to know all that much about the database program you'll be using, which in this case is Access.
We said that a table consists of columns and rows. In database terms, the column houses a field, the smallest unit of data in the database. Each field in the table defines the table's entity. Together, the fields create a record, and one record stores the data for one entity. That's all clear as mud, right? Don't worry, it'll make more sense as we continue. Let's apply all these new terms to our gardening database by identifying the entities from our earlier list. 56 Part II: Building and Using a Database Part II: Building and Using a Database 57 Initially, we seem to have two entities individual plant information and catalog data.