Learning Microsoft Access 2007 - Buttons
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Learning Microsoft Access 2007 - Buttons as PDF for free.
More details
- Words: 1,423
- Pages: 11
Learning Microsoft Access 2007 By Greg Bowden
Chapter 8
Creating UserFriendly Databases
Guided Computer Tutorials www.gct.com.au
PUBLISHED BY GUIDED COMPUTER TUTORIALS PO Box 311 Belmont, Victoria, 3216, Australia www.gct.com.au © Greg Bowden This product is available in Single or Multi User versions. Single-user versions are for single person use at any particular time, just as a single text book would be used. If you intend to use the notes with multiple students the single user version should be upgraded to the multi-user version. Multi-user versions allow the school or institution to print as many copies as required, or to place the PDF files on the school network, intranet and staff laptops. A certificate of authentication is provided with multi-user versions. Bookmarks provide links to all headings and sub-headings, and individual chapters are provided.
First published 2008 ISBN: 1 921217 52 9 (Module 1) 1 921217 53 7 (Module 2) PDF document on CD-ROM
Every effort has been made to ensure that images used in this publication are free of copyright, but there may be instances where this has not been possible. Guided Computer Tutorials would welcome any information that would redress this situation.
Chapter
8
Creating User-Friendly Databases Databases are often created by a small number of people then used by a larger number of others. Often these people do not know how to use all the features of a database so it is advantageous to create databases that are easy to use through the use of buttons. Buttons are simply graphics placed on the screen to perform commands and allow users to navigate around forms, print reports or run macros. All the user has to do is click on the button for the command to be run. In this chapter you will add buttons to a simplified database for a real estate agency
which allows users access to a series of forms and reports.
Opening the Sample File A database has been prepared for you and it will need to be opened from the ACCESS 2007 SUPPORT FILES 1
Load Microsoft Access and click on the OPEN icon in the OFFICE BUTTON, or close the current file and click on the OPEN icon in the OFFICE BUTTON.
2
Access the CHAPTER 8 folder of the ACCESS 2007 SUPPORT FILES and open the CHAPTER 8 file as an OPEN READ-ONLY file.
3
Click on the OFFICE BUTTON, highlight SAVE AS and select ACCESS 2007 DATABASE.
4
Access your ACCESS STORAGE folder and save the file as CHAPTER 81.
Opening the File as an Exclusive file The file will be opened as an EXCLUSIVE file so that a password can added to it. 1
Close the CHAPTER 81 file and select OPEN from the OFFICE BUTTON. 2 Select the CHAPTER 81 file then click on the arrow next to the OPEN button and select OPEN EXCLUSIVE.
© Guided Computer Tutorials 2008
8-1
Learning Microsoft Access 2007
The Sections of the Database The database consists of the following sections. Look at each in turn.
A Tables Owner Details: Records the property’s owner details. Property Details: Records specific details about the property, such as its location, type, description, sale type (sale, auction or rent), and price. The tables are linked by the OWNER ID primary key field.
B Queries All Details: Combines details from both tables. This query is used by the DATA ENTRY form. Properties for Auction: Filters the properties available for auction, sorted into SURNAME then FIRST NAME order. Properties for Rent: Filters the properties available for rent, sorted in WEEKLY RENT then SURNAME order. Properties for Sale: Filters the properties for sale, sorted into SALE PRICE order.
C Forms Data Entry:
Displays all the fields from the two tables.
D Reports Auction Properties: Prints the Properties for Auction Query details. Rental Properties: Prints the Properties for Rent Query details. Sale Properties: Prints the Properties for Sale Query details.
8-2
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
The Structure of the Database You will be required to add buttons to a DATA ENTRY form and to create a MAIN SWITCHBOARD form to control the use of the database. The structure of the database system that you will create is summarised in the following diagram. Main Switchboard
Data Entry Screen
Print Rental Properties
Print Sales Properties
Print Auction Properties
Completing the Data Entry Form Buttons are needed in the DATA ENTRY form to allow the users of the database to carry out the general maintenance procedures such as adding new records, finding records and deleting records.
1 Open the DATA ENTRY form from the NAVIGATION pane and use the VIEW icon to set the screen to DESIGN VIEW.
2 Buttons will be placed along the right of the form.
© Guided Computer Tutorials 2008
8-3
Learning Microsoft Access 2007
A Inserting a New Record Button We will use a wizard to help use create the button.
1 In the DESIGN tab of the RIBBON check that the USE CONTROL WIZARD is turned on then click on the BUTTON icon.
2 Drag a button from (13,3) to (15.5,3.75).
3 In the COMMAND BUTTON WIZARD dialogue box set the CATEGORIES frame to RECORD OPERATIONS, leave the ACTIONS frame as ADD NEW RECORD and click on NEXT. 4 Click on the TEXT radio button, leave the text box as Add Record and click on NEXT.
8-4
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
5 Name the button: Add New Record and click on the FINISH button to complete the button.
6 The text in the button can be formatted. Set the FONT to ARIAL, the SIZE to 10 point, the STYLE to BOLD and the FONT COLOUR to DARK RED.
B Inserting a Find Record Button A FIND RECORD button can be inserted to allow the user to quickly find a record rather than needing to use the record navigation buttons.
1 Select the BUTTON icon and drag a button from (13,4) to (15.5,4.75).
© Guided Computer Tutorials 2008
8-5
Learning Microsoft Access 2007
2 In the COMMAND BUTTON WIZARD dialogue box leave the CATEGORIES frame at RECORD NAVIGATION, set the ACTIONS frame to FIND RECORD and click on NEXT.
3 Click on the TEXT radio button, leave the text box next to it as FIND RECORD and click on NEXT.
4 Name the button FIND RECORD and click on the FINISH button to complete the button.
5 The format of the text in the first button can be copied to the second. Click on the ADD RECORD button then click on the FORMAT PAINTER icon in the DESIGN tab.
8-6
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
6 Click the FORMAT PAINTER pointer on the FIND RECORD button and its format should be adjusted.
7 Select the FIND RECORD button and double click on one of its ‘handles’ to resize the button so that all its text is displayed.
C Inserting a Delete Record Button
1 Select the BUTTON icon again and drag a button from (13,5) to (15.5,5.75).
© Guided Computer Tutorials 2008
8-7
Learning Microsoft Access 2007
2 In the COMMAND BUTTON WIZARD dialogue box set the CATEGORIES frame to RECORD OPERATIONS, set the ACTIONS frame to DELETE RECORD and click on the NEXT. 3 Click on the TEXT radio button, leave the text in the box next to it as DELETE RECORD and click on NEXT.
4 Name the button DELETE RECORDS and click on the FINISH button to complete the button.
5 Click on the FIND RECORD button then click on the FORMAT PAINTER icon in the DESIGN tab to copy the text format.
8-8
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
6 Click the FORMAT PAINTER pointer on the DELETE RECORD button to paste the text format.
7
The first two buttons now need to be increased in width to match the width of the DELETE RECORD button.
8 SHIFT+CLICK on the ADD RECORD button so that both it and the FIND RECORD button have their ‘handles’ displayed.
9 Hold down the CTRL key and stretch one of the centre right size ‘handles’ to the right so that the right edges of the two buttons are in line with the right edge of the DELETE RECORD button.
NOTE:
Holding down the CTRL key prevents the edge of the buttons snapping to the nearest grid point. You can also enter the required width of the buttons in the WIDTH box within the FORMAT tab of the PROPERTY SHEET pane. © Guided Computer Tutorials 2008
8-9
Chapter 8
Creating UserFriendly Databases
Guided Computer Tutorials www.gct.com.au
PUBLISHED BY GUIDED COMPUTER TUTORIALS PO Box 311 Belmont, Victoria, 3216, Australia www.gct.com.au © Greg Bowden This product is available in Single or Multi User versions. Single-user versions are for single person use at any particular time, just as a single text book would be used. If you intend to use the notes with multiple students the single user version should be upgraded to the multi-user version. Multi-user versions allow the school or institution to print as many copies as required, or to place the PDF files on the school network, intranet and staff laptops. A certificate of authentication is provided with multi-user versions. Bookmarks provide links to all headings and sub-headings, and individual chapters are provided.
First published 2008 ISBN: 1 921217 52 9 (Module 1) 1 921217 53 7 (Module 2) PDF document on CD-ROM
Every effort has been made to ensure that images used in this publication are free of copyright, but there may be instances where this has not been possible. Guided Computer Tutorials would welcome any information that would redress this situation.
Chapter
8
Creating User-Friendly Databases Databases are often created by a small number of people then used by a larger number of others. Often these people do not know how to use all the features of a database so it is advantageous to create databases that are easy to use through the use of buttons. Buttons are simply graphics placed on the screen to perform commands and allow users to navigate around forms, print reports or run macros. All the user has to do is click on the button for the command to be run. In this chapter you will add buttons to a simplified database for a real estate agency
which allows users access to a series of forms and reports.
Opening the Sample File A database has been prepared for you and it will need to be opened from the ACCESS 2007 SUPPORT FILES 1
Load Microsoft Access and click on the OPEN icon in the OFFICE BUTTON, or close the current file and click on the OPEN icon in the OFFICE BUTTON.
2
Access the CHAPTER 8 folder of the ACCESS 2007 SUPPORT FILES and open the CHAPTER 8 file as an OPEN READ-ONLY file.
3
Click on the OFFICE BUTTON, highlight SAVE AS and select ACCESS 2007 DATABASE.
4
Access your ACCESS STORAGE folder and save the file as CHAPTER 81.
Opening the File as an Exclusive file The file will be opened as an EXCLUSIVE file so that a password can added to it. 1
Close the CHAPTER 81 file and select OPEN from the OFFICE BUTTON. 2 Select the CHAPTER 81 file then click on the arrow next to the OPEN button and select OPEN EXCLUSIVE.
© Guided Computer Tutorials 2008
8-1
Learning Microsoft Access 2007
The Sections of the Database The database consists of the following sections. Look at each in turn.
A Tables Owner Details: Records the property’s owner details. Property Details: Records specific details about the property, such as its location, type, description, sale type (sale, auction or rent), and price. The tables are linked by the OWNER ID primary key field.
B Queries All Details: Combines details from both tables. This query is used by the DATA ENTRY form. Properties for Auction: Filters the properties available for auction, sorted into SURNAME then FIRST NAME order. Properties for Rent: Filters the properties available for rent, sorted in WEEKLY RENT then SURNAME order. Properties for Sale: Filters the properties for sale, sorted into SALE PRICE order.
C Forms Data Entry:
Displays all the fields from the two tables.
D Reports Auction Properties: Prints the Properties for Auction Query details. Rental Properties: Prints the Properties for Rent Query details. Sale Properties: Prints the Properties for Sale Query details.
8-2
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
The Structure of the Database You will be required to add buttons to a DATA ENTRY form and to create a MAIN SWITCHBOARD form to control the use of the database. The structure of the database system that you will create is summarised in the following diagram. Main Switchboard
Data Entry Screen
Print Rental Properties
Print Sales Properties
Print Auction Properties
Completing the Data Entry Form Buttons are needed in the DATA ENTRY form to allow the users of the database to carry out the general maintenance procedures such as adding new records, finding records and deleting records.
1 Open the DATA ENTRY form from the NAVIGATION pane and use the VIEW icon to set the screen to DESIGN VIEW.
2 Buttons will be placed along the right of the form.
© Guided Computer Tutorials 2008
8-3
Learning Microsoft Access 2007
A Inserting a New Record Button We will use a wizard to help use create the button.
1 In the DESIGN tab of the RIBBON check that the USE CONTROL WIZARD is turned on then click on the BUTTON icon.
2 Drag a button from (13,3) to (15.5,3.75).
3 In the COMMAND BUTTON WIZARD dialogue box set the CATEGORIES frame to RECORD OPERATIONS, leave the ACTIONS frame as ADD NEW RECORD and click on NEXT. 4 Click on the TEXT radio button, leave the text box as Add Record and click on NEXT.
8-4
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
5 Name the button: Add New Record and click on the FINISH button to complete the button.
6 The text in the button can be formatted. Set the FONT to ARIAL, the SIZE to 10 point, the STYLE to BOLD and the FONT COLOUR to DARK RED.
B Inserting a Find Record Button A FIND RECORD button can be inserted to allow the user to quickly find a record rather than needing to use the record navigation buttons.
1 Select the BUTTON icon and drag a button from (13,4) to (15.5,4.75).
© Guided Computer Tutorials 2008
8-5
Learning Microsoft Access 2007
2 In the COMMAND BUTTON WIZARD dialogue box leave the CATEGORIES frame at RECORD NAVIGATION, set the ACTIONS frame to FIND RECORD and click on NEXT.
3 Click on the TEXT radio button, leave the text box next to it as FIND RECORD and click on NEXT.
4 Name the button FIND RECORD and click on the FINISH button to complete the button.
5 The format of the text in the first button can be copied to the second. Click on the ADD RECORD button then click on the FORMAT PAINTER icon in the DESIGN tab.
8-6
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
6 Click the FORMAT PAINTER pointer on the FIND RECORD button and its format should be adjusted.
7 Select the FIND RECORD button and double click on one of its ‘handles’ to resize the button so that all its text is displayed.
C Inserting a Delete Record Button
1 Select the BUTTON icon again and drag a button from (13,5) to (15.5,5.75).
© Guided Computer Tutorials 2008
8-7
Learning Microsoft Access 2007
2 In the COMMAND BUTTON WIZARD dialogue box set the CATEGORIES frame to RECORD OPERATIONS, set the ACTIONS frame to DELETE RECORD and click on the NEXT. 3 Click on the TEXT radio button, leave the text in the box next to it as DELETE RECORD and click on NEXT.
4 Name the button DELETE RECORDS and click on the FINISH button to complete the button.
5 Click on the FIND RECORD button then click on the FORMAT PAINTER icon in the DESIGN tab to copy the text format.
8-8
© Guided Computer Tutorials 2008
Creating User-Friendly Databases
8
6 Click the FORMAT PAINTER pointer on the DELETE RECORD button to paste the text format.
7
The first two buttons now need to be increased in width to match the width of the DELETE RECORD button.
8 SHIFT+CLICK on the ADD RECORD button so that both it and the FIND RECORD button have their ‘handles’ displayed.
9 Hold down the CTRL key and stretch one of the centre right size ‘handles’ to the right so that the right edges of the two buttons are in line with the right edge of the DELETE RECORD button.
NOTE:
Holding down the CTRL key prevents the edge of the buttons snapping to the nearest grid point. You can also enter the required width of the buttons in the WIDTH box within the FORMAT tab of the PROPERTY SHEET pane. © Guided Computer Tutorials 2008
8-9
Related Documents
Learning Microsoft Access 2007 - Buttons
May 2020 13
Learning Microsoft Access 2007 - Macros
May 2020 15
Learning Microsoft Access 2007 - Forms
May 2020 18
Learning Microsoft Access 2007 - Queries
May 2020 11
Learning Microsoft Access 2007 - Invoices
May 2020 14
Learning Microsoft Access 2007 - Introduction
May 2020 13More Documents from "Guided Computer Tutorials"
Gct Product Catalogue
May 2020 24
Learning Microsoft Access 2007 - Forms
May 2020 18
Learning Microsoft Word 2007 - Tabs
May 2020 24
Learning Adobe Dreamweaver Cs4 - Anchor Points
May 2020 20
