Examine basic Access database concepts and explore the Access environment; Design a simple Access database; Build a new Access database with related tables; Manage data in a
table; Query an Access database using different methods; Design basic Access forms; Generate Access reports.
Learn Access - Day 2 topics include:
Modify the design and field properties of a table; Retrieve data from tables using joins; Create flexible queries to display specified records, allow for user-determined
query criteria, and modify data using queries; Enhance the capabilities of forms by grouping form controls and
making other aesthetic improvements; Customize reports to organize the displayed information and produce
specific print layouts; Share data across different applications.
Learn Access - Day 3 topics include:
Restructure data into appropriate tables; Write advanced queries to analyze and summarize data; Create and revise Access macros; Display data more effectively in a form; Customize reports by using various Access features, making them
more effective; Maintain your database using tools provided by Access; Use Visual Basic Applications (VBA) to enhance Access.
