Course description
This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports.
Upcoming start dates
Choose between 2 start dates
Suitability - Who should attend?
- No previous Access experience required.
- Designed for Office 365 versions: 2016, 2013 and 2010
Outcome / Qualification etc.
- Plan and create a database
- Sort and filter records
- Use field data types
- Work with tables
- Create and manage a query
- Create and work with forms, and use the form wizard
- View, create and print reports
Training Course Content
1 Access introduced
- Planning a database
- Creating a blank database
- Opening an existing database
- Security warnings
- The navigation pane
- Previewing database components
- Closing an Access database
2 Tables introduced
- Viewing and navigating table data
- Navigating using keyboard shortcuts
- Editing table data
- Adding records to tables
- Selecting and deleting records
- Finding and replacing data
- Filtering tables
- Summing table data
3 Queries introduced
- Opening a query in datasheet view
- Opening a query in design view
- Adding fields to a query
- Sorting query results
- Modifying datasheet view
- Saving and closing queries
4 Forms introduced
- Working with form data
- Sorting records
- Filtering records
- Working in design and layout views
- Changing object attributes
5 Reports introduced
- Opening and viewing reports
- Viewing a report in design view
- Previewing and printing report data
- Creating reports with auto report
- Creating reports with the report wizard
- Changing field attributes
6 Creating a new database
- Creating database tables
- Creating table fields
- Selecting field data types
7 Table relationships
- Introducing relationships
- Establishing table relationships
- The one-to-many relationship type
- Establishing referential integrity
8 Creating queries
- Streamline query criteria using wildcards
- Creating summary queries
- Creating queries based on criteria
- Running date queries
- Formatting field properties
- Building queries from multiple tables
- Summing in queries
9 Creating forms
- Creating a new form
- Inserting form fields
- Working with the property sheet
- The command button wizard
- The command button wizard
- Programming without typing
- Creating forms with embedded sub forms
- Creating forms with the sub form wizard
- Creating forms with the form wizard
10 Creating reports
- What are report bands?
- Managing report controls
- Basing reports on multiple tables
- Basing reports on queries
- Sorting and grouping records
Course delivery details
A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided.
Request info
The In-House Training Company
22 South Burgundy House, The Foresters, High Street
AL5 2FB Harpenden
The In-House Training Company
We offer top-quality in-house training, in a wide range of subjects, at sensible prices. All of our programmes are delivered by independent subject specialists who also have outstanding training skills. We have rigorous standards and only work with the very...
Ads