1 / 24

Integrated Business Projects

Integrated Business Projects. Part 3 Operations. Project 17 Managing Resort Operations. Project 17 Objectives. Create tables and import data Define validation rules Redefine data relationships Design queries with criteria and conditions Create forms with subforms. Continued.

sook
Download Presentation

Integrated Business Projects

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrated Business Projects Part 3 Operations Project 17 Managing Resort Operations

  2. Project 17 Objectives • Create tables and import data • Define validation rules • Redefine data relationships • Design queries with criteria and conditions • Create forms with subforms Continued

  3. Objectives (continued) • Add command buttons to forms • Create a customer database • Prepare memos and emails

  4. Project 17 Jobs • Job 17-1: Query Equipment and Supplier Tables • Job 17-2: Manage Employee Data • Job 17-3: Manage Customer Information • Job 17-4: Manage Partner Information • Job 17-5: Manage Vacation Requests

  5. Job 17-1: Query Equipment and Supplier Tables Jobs List • Creating queries using Query Design • Creating queries using Query Wizard • Printing queries • Sorting fields in a query • Establishing query criteria • Designing queries with AND and OR conditions Continued

  6. Job 17-1 (continued) Jobs List • Designing queries with a calculated field • Using aggregate functions in a query • Creating transmittal memorandums • Applying bullets and numbering in Word

  7. Include All Fields in Query Jobs List In the Query Design window, click the asterisk in the table fields list. Click asterisk

  8. Query with Aggregate Functions Jobs List Query Tools/Design/Show/Hide/Totals 1. Query Tools/Design tab 3. Totals button 2. Show/Hide group

  9. Job 17-2: Manage Employee Data Jobs List • Renaming tables • Importing data from Excel • Inserting new fields • Deleting and creating relationships • Deleting database objects • Creating a split form

  10. Rename Table Jobs List • In the Navigation Pane, right-click the table name. • Select Rename and enter the new name.

  11. Show Table Jobs List Relationship Tools/Design/Relationships/ Show Table 1. Relationship Tools/Design tab 2. Relationships group 3. Show Table button

  12. Job 17-3: Manage Customer Information Jobs List • Creating a new database • Using the Lookup field property • Finding and replacing data • Finding data using Filter by Form

  13. Select the Lookup Wizard Jobs List • In Design View, click the Data Type arrow for the desired field. • Select Lookup Wizard. • Follow the steps in the Lookup Wizard. 1. Data Type arrow 2. Lookup Wizard

  14. Filter by Selection Jobs List Home/Sort & Filter/Selection 1. Home tab 3. Selection button 2. Sort & Filter group

  15. Clear All Filters Jobs List Home/Sort & Filter/Advanced/Clear All Filters 4. Clear All Filters 1. Home tab 2. Sort & Filter group 3. Advanced button

  16. Filter by Form Jobs List Home/Sort & Filter/Advanced/Filter By Form 4. Filter by Form 1. Home tab 2. Sort & Filter group 3. Advanced button

  17. Job 17-4: Manage Partner Information Jobs List • Analyzing data in Word • Designing a data entry form • Customizing form labels

  18. Partners Table in Design View Jobs List

  19. Job 17-5: Manage Vacation Requests Jobs List • Using the Form Wizard • Creating a subform • Using ActiveX controls • Customizing form footers and labels • Applying normalization rules • Creating command buttons

  20. Create Form with Form Wizard Jobs List Access 2010 • Click the Create tab. • In the Forms group, select Form Wizard. Access 2007 • Click the Create tab. • In the Forms group, select More Forms and then select Form Wizard.

  21. Add Gridlines Jobs List Access 2010 • Click the Form Layout Tools/ Arrange tab. • In the Table group, click Gridlines. Access 2007 • Click the Form Layout Tools/ Format tab. • In the Gridlines group, click Gridlines.

  22. Add Date and Time to Form Jobs List Access 2010 • Click the Form Design Tools/ Design tab. • In the Header/ Footer group, click Date and Time. Access 2007 • Click the Form Design Tools/ Design tab. • In the Controls group, click Date and Time.

  23. Form ActiveX Controls Jobs List Form Design Tools/Design/Controls/ ActiveX Controls 1. Form Design Tools Design tab 2. Controls group 3. ActiveX Controls button

  24. Control Wizards Jobs List END SHOW Form Design Tools/Design/Controls/Use Control Wizards 1. Form Design Tools/Design tab 2. Controls group 3. Use Control Wizards button

More Related