This 1-day classroom course is suitable for anyone new to Microsoft Access. It takes you through designing and creating a databse from scratch in a hands-on way. Course notes are provided.
What you will learn
Designing and creating a Database • Creating a Table • Primary Key • Setting up Table Fields and applying Field Properties • Working between Design and Datasheet View • Entering new records • Selecting, deleting and editing data • Sort and Filter Data • Print Table data
Queries • Criteria and Expressions • Designing a Query in the Query By Example Grid • Sorting and Hiding • Writing criteria – comparison operators • Wildcard Searches
Creating and Customising Data Forms • Creating data entry forms • Entering and editing data via a form • Formatting Data Entry forms • Modifying form and form item properties
Creating and Customising Reports • Using the Report Wizard • Creating Reports from Tables and queries • Creating Grouped Reports • Modifying Report Designs