Where
Delta Center for Economic Development5501 Krueger Drive
Jonesboro, AR 72401
Driving Directions
Contact
Alan DeckerDelta Center for Economic Development
870-972-3000
dced@astate.edu
Payment information
Payment options
Credit or Debit Card- You may pay with a Credit or Debit Card before the first class date by calling the ASU cashiers window at 870-972-3847 between the hours of 8 a.m. and 5 p.m., Monday-Friday.
Pay By Check- Make checks out to: ASU Treasurer's Office - Delta Center. Include the name of the class, and student's name and the Delta Center in the memo line. Payment must be received prior to attending class. If you need to make other arrangements, please call (870) 680-4383.
Mail checks to:
ASU Treasurer's Office P.O. Box 2640 State University, AR 72467
We can also invoice your company upon request. Please provide purchase order if required.
Cancellation policy
If you are unable to attend a course for which you have registered, please provide a two-day notice of cancellation. A 50% cancellation fee is charged unless a 2-day notice is provided. No shows are billed at 100%. Substitutions are encouraged.Dates: Tuesday, March 31 & Thursday, April 2
Time: 5:30 PM-9:00 PM
Cost: $109.00 Call for information regarding ASU Faculty and Staff discounts- 870-680-4383.
Instructor: Sue Melton
This Intermediate level is intended to help those who are familiar with the basics of Access do more with their database. This class will also help more experienced users who have little to no experience with Access 2007 and the ribbon interface.
Highlights of the course include information on file management, including exporting and packaging files, advanced table creation, and management techniques. As well, we will provide in-depth information about creating forms, reports, and queries.
Advanced File Tasks
In this section, students will learn how to perform file management tasks using Windows Explorer and learn how to repair and encrypt database files. This section also covers the additional database formats supported by Access, how to export database information to a variety of different file formats, and how to link a database to other files.
Working with Tables
This section goes deeper into table creation and covers topics like table management. Topics include field properties, how to format tables, how to change field data types, and how to apply various tools to control what sort of data is permitted in a table. This section also expands on table data entry by explaining how to create and use lookup fields and value lists.
Working with Forms
Next, we will discuss the basics of creating forms using the Wizard as well as from scratch. Participants will learn how to work with form controls, format their form, and format the form controls, both in appearance and functionality. This section also introduces themes, which provide one-click customization.
Working with Reports
Students will learn how to create and use reports including formatting report sections, work with calculated controls, and group and sort report data. This section also discusses how to format reports, including themes, logos, and font changes. Finally, students will learn how to add images, page numbers, and apply conditional formatting.
Working with Queries
This final section will show how to use multiple tables in queries, create calculated controls, and use the Expression Builder. Finally, we will cover how to create and use parameter, crosstab, make-table, append, delete, and update action queries.