Full Day: In this course you will learn how to maintain data consistency and integrity; improve queries, forms and reports; and also how share Access with other applications.
Controlling Data Entry • Restrict Data Entry Using Field Properties • Establish a Pattern for Entering Field Values • Create a List of Values for a Field
Joining Tables • Create Query Joins • Join Unrelated Tables • Relate Data Within a Table
Improving Forms • Design a Form Layout • Enhance the Appearance of a Form • Restrict Data Entry in Forms • Add a Command Button to a Form • Create a Subform
Customizing Reports • Organize Report Information • Format the Report • Set Report Control Properties • Control Report Pagination • Summarize Report Information • Add a Subreport to an Existing Report • Create a Mailing Label Report
Sharing Data Across Applications • Import Data into Access • Export Data • Analyze Access Data in Excel • Export Data to a Text File
"Do one thing every day that scares you." -Eleanor Roosevelt
Safe Home Connections, a division of KidsTerrain, Inc. assists individuals with the option to age in place, that is, to live in one's home while having access to services and support as needs change.
Webinars are multi-media programs that enable you to view a presentation, lecture, or seminar from the comfort of your office or home. Available 24/7 via the Internet, webinars are an effective alternative to on-site presentations.
