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 complicated databases. With entry, clients can create a database quick 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 information. With the aid of absolutely the Beginner's consultant, readers may be able to quick begin a brand new database by utilizing the Database Wizard, create tables from scratch or by utilizing a Wizard, upload and edit database details through the use of either tables and kinds and manage facts in a few tables by utilizing queries and stories. The booklet assumes totally no earlier wisdom of the subject, and studying is straightforward due to the book's lighthearted yet no-nonsense sort. It serves as a good source for clients who're thoroughly new to entry 2002 or who're upgrading from a prior model of the software program.
Read Online or Download Absolute Beginner's Guide to Microsoft® Access 2002 PDF
Best databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can constantly come up over the perfect meanings of phrases, misunderstandings that could have a major impression at the luck of your database initiatives. for instance, listed here are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating staff, subscribe to dependency.
Additional info for Absolute Beginner's Guide to Microsoft® Access 2002
This task can be perplexing to even the experts. That's why Access includes the Table Analyzer a utility that helps you correctly divide your data. We'll review this tool in Chapter 6. [ Team LiB ] [ Team LiB ] Identifying Possible Forms You should have a good idea of the tables you'll be creating after you actually start building your application. The next step in designing a database is to consider other objects you might need to work with your data. A good place to start is with the forms you'll need to maintain and view that data.
Com/. mdb. Fields A field is the smallest unit of data in the database. In the plants database, some of the fields are CommonName, LatinName, StreetAddress, and City. Each thing you store in the database is described by one or more fields. As part of the process of designing tables, you'll tell Access which fields belong in each table. Records When you fill in all the fields in a table, you're creating a record. A table might contain no records at all (if you haven't entered any data yet), or it might contain hundreds, thousands, or even millions of records.
To quickly redock an undocked toolbar, just double-click the toolbar's title bar. An undocked toolbar is known as a floating toolbar. The Menu Bar Unlike Access toolbars, there's only one menu bar, although it changes commands according to the current environment. This section reviews the application menu bar, which is displayed at the top of the Access window as soon as you open it. The following are several tasks you can perform via a menu command: • You can manipulate database files. • You can create and modify database objects.