3024-Chap14 - 14. DESIGNING USER INTERFACES IN ACCESS You...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
14. DESIGNING USER INTERFACES IN ACCESS You should now have a good idea how to create, populate, and query relational databases using MS Access. The final step in setting up a database is to create the user interface. 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
et’s design and implement a ortion f the user Let s design and implement a portion of the user interface for Anna’s Books. We’ll first design the interface – recall this is the third stage of data modeling (Chapter 7). Then we’ll implement the interface in Access. 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 2
Background image of page 2
e will continue using our Anna’s Books Access 2007 We will continue using our Anna s Books Access 2007 database from the end of the last chapter ( AnnasBooks_13.accdb ). AnnasBooks.accdb : Anna’s Books as it would exist at the end of this chapter. • created and populated as per Chapter 12. • queries as per Chapter 13. • user interface per this chapter. hese files can be downloaded from Scholar: These files can be downloaded from Scholar: Scholar: Resources Application Files 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 3 Chapters 12-14: MS Access
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
14.1 Anna’s Books Database – Interface Design For our limited interface design, we’ll provide the user e ability to do the following: the ability to do the following: i) View, change or add customer data. ii) View new books or audio books. iii) View, change or add purchase records. As with our AnJoCa application (Excel), we’ll have a main control window, which links to other windows. Each window can then be closed individually. 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 4
Background image of page 4
Main Window Upon starting the application, the user should see a cover age something like this: page something like this: elcome to Anna’s Books! Welcome to Anna s Books! Please select one of the following: View, Change or Add Customer Data iew New Books nd udio Books View New Books and Audio Books View, Change or Add Purchase Records 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Viewing, Changing or Adding Customer Data Clicking on the View, Change or Add Customer Data utton should open a window for looking at individual button should open a window for looking at individual customer data or adding a new customer. ustomers o make things less Customers Customer ID: Last name: To make things less confusing, only show one record at a time First name: Street: ity: (i.e., like a data form in Excel). rovide a control to City: State: Zip: Find Customer Provide a control to allow searching for a particular customer 2010 John P. Shewchuk ISE 3024 Course Notes 14 – 6 (Navigation/new record buttons) (e.g., by customerId ).
Background image of page 6
Viewing New Books and Audio Books Clicking on the View New Books and Audio Books button hould open a window for finding details on these items should open a window for finding details on these items.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/16/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 84

3024-Chap14 - 14. DESIGNING USER INTERFACES IN ACCESS You...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online