A one-day workshop
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.
learning objectives
- 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
Session outline
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
- 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
- Report properties sheet
