Database Introduction
The Database Program MS Access
- Starting Access
- The Access start screen
- Signing in to Office
Calling Commands
- The ribbon
- The File menu
- Icons
- Contextual tools
- Context menus
- Keys (shortcuts)
- Help
- Switching to other programs
- Exiting Access
Creating a New Table
- Preliminary considerations for a new table
- Datasheet view and design view
- Field names
- Field data types
- Field properties
Editing a Table
- Entering records
- The elements of a datasheet view
- Edit and navigation mode
- Changing the table display
Editing Data
- Copying a table
- Selection
- Undoing a change
- Insert and overwrite mode
- Deleting data
- Clipboards
- Copying data
- Cutting data
- Pasting data
- Find and Replace
- Font design
Printing Table Content
- Page view (print preview)
- Page setup
- Printing
- Closing the table
Changing the Table Structure
- Copying a table
- Changing the table design
- Freezing columns
- Editing Yes/No fields
- Editing Long Text fields
- Setting decimal separator, currency and date
Queries
- Query types
- Setting up a query
- Structure of the query window
- Adding fields in the design grid
- Displaying the result of a query
- The dynaset
- Changing the design grid
- Saving, closing and opening a query
Select Queries
- Criteria for text fields
- Filtering with an operator
- Condition for numeric fields
- Using wildcards * ? #
- Filtering by similar-sounding names
Query with Multiple Conditions
- BETWEEN value1 AND value2
- Conditions for the Date/Time type
- Conditions for Yes/No fields
- Criteria for Long Text fields (memo fields)
- Calculating with queries
Sorting and Filtering Records
- Sorting
- Indexing
- Filtering in the table
Forms
- Creating an AutoForm
- Form views
- Changing the form’s appearance
- Inserting a title
- Entering new records
Reports
- Report views
- Creating a report
- Changing the report’s appearance
- Design view
- Report properties
- Report view
- Print preview
Related Tables
- Data redundancy
- Relating tables
- Referential integrity
- Deleting a relationship
The Database File
- The Navigation Pane
- Saving, closing and opening a database
- Creating a new database
- Access file format
- Saving in a different database file type
Miscellaneous
- Field data types
- Field properties
- Lookup fields
- Setting an input mask
- Special features of email addressing
- Program startup settings
- Customising the Quick Access Toolbar
- Setting up the status bar
