| Learning Microsoft Access 2007 Learning Microsoft Access 2007 is suitable for use with Microsoft Access 2007. Support Files are included with the product. These provide prepared database templates so that students do not need to enter data or create numerous forms or reports. Prices
Summary of Chapters The following pages provide a summary of the skills developed and the types of databases produced in modules 1 and 2 of Learning Microsoft Access 2007. Module 1 Chapter 1: Introduction to Microsoft Access Demonstrates how to set up a simple table, add data to the table, edit data, delete records and print the data. The following is an example of a table produced:
Back to Microsoft Access | Top | Next This chapter provides activities on how to sort data into alphabetical, numerical or chronological order, how to filter information and how to search for information. For example, a table showing just the females sorted by date is produced:
Back to Microsoft Access | Top | Previous | Next Chapter 3: Introduction to Queries This chapter provides activities on how to set up a query, how do calculations on the data, how to sort and filter queries, how to set up table relationships, how to use the query wizard and how to use interactive queries. For example, the following diagram shows a total pay calculation added to a database and wages over $600 displayed.
Back to Microsoft Access | Top | Previous | Next This chapter provides activities on how to create simple or quick forms. It includes how to create the form, the difference between Layout and Form view, changing items within the form, adding a logo to the form, formatting controls within the form and using the form to enter data.
Back to Microsoft Access | Top | Previous | Next Chapter 5: Creating More Detailed Forms This chapter provides activities on how to create more detailed Forms for larger databases. It includes how to insert fields, adjust field widths and positions, how to align fields and labels, how to change fields text and fill colours, how to insert graphics, add pop-up or menu lists and how to set the field entry order to produce forms similar to.
Back to Microsoft Access | Top | Previous | Next :This chapter demonstrates how to use the Report Wizard and the Report icon to create quick reports on data. It includes the difference between columnar and tabular reports, formatting headings and fields, turning on totals, using autoformats and sorting the data within reports. The following is a sample report produced:
Back to Microsoft Access | Top | Previous | Next Chapter 7: Creating More Detailed Reports This chapter provides activities on how to create more detailed reports from databases. It includes how to layout a report, add calculations, how to format the report, how to add headers and footers, page numbers and dates, and dow to include graphics items such as rectangles and lines. An example of a reported created is:
Back to Microsoft Access | Top | Previous | Next This chapter demonstrates how to create user-friendly databases that links tables, queries, forms and reports together. It involves adding buttons, creating a switchboard form and setting passwords to secure the database. The following switchboard is created
Back to Microsoft Access | Top | Previous | Next Module 2 This chapter provides activities on how to create macros. It covers creating macros to open forms, reports and carryout commands, edit macros, create macro groups, set an autoexec macro, assign buttons to run macros and print macro definitions. The following switchboard is completed using macros and buttons.
Back to Microsoft Access | Top | Previous | Next Chapter 10: Reports That Total Items This chapter provides activities that show the user how to include sub-totals and grand totals in reports. It covers how to set a group, add controls to the group, how to adjust the group footer, how the adjust the report footer and how to modify the grouping to create a different report. The following is one of the reports created:
Back to Microsoft Access | Top | Previous | Next Chapter
11: Applying Relational Database Features
Back to Microsoft Access | Top | Previous | Next Chapter
12: Setting up an Invoice System
Back to Microsoft Access | Top | Previous | Next Chapter 13: Formatting Invoice Systems This chapter demonstrates how to complete the invoice that was set up in the previous chapter. It involves setting popup lists for the customer and product details, aligning fields, setting a page break, adding a border around the invoice and using the invoice to enter data. The following invoice is produced.
Back to Microsoft Access | Top | Previous | Next Chapter 14: Reporting From Invoice Systems This chapter demonstrates how to produce reports from the invoice system developed in the previous 2 chapters. Three reports are created: an Items Sold Report listing how any of each product has been sold. A Monthly Sales Report listing the total sales for each month, a customer Mailing Labels so that letters can be sent to customers. The following is the Items Sold Report that is produced from the invoice sales:
Back to Microsoft Access | Top | Previous | Next Chapter 15: Enhancing Invoice Systems This chapter demonstrates how to convert the invoice system developed in the previous three chapters into a user-friendly system that can be used by users with little knowledge of Microsoft Access. It involves adding switchboard forms for customer and product details, a reports switchboard and a main switchboard with macros and buttons inserted to fully automate the system. An example of the Customer switchboard is:
Back to Microsoft Access | Top | Previous | Next This chapter demonstrates some of the useful tools that Microsoft Access offers. For example, using Help features, creating Form Tabs, the Calendar Control, checking for Duplicate Records, The Trust Centre and Database Templates. The following form tabs are created:
Back to Microsoft Access | Top | Previous
Home | Products | Prices | Ordering | Podcasts | Downloads | Contact
|
||||||||||||||||||||
