ГЛАВА 116 - Читайте, мистер Беккер! - скомандовал Фонтейн. Джабба сидел весь потный, положив руки на клавиатуру. - Да, да, - сказал он, - читайте эту благословенную надпись.
DEFAULT
DEFAULT
Microsoft office access 2007 the complete reference free. Buy for others
Get started with a FREE account. Microsoft Office Access All-in-One Desk Reference For Dummies. Pages · · MB · 1, Downloads· English. Table Office Template Download Statistics. While I'm not free to provide specific numbers, I can tell you that Microsoft's internal data gathered. Microsoft Office Access The Complete Reference (Complete Reference Series) 1st Edition · Kindle $ Read with Our Free App · Paperback $ 3 Used.
DEFAULT
DEFAULT
She has more than 25 years of computer experience. Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness. The Ultimate Microsoft Office Access Resource Build a highly responsive a database so you can track, report, and share information and make more informed decisions.
Customize the user interface to suit your preferences Use the built-in database templates or design your own Create, modify, and relate tables Enter and edit data Write advanced queries to extract and manipulate information Create customized forms and reports Improve performance and back up your database Develop macros to carry out automated responses to user actions Import, link, and export data Enable a multiple-user environment Secure your database. Previous page.
Publication date. February 16, Print length. See all details. Next page. From the Publisher Virginia Andersen has written or contributed to nearly 40 computer books, including Access The Complete Reference.
Start reading Microsoft Office Access on your Kindle in under a minute. Don't have a Kindle? Virtual lessons for curious minds. Amazon Explore Browse now. About the author Follow authors to get new release updates, plus improved recommendations. Virginia Andersen. Brief content visible, double tap to read full content. Full content visible, double tap to read brief content. Read more Read less.
Customer reviews. How customer reviews and ratings work Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them. Learn more how customers reviews work on Amazon.
Top reviews Most recent Top reviews. Top reviews from the United States. There was a problem filtering reviews right now. Please try again later. Verified Purchase. Other Access file types are also available from the list. Once you locate the database you want to open, double-click the name or select it and click Open. Another Open option is show previous versions which offers earlier versions of the selected database. More about these options appears in later chapters.
The Groups pane at the left contains five buttons that you can click to open other folders or return to the Windows desktop. This is the default display in the Open dialog box. The Look In box shows the name of the currently open folder and the window below displays a list of all the folders and files in that folder.
The Open dialog box also contains several buttons that help you find the file you want to open. You can see the name of each button by resting the mouse pointer on the button in the toolbar. The Views drop-down list includes several ways to display the names of the files in the selected folder as well as graphics with file type and size. To choose a different type of file to open, click the down arrow next to the Files Of Type box and choose from the list of 24 types or choose All Files.
When you find the database you want, select the name and click Open. This database is an order-processing application that demonstrates the power and usefulness of a relational database.
Even though the purpose of the database seems straightforward enough—taking and filling orders from customers for the company products—a lot of data still must be manipulated. The database is introduced in this chapter and discussed further in Chapter 2. The easiest way to install and open the Northwind Traders database is through the Getting Started window.
The Sample window displays a thumbnail for accessing the Northwind Traders database see Figure Click the thumbnail to see the option. Click the folder icon in the right pane to browse for a different destination, if necessary.
Enter a different database name, if desired. Click Download or Create. New security features have been added to Access In previous versions, when you opened a database containing macros or Visual Basic for Applications VBA code, you were asked whether you wanted to enable them.
In Access , you see a Security warning message across the window between the opening ribbon and the database itself. To enable the contents, do the following: 1. Click the options button. Click OK. Now you are ready to sign on to the Northwind Traders database. Click Login as an employee in the Login dialog box to get started. The names of all the database objects appear in the Navigation Pane, where you can also see the complete list of objects without having to tab to other windows.
You can also open any of the database objects from the Navigation Pane. You can resize the Navigation Pane by dragging the right border. Or just press f To reopen the pane, click the Open button or press f11 again. To change the display of items in the Navigation Pane, right-click the menu at the top of the pane and point to View By. The options include Details, Icon, and List.
You can also use the menu to sort objects by name, type, date created, or date modified. Chapter 1: Q u i c k To u r o f M i c r o s o f t O f f i c e A c c e s s 2 0 0 7 13 To see all the ways you can arrange and view your database objects in the Navigation Pane, click the down arrow next to All Access Objects at the top of the pane.
The lower section offers the option to filter the objects by a specific type or include all objects in the display. The Navigation Pane also replaces the common switchboard user interface by allowing you to place specific actions in a custom group in the pane more about this in Chapter NOTE If you have an established switchboard that you want to keep, you can turn off the Navigation Pane and use the switchboard as before.
In Figure , the only open object is the Northwind Traders database, as you can see. With more than one object open, you can use the tabs to switch from one object to another. Looking at the Ribbon While you are browsing around in the window, you might as well take a look at the new Access ribbon.
The ribbon replaces the stacks of menus and toolbars you saw in earlier versions of Access. The major advantage of this new user interface is that the ribbon makes available all the tasks related to the current activity.
So rather than searching through a series of menus for the action you want, all the appropriate commands are right in front of you. The standard ribbon appears in the Access window when you open a database. Not all the options are available to all of the database objects, and some, such as the Save command, are not available until a table or other object is opened. It also makes sense that the Paste command is dimmed until you have copied something to the clipboard.
The commands on each contextual tab are arranged in groups as designated at the bottom of each group. The Font group includes all the style, alignment, fore and back color settings, and gridlines. The tabs that appear on the ribbon depend on the currently active object. For example, if you open a table, you will see a Datasheet tab on the ribbon. If you switch to table Design view, Access automatically changes the Home tab to the Design tab.
To see what a command will do, hover the mouse pointer over the command and look at the ScreenTip that appears briefly. A lot of the commands also have shortcut keys that might appear in the ScreenTip or with the command name.
See Chapter 16 for more information about showing shortcut keys. You can still use earlier version keyboard shortcuts to execute a command.
To see what keyboard shortcut works with a command on a tab, press and release alt. The KeyTips appear over each feature that is currently available. If you need more space, you can hide the ribbon and leave only the contextual tabs in view. To hide the ribbon, double-click the active command tab. Repeat to restore the ribbon. Table lists the command keys you can use to move among the commands and other items on the ribbon. Press alt or F10 first to select the ribbon, and then press the command keys.
Checking out the Galleries and the Mini Toolbars The ribbon contains a new control type called the gallery. A gallery presents the optional results of a specific command. For example, with a table open, if you click the down arrow next to the Gridlines command, you can select from the displayed arrangements—horizontal, vertical, both, or none.
A mini toolbar is a temporary display of text formatting options. After you select the text you want to format, the automatic mini toolbar appears above the text. Move the mouse pointer closer to the toolbar and you can use it to apply italic, boldface, font size, color, and other formatting options. When you select a formatting option, the selected text adopts it and you can see how it will look without actually changing it.
If you move the mouse pointer away from the mini toolbar, it disappears. Click anywhere outside the menu to close it. Pressing enter, esc, or alt also closes the shortcut menu. Only the most commonly used commands are included in the shortcut menu, but they might also include commands from several different ribbon tabs.
Figure shows the shortcut menu that appears when you right-click a table name in the Navigation Pane. To choose a command from a shortcut menu, click the command or type the letter underlined in the name of the command.
A right arrow next to a command, such as Import in Figure , means that a submenu is available. Rest the mouse pointer on the item to open the list of subcommands, and then click to choose one from the list.
If the command shows an ellipsis … , a dialog box opens when you click it. Looking at a Table To open one of the tables in the current database, first expand the list of tables in the Navigation Pane by clicking the expansion arrow next to Tables. Then double-click the table name or right-click the name and choose Open from the shortcut menu.
The table appears with the data in rows and columns, much like a spreadsheet. This view of table data is called Datasheet view.
Each row contains a single record with information for one order. Each column contains values for one field. Each field has a unique name and contains a specific item of data, such as the customer or employee name. The column headings show the field names. Touring the Datasheet View You might have noticed some changes that occur in the window when you open a table. For example, the window now shows the name of the open table in a tab above the table document.
The Home tab of the ribbon now shows more available commands in the contextual command groups—that is, they are no longer dimmed and are now available to activate. To the left of the bottom horizontal scroll bar is a set of navigation tools you can use to move through the records in the table. Navigating among Records and Fields You need to be able to access your data if you want to enter new information or edit existing records.
As always, you can move the cursor around the records and fields in your table in several ways, including simply clicking in the desired location if it is visible. You should try them all and settle on the one that works best for you.
The Record navigation buttons at the bottom of the datasheet window provide the same options as the Go To ribbon command. You can also enter a specific record number if you know the number of the record you want to see in the text box between the navigation buttons and then press enter. This area also tells you what record the cursor is in and the total number of records in the table. First Record Record Number Previous Record Last Record Next Record New Record You can also find a specific record by placing the cursor in the column you want to search and enter the desired value in the Search box in the navigation bar.
The cursor immediately moves to the record containing that value. To scroll to a particular record in the table, drag the scroll box to that record. As you drag the scroll box, a helpful ScreenTip appears next to the pointer. It tells you the number of the current record and the total number of records in the table. You can also use the horizontal scroll box at the bottom of the window to drag to other columns in the datasheet.
Pressing a key or combination of keys can be a faster way to move around the datasheet once you get used to the correlation between the keys and the resulting cursor movement. For example, you can prevent the cursor from moving to another record after you fill in the last field in one record. See Chapter 16 for information about customizing your work place by setting options. See Chapter 3 for more information about the ways you can view table data. This has always been possible with forms and subforms in which the main form contains data from one record in one table, while the subform contains data from one or more records in a related table.
When viewing data in Datasheet view, the related data is contained in a subdatasheet, which can easily be displayed. To see this data, expand the subdatasheet by clicking the plus sign. The plus sign changes to a minus — sign when the subdatasheet expands.
To collapse the subdatasheet, click the minus sign. You can have as many subdatasheets expanded as you want in a single Datasheet view. Each subdatasheet corresponds to one record in the datasheet. You can expand them individually or set a table property that automatically expands all the subdatasheets when the table opens in Datasheet view.
See Chapter 4 for information about setting tables and other properties. Notice the plus and minus signs indicating the current state of the subdatasheet. See Chapter 3 for more information about relating tables and what that can do. This view is fine for reviewing the data in small tables, but the full datasheet is often too wide to fit all the fields on a single screen.
Then click the Form command in the Forms group. The form includes every field in the table, arranged in one or more columns with the field names to the left, so you can identify the fields. The name of the table appears in the title bar of the form and on the Object tab.
Figure shows the Northwind Orders table in Layout view. The Orders table has a related table—Order Details—which was available as a subdatasheet refer to Figure When Access creates a form with this tool, it automatically creates a subform containing data from the related table, which corresponds to the current record in the main form.
Notice the automatic change in the Formatting tab of the Form Layout Tools ribbon. NOTE If more fields exist than can fit on a single screen, you can use the vertical scroll bar to see the rest. To use the form to add a new record to the Orders table, click the New Blank Record button in the navigation bar to display an empty form. Use the tab key to move from field to field as you enter data. To add a new record in the subform, enter the data in the blank row at the bottom of the subform datasheet.
When you finish with the form, you can give it a name and save it as a new database object, or you can close the form without saving it. You can also choose to enter the form Design window and make changes, and then save it as a custom form. You will learn more about form design in Chapter The navigation buttons are at the bottom of the window, which you can use to move to other records and the Go To options are in the Find group at the right end of the Home tab.
The subform also has a navigation bar referring to the records in the subform. Moving from one field to another is a little different, however. Of course, you can simply click in the field in which you want to work, but you might find using keystrokes easier. Experiment with the keystrokes to see where they take you in the form. If the form contains a subform, pressing tab cycles the cursor through all the fields of the main form, and then through the fields and records of the related subform.
After leaving the last field of the last record in the subform, the cursor moves to the first field in the next record in the main form when you press tab. The path is reversed when you press ctrl-tab. PART I only one record on the screen at once. Any related data appears automatically in a subform. Then you can usually see all the fields and move freely among them without having to use the scroll bars. Forms are dual-purpose objects: You can use a form to look up data or to enter and edit data.
Wizards can help you create new databases, tables, and queries, as well as customize forms and reports with special features. A wizard presents each step as a dialog box in which you choose what you want to do and how you want the results to look. As you make choices, the wizard works in the background to create the Visual Basic code that can accomplish your goals.
Access has improved many of the old wizards and has added new ones, so you can get help with virtually anything you want to create.
You can use the Control Wizards to add command buttons, lookup fields or add a subform to your existing form. You can click a topic to see the information or you can type specific words in the Search box at the top of the screen and click Search. The Table of Contents pane displays a list of topics marked with the closed book icon.
Click these to expand the topics into individual Help articles see Figure If you are currently connected to the Internet, you also have access to all the up-to-date Help topics. Additional online help includes assistance, training courses, the latest product updates, clip art and media, and a research library. First, click the question mark? The mouse changes to an arrow accompanied by a question mark. Then, click the element you want to know more about. The status bar offers information about the current activity or the position of the cursor.
Many design windows include hint boxes that tell you about aspects of the design. Other windows and dialog boxes include samples or previews of the selections made. The hint box on the right describes what should appear in the Field Size Property box. You had a chance to try out the viewing options, the Navigation Pane, and the new command ribbons.
Using the Access Northwind Traders sample database, you were given a tour of the Datasheet window and a glimpse of the power behind the Access design capabilities, including the many available wizards.
Armed with this familiarity with the Access database management system, you can move on to the next chapter, which introduces you to the concepts behind the relational database model and examines the types of relationships you can define between tables. Chapter 2 also looks at the structure and components of a sample database, and how the data is related for efficiency.
Subsequent chapters present details about designing and creating a database, as well as populating it with tables and other Access objects. Our ability to succeed in this Information Age is directly related to our ability to manage and track information.
Managing information means storing it efficiently, and tracking means retrieving it quickly—in a form that can be instantly useful. The relational database model has been developed to meet those requirements.
A database is an organized collection of related information used for a specific purpose, such as keeping track of ongoing work order activities or maintaining a library. Bits of data are combined in a logical way to impart specific information. Then the numbers become information in the form of a Social Security Number. When you use a computerized database management system such as Access, the database is called relational.
The principle behind a relational database is this: The information is divided into separate stacks of logically related data, each of which is stored in a separate table in the file. Tables are the fundamental objects at the heart of a relational database. They form the active basis for the information storage and retrieval system. Once the information is arranged in separate tables, you can view, edit, add, and delete information with online forms; search for and retrieve some of or all the information with queries; and print information as customized reports.
In Access, the term database is more precisely used to define the collection of objects that store, track, manipulate, and retrieve data.
These components include tables, queries, forms, reports, macros, and modules. It makes use of the SharePoint services to send data over the Internet. Purpose of Relationships Rather than storing data in one large two-dimensional table, called a flat file, such as you might find in a Word document or an Excel spreadsheet, Access lets you distribute data among individual tables. Topping the list of advantages of using a relational database structure is the reduction of data redundancy, which not only reduces the required disk storage space, but also speeds processing.
All queries, forms, and reports look in that place for the current values. Each table in the relational design is a single object containing data pertinent to a particular aspect of the database, such as an employee, a product, or an order.
A separate record would exist for every work order under contract. Storing all the customer data with the work order information would mean repeating the same customer information.
Employee information in the work order table would also be repeated. It is far more efficient to have one table for work order information and separate tables for customer and employee information. A short field containing a customer identifier could be added to the customer and work order tables to form a connection between the tables, called a relationship. Similarly, an employee identifier can link the work orders to the employee who is acting as the job supervisor.
Figure shows how to implement the work order database as a relational database. The information is split into an efficient relational database containing three tables, with special fields added to provide the relationships.
Similarly, the three relationship lines from the Supervisor, Principal Worker, and Helper fields in the Workorders table to the Employees table, link the two tables in three ways. For example, you can ask Access for the name and pager number of the supervisor on a specific job.
When Access creates a second relationship with a table, it actually adds another instance of the table to the Relationships layout. So you see three instances of the Employees table to accommodate the three links with different fields in the Workorders table.
For example, in a customer-related service company, one customer might contract for several services. Storing all the customer data with the work order information would mean repeating the customer information in every work order record. This would result in many copies of the same information if your business were successful enough to encourage repeat business.
For example, if you have employees and work orders, you can see that employees and work orders belong in separate tables. If you have information you seldom use, such as an archive of completed work orders, storing this separately—and out of the way—and bringing it out only as needed is more efficient.
Types of Relationships Tables can be related in three different ways: one-to-many, one-to-one, and many-to-many. The type you define depends on how many records in each table are likely to have the same value. To relate tables, one of them must include a field that contains a unique value in every record. This can be a primary key field or a field with a unique index that allows no duplicate values. A primary key or a unique index can also be a combination of two or more fields whose combined value is unique for all records.
For example, the Employee ID can be a unique number that identifies an employee. The most commonly used type of relationship is the one-to-many relationship, in which one record in one table can have one or many matching records in another table, or maybe none at all. For example, the Customers table would have one record for each customer. The Workorders table might have more than one work order for the same customer.
Both tables would include a field with a value representing that specific customer. In the parent table—Customers—the field must be the primary key or a field with an index that contains a unique value.
In the child table, the field is called the foreign key and does not need to be unique. TIP You can speed processing if the child table is indexed on the foreign key.
See Chapter 4 for information on defining table structures including specifying indexes. In Figure , all the relationships are one-to-many, as denoted by the symbols at the ends of the relationship lines. Primary key fields are indicated by the field name appearing in boldface in the field lists. As you can see in the figure, all three tables in the database have primary keys. The foreign keys are identified by the relationship line pointing to the field name in the child table field list.
The one-to-one relationship is sometimes used as a form of lookup, in which each record in one of the tables has a matching record in the other table. Neither table is designated as the parent. The key fields in both tables are the primary keys. One use for this type of relationship is to store additional, seldom-accessed information about an item in the first table, such as an abstract of a book or the details of a work order.
Many records in one table have the same values in the key field as many records in the second table. To implement this in Access, you must create a third table, called a junction table, to place between the first two, converting the many-to-many to two one-to-many relationships. Office Access introduces a new field type, the multivalued field, that can replace the need for the junction table when creating a many-to-many relationship.
See Chapter 4 for information about the different data types you can use in a table. Figure shows how the three types of relationships differ. Chapter 5 contains more information about defining and modifying relationships. For example, in the relationship between the Customers table parent and the Workorders table child , every current work order must have a reference to a customer.
You cannot have a work order without a customer. The referential integrity rules also prevent you from deleting a customer record if work orders are still in progress. These rules help to maintain an accurate and complete database with no loose ends. You can set referential integrity between linked tables, provided they are both in Access format and you open the database that contains the linked tables.
The same rules can apply to a one-to-one relationship. Enforcing the referential integrity rules in such a relationship guarantees that every record in one table has one and only one matching record in the other table.
Access is an object-oriented database management system DBMS , which means that the entire database is composed of objects with certain characteristics or attributes called properties that determine their structure, appearance, and behavior. For example, table properties include a description of the table, the subject of the table, and the arrangement of records in the table, such as in alphabetic or chronological order, based on one or more fields.
In turn, each of the major Access objects is a container for other objects, which also have properties. For example, tables are made up of fields that are considered objects with properties of their own, such as name, size, format, and data type.
Reports and forms contain Chapter 2: T h e Wo r l d o f R e l a t i o n a l D a t a b a s e s Inspecting the Sample Database The Northwind Traders sample database introduced in Chapter 1 is an order-processing application. The following sections examine the sample database in more detail. PART I design objects, such as data fields, titles and labels, command buttons, page numbers, and graphics.
Each of these has a list of properties you can set to achieve the effect you want. As you see in the Navigation Pane, the major database objects are tables, queries, forms, reports, macros, and modules.
The tables are the containers for all the data in your database. As mentioned earlier, in a relational database system, the data is distributed among several related tables instead of being placed in one large table.
A query is a question that you ask of your database. You usually use a query to extract a specified set of records from one or more tables. For example, you might ask the database to show you a list of delicatessen customers who are vegetarians or who have a preference for exotic pasta products. Access answers your question by displaying the requested data.
Because a query is a stored question instead of a stored answer, when you ask the question again, the results include the latest information. You can not only view the results, you can also use them in reports and forms.
Forms are often more convenient than a tabular datasheet for entering and editing table data, especially if a table includes more data than can fit across the screen and you have to scroll right to see the rest. A form can display a single record at a time, so all the data is visible at once, and you can arrange the fields in any way you want in a form design. You can also include data from more than one table or query as the basis for a single form. Forms are especially useful for creating a comfortable visual environment for data management.
For example, you can create a form that resembles the paper form used to collect data in the work place. When you want to print the data, you usually create a report. The report can be a quick and easy dump of the table data—useful for checking specific data items—or it can be a glossy presentation of the data in a custom format suitable for the stockholders or a business manager. The report can also include totals and other summaries of values in a particular field, such as gross sales and monthly profits.
Adding charts and graphs to a report makes it even more visually informative. Access provides a special type of report through the Label Wizard that you can use for printing mailing labels or envelopes. If you keep a mailing list in a database table, this type of special report can come in handy.
You can also create form letters and merge them with the address list to print a personalized copy for each recipient. The final two types of objects are macros and modules. Macros contain a sequence of commands that perform a certain task and are useful for defining the automatic actions that respond to button clicks or other events.
Several new features have been added to macros in Office Access that make them more useful and secure. See Chapter 19 for details. Procedures contained in the modules are the cornerstone of advanced Access applications.
After distributing the data among the tables, the tables are related to one another by means of identifying the matching fields. The Northwind data is distributed among 20 tables, as shown in the Navigation Pane in Figure The principal tables are Products, Orders, and Customers.
The other tables support the order processing by providing additional data, such as the name of the employee who took the order, the category of the product, product suppliers, order status, and shipping methods. Each of these tables is a good example of grouping data items used for the same purpose. The Orders table contains all the order information, such as the order number; customer identifier; employee identifier; order date, date required, and date shipped; shipping method; and the complete name and address of destination.
The Relationships window Figure shows eight tables with their relationship lines. NOTE To simplify the view, many of the peripheral tables were hidden in this view of the Relationships window. When you choose Relationships, you may see all the tables in a tangled arrangement. Each of these eight tables is related to at least one other table, thereby creating a relational database. Customers and Shippers are linked to the Orders table by their ID fields. Identifying Primary Keys and Linking Fields As you can tell from the symbols at the end of the relationship lines, all of these relationships are one-to-many, the most common type.
The parent table must be linked to the child table by its primary key. The primary key field appears with a key icon in the table field list. It also includes a new attachment field type and a hyperlink to a web page. The Products table contains the current state of the inventory of each product. The fields include the product identifier, name, supplier identifier, category, quantity per unit, unit price, units in stock and on order, the reorder level, and a field that indicates whether or not the product has been discontinued.
The table also includes a new attachment field. Other tables contain peripheral information for the purpose of reducing data redundancy. The Suppliers table includes the supplier identifier, name and address, and a point of contact. The Shippers table contains the company name and telephone numbers, as well as the shipper identifier.
The Invoices table lists the order and shipping dates as well as the costs billed to the customer. This practice helps to identify which field contains the primary key. Looking at Relationship Properties In addition to the relationship type, you can find out more about a relationship, such as whether referential integrity is enforced, the specific names of the linking fields, and the type of join implemented.
The Edit Relationships dialog box opens when you right-click the middle of a relationship line and choose Edit Relationship from the shortcut menu, or when you choose Edit Relationships in the Tools command group in the Design tab. This dialog box specifies which are the linking fields in each table, the enforcement of referential integrity, and the type of relationship.
Two other properties, Cascade Update Related Fields and Cascade Delete Related Records, when selected automatically make changes in related tables when you change data in the related fields or delete a record from the table on the one-side of the relationship.
See Chapter 5 for more information on join types and how they affect the data displayed. The Payoff In addition to the efficiency of data storage, a relational database system offers large benefits when it comes to data retrieval. Forms can be designed for entry or display of data from related tables. As you enter data in the form, it is dispersed to and updates the proper table.
As you view data in a multiple-table form, the data is synchronized automatically. A Custom Form The Northwind sample database includes several custom forms. To view the Purchase Order Details form shown in Figure , do the following: 1. Open the Northwind Traders database as before and log in as an employee. Click the header arrow again to see the list of objects.
Click the Forms expansion arrow in the Navigation Pane to show the list of forms in the database. Double-click the Purchase Order Details form name, or right-click it and choose Open from the shortcut menu.
The form is used to enter new purchase orders by supplier or to view existing orders. Each purchase order includes data from the related tables containing the purchase order details, inventory receiving data, and payment information. The Supplier field has a down arrow button that controls the display of a list of Supplier IDs derived from the Suppliers table.
When the supplier name is selected from the list, related information is displayed in the subform. The subform has three pages that show purchase details, inventory, and payment information. Then double-click the report name, or rightclick it and choose Open from the shortcut menu. This is an example of a report containing information from more than one table.
The report is based on a select query that gathers information from the Employees, Products, and Sales Reports tables. The sales are grouped by employee with a chart showing the volume of sales in each category for each employee. Figure shows a preview of this report.
Summary This chapter contains some insight into the theory of relational database systems and how they can be used for efficient information storage and retrieval. The relationships among the tables in the Northwind sample database were examined. The next chapter discusses in-depth the process of designing a relational database and how to distribute data among tables.
You will see how to create a new database from a template that you can download and how to create a blank database without a predetermined design. This page intentionally left blank 3 CHAPTER Creating a Database T he information in a relational database system is distributed among related tables to optimize information storage and retrieval. Common fields relate the tables so information can be extracted and presented in useful ways. A poorly designed database is of little or no value.
The more time spent on task and data analysis, the better the results. Once the design is completed and reviewed, building the database with Access is easy, with or without a predefined database template. Designing the Database The design process begins with an analysis of the tasks to be required of the database. First, you must determine what the system is intended to do for the prospective users.
From the Publisher Virginia Andersen has written or contributed to nearly 40 computer books, including Access The Complete Reference. About the author Follow authors to get new release updates, plus improved recommendations. Virginia Andersen. Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content. Read more Read less. Customer reviews. How customer reviews and ratings work Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them. Learn more how customers reviews work on Amazon. Top reviews Most recent Top reviews. Top reviews from the United States. There was a problem filtering reviews right now. Please try again later.
Verified Purchase. I needed a reference book to support a small Access project I took over from an absent engineer. This book was not it. It's a monkey-see, monkey-do tour of MS Access Lots of drivel about basic concepts. Little or no detail that I was looking for, and not organized as a reference book. Did you know that in Access, date literals are placed between hash signs?
If you want a ground-up explanation of workstation databases and the cool stuff you can do with them this book may suit your needs. If you're a professional looking for a reference, look elsewhere. I recently bought this book in order to dust off my Access skills. I have found the book hard to follow, primarily I believe because the premise seems to be that this is a book for a new user.
Although there is references to older versions of Access, it just that - a reference and not any type of comparison. With a title like "The Complete Reference," I thought I could skip the skills I already understand table creation, table normalization, etc. This book is not designed that way; each section is tied into the next, and the example database is so interwoven with the text that it is difficult to read and learn any section on its own.
I suppose the presumption was on my part, but with a title like "The Complete Reference," I thought info could be obtained on a more modular basis. Don't get me wrong, it is a well-written book, and the example is good, but the example seems to dominate how the text flows.
The first part of the book presumes you are designing a database for someone versus designing it for your own use , which did not work for me.
DEFAULT
DEFAULT
DEFAULT
DEFAULT
1 comment